Dividend Yield (Historical)
Returns historical dividend yield for a company. This represents the annual dividend payment divided by the stock price at that time, expressed as a percentage. It shows the income return on investment from dividends.
Formula
Dividend Yield = (Annual Dividend Per Share / Stock Price) x 100Supported Symbols
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
| International | SYMBOL | SHOP, TSM |
Parameters
| Parameter | Description |
|---|---|
| Symbol | Stock ticker symbol |
| Year | Fiscal year (2020, 2021) or period code (lq, ly, lt) |
| Quarter | Optional: 1, 2, 3, or 4 for quarterly data |
| TTM | Optional: Set to "TTM" for trailing twelve months |
Interpretation
| Yield | Category |
|---|---|
| 0% | No dividend |
| 0-2% | Low yield (growth stocks) |
| 2-4% | Moderate yield |
| 4-6% | High yield |
| >6% | Very high yield (may indicate risk) |
Notes
- Yield varies inversely with stock price
- Very high yields may indicate dividend cut risk
- Historical yields reflect prices at that time
Examples
=hf_Dividend_Yield("AAPL", 2023)=hf_Dividend_Yield("KO", 2023, 2)=hf_Dividend_Yield("T", "ly")=hf_Dividend_Yield("JNJ", 2023, , "TTM")=hf_Dividend_Yield(A1, B1, C1)When to Use
- Analyzing dividend yield trends over time
- Income investing research
- Comparing historical yield levels
- Identifying yield expansion/compression
- Dividend growth investing analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need current yield | DividendYield() |
| Need dividend amount | DividendPerShare() |
| Need payout ratio | DividendPayoutRatio() |
| Need ex-dividend date | Ex_DividendDate() |
Common Issues & FAQ
Q: Why does yield vary so much? A: Dividend yield = Dividend / Price. As stock prices change, yields change inversely. A falling price increases yield even if dividend stays the same.
Q: Is a very high yield good? A: Very high yields (>8%) may indicate the market expects a dividend cut, or the stock has fallen significantly. Investigate before assuming it's attractive.
Q: Why am I getting "NA"? A: The company may not pay dividends, or dividend data may not be available for that period.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?