Dividend Yield (TTM)

Returns the trailing twelve month (TTM) dividend yield for a stock. The dividend yield represents the annual dividend income relative to the stock's current price.

Calculation

Dividend Yield = (Annual Dividends Per Share / Stock Price) * 100

Return Value

The function returns a decimal value:

  • 0.025 = 2.5% yield
  • 0.05 = 5% yield
  • 0.10 = 10% yield

Supported Symbol Formats

Type Format Example
US Stocks SYMBOL AAPL, T, VZ
ETFs SYMBOL VYM, SCHD
REITs SYMBOL O, VICI

Notes

  • Returns 0 or "NA" for non-dividend paying stocks
  • TTM means it uses the last 12 months of actual dividend payments
  • Does not predict future dividends

Examples

=DividendYield("AAPL")
Apple dividend yield (low ~0.5%)
=DividendYield("T")
AT&T dividend yield (high ~6%)
=DividendYield("O")
Realty Income REIT yield
=DividendYield("VYM")
Vanguard High Dividend ETF yield
=DividendYield(A1)
Symbol from cell reference
=DividendYield("AAPL")*100
Convert to percentage (0.52%)

When to Use

  • Screening for income-producing stocks
  • Comparing dividend yields across stocks
  • Building income-focused portfolios
  • Evaluating REIT and dividend ETF yields

When NOT to Use

Scenario Use Instead
Need forward-looking yield ForwardAnnualDividendYield()
Need dividend dollar amount DividendRate()
Need 5-year average yield FiveYearAverageDividendYield()
Need payout ratio DividendPayoutRatio()

Common Issues & FAQ

Q: Why is the yield showing as a small decimal like 0.025? A: The yield is expressed as a decimal, not a percentage. Multiply by 100 to get the percentage: =DividendYield("AAPL")*100

Q: Why am I getting 0 or "NA"? A: The company likely does not pay dividends (e.g., growth stocks like AMZN, TSLA).

Q: Why is the yield different from what I see on financial websites? A: This is TTM (trailing twelve months). Some sites show forward yield. Also, stock price changes affect yield in real-time.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Dividend Yield (TTM) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions