DIVIDENDDATA
What It Does
Retrieves various dividend-related data for a single stock symbol. This is the core function for dividend investors — use it to analyze a company's dividend payments, yields, growth trends, and sustainability through payout ratios.
Why It's Useful
As a dividend investor, you need to track not just current yields but also dividend growth history, payout sustainability, and upcoming payment dates. This function gives you all of that in a single formula, whether you need a quick metric or a full historical table.
Syntax
=DIVIDENDDATA(symbol, metric, showHeaders)
Parameters
Parameter | Required | Default | Description |
symbol | Yes | - | Stock ticker symbol (e.g., "MSFT") |
metric | No | "fwd_payout" | The dividend metric to retrieve |
showHeaders | No | FALSE | Include headers in history or growth tables |
Available Metrics
Metric | Description |
fwd_payout | Forward annual payout |
ttm_payout | TTM payout |
fwd_yield | Forward dividend yield |
ttm_yield | TTM dividend yield |
next_dividend | Next declared payout amount |
next_dividend_full | Table: Amount, Decl Date, Ex Date, Pay Date, Frequency |
frequency | Payment frequency |
ex_div_date | Most recent ex-dividend date |
payment_date | Most recent payment date |
declaration_date | Most recent declaration date |
history | Historical dividend table |
summary | Summary table with all key metrics |
growth | Growth rates table |
1y_cagr | 1-year CAGR |
3y_cagr | 3-year CAGR |
5y_cagr | 5-year CAGR |
10y_cagr | 10-year CAGR |
payout_ratio | EPS payout ratio |
fcf_payout_ratio | FCF payout ratio |
Examples
Get forward dividend yield:
=DIVIDENDDATA("MSFT", "fwd_yield")Output: 0.008 (0.8%)
Get ex-dividend date:
=DIVIDENDDATA("MSFT", "ex_div_date")Output: 2025-11-19
Get full dividend history with headers:
=DIVIDENDDATA("MSFT", "history", TRUE)Output: Table with Declaration Date, Record Date, Payment Date, Adjusted Dividend, Dividend, Growth Rate, Frequency
Get dividend summary:
=DIVIDENDDATA("MSFT", "summary")Output: Table with Annual Dividend (FWD), Dividend Yield (FWD), Annual Dividend (TTM), Dividend Yield (TTM), Payment Frequency, Next Dividend, Declaration Date, Ex-Div Date, Payment Date, 1/3/5/10 Year CAGRs, Payout Ratios
Get 5-year dividend growth rate:
=DIVIDENDDATA("KO", "5y_cagr")Output: 0.035 (3.5% annual growth)
Get payout ratio:
=DIVIDENDDATA("JNJ", "payout_ratio")Output: 0.45 (45% of earnings paid as dividends)