Dividend Data extends Google Finance™ in Google Sheets™ — adding 30+ years of real financial data, the deepest dividend coverage of any spreadsheet add-on, and a free tier that never expires.

=GOOGLEFINANCE() is great for real-time prices. Dividend Data picks up where it leaves off: financial statements, dividend history, analyst estimates, ratios, EPS, free cash flow, and 100+ more data points — with simple formulas that feel right at home in Sheets.

📺 YouTube tutorials: youtube.com/@DividendData
📔 Full documentation: https://www.dividenddata.com/documentation
🆘 Help Center: help.dividenddata.com

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🆓 FREE TIER — No credit card. No trial expiry. Start immediately after install.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

➤ Function Builder: generate any formula visually — no syntax needed
➤ Quick Action Sidebar: click a stock, click a category, click Load Data — full table inserted instantly
➤ Batch mode: pull data across your entire portfolio with one formula
➤ Also available for Microsoft Excel — same functions, same data

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

✅ DIVIDENDS — The deepest dividend data of any spreadsheet add-on

Built for dividend investors, dividend growth portfolios, income trackers, and dividend snowball calculators. No other spreadsheet tool comes close.

- Forward dividend yield & TTM yield
- Annual forward & TTM payout
- Ex-dividend date, payment date, declaration date
- Next declared dividend amount + full details
- Payment frequency (monthly / quarterly / annual)
- 30+ years of full dividend history
- Dividend growth CAGR: 1Y, 3Y, 5Y, 10Y
- EPS payout ratio & Free Cash Flow payout ratio
- Dividend summary — every metric in one table

=DIVIDENDDATA_DIVIDENDS("AAPL", "fwd_yield")
=DIVIDENDDATA_DIVIDENDS("KO", "5y_cagr")
=DIVIDENDDATA_DIVIDENDS("PG", "summary", TRUE)
=DIVIDENDDATA_DIVIDENDS("O", "ex_div_date")
=DIVIDENDDATA_DIVIDENDS("JNJ", "payout_ratio")
=DIVIDENDDATA_DIVIDENDS("MSFT", "history", TRUE)
=DIVIDENDDATA_DIVIDENDS("VZ", "fcf_payout_ratio")

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

✅ BATCH DIVIDENDS — Your whole portfolio in one formula

=DIVIDENDDATA_DIVIDENDS_BATCH("AAPL,MSFT,KO,JNJ,PG", "all", TRUE)
=DIVIDENDDATA_DIVIDENDS_BATCH("O,MAIN,ARCC", "yield", TRUE)
=DIVIDENDDATA_DIVIDENDS_BATCH("SCHD,VYM,JEPI,DVY", "fwd_payout,yield", TRUE)
=DIVIDENDDATA_DIVIDENDS_BATCH("T,VZ,MO", "history")

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

✅ FINANCIAL STATEMENTS — 30+ years, annual & quarterly

Income Statement, Balance Sheet, Cash Flow. Standardized. Annual, quarterly, or TTM.

=DIVIDENDDATA_STATEMENT("MSFT", "income", TRUE, "annual", "2024")
=DIVIDENDDATA_STATEMENT("AAPL", "balance", TRUE, "quarter")
=DIVIDENDDATA_STATEMENT("NVDA", "cash_flow", TRUE, "ttm")

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

✅ FINANCIAL METRICS — 100+ individual data points

Revenue, GrossProfit, Ebitda, Ebit, OperatingIncome, NetIncome, Eps, EpsDiluted, FreeCashFlow, CapEx, TotalAssets, TotalLiabilities, TotalDebt, LongTermDebt, CashAndCashEquivalents, ShareholdersEquity, DividendsPaid, and 80+ more.

=DIVIDENDDATA_METRICS("AAPL", "Revenue", TRUE, "annual")
=DIVIDENDDATA_METRICS("MSFT", "FreeCashFlow", FALSE, "ttm")
=DIVIDENDDATA_METRICS("KO", "Ebitda", TRUE, "quarter")

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

✅ FINANCIAL RATIOS — 50+ valuation, profitability & debt ratios

P/E, P/B, P/S, EV/EBITDA, Debt/Equity, Current Ratio, Quick Ratio,
ROE, ROA, ROIC, Gross Margin, Net Margin, Operating Margin, Interest Coverage.

=DIVIDENDDATA_RATIOS("AAPL", "peRatio")
=DIVIDENDDATA_RATIOS("KO", "debtEquityRatio")
=DIVIDENDDATA_RATIOS("JNJ", "returnOnEquity")
=DIVIDENDDATA_RATIOS("T", "dividendYield")

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

✅ GROWTH METRICS

=DIVIDENDDATA_GROWTH("MSFT", "revenueGrowth", TRUE, "annual")
=DIVIDENDDATA_GROWTH("NVDA", "netIncomeGrowth", TRUE, "quarter")
=DIVIDENDDATA_GROWTH("AAPL", "epsGrowth", FALSE, "ttm")

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

✅ STOCK QUOTES — Real-time & historical price data

Price, open, close, high, low, volume, market cap, 52-week high/low,
50-day MA, 200-day MA, beta, and full price history.

=DIVIDENDDATA_QUOTE("AAPL", "price")
=DIVIDENDDATA_QUOTE("MSFT", "summary", TRUE)
=DIVIDENDDATA_QUOTE("SPY", "history", TRUE, "2024-01-01", "2024-12-31")
=DIVIDENDDATA_QUOTE_BATCH("AAPL,MSFT,GOOG,AMZN,META", "price", TRUE)

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

✅ ANALYST DATA — Price targets & earnings estimates

=DIVIDENDDATA_PRICE_TARGET("AAPL", "consensus")
=DIVIDENDDATA_PRICE_TARGET("MSFT", "summary", TRUE)
=DIVIDENDDATA_ESTIMATES("NVDA", "summary", "annual", TRUE)
=DIVIDENDDATA_ESTIMATES("KO", "next_year_eps_growth")

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

✅ ETF & FUND DATA

=DIVIDENDDATA_FUND("SCHD", "holdings", TRUE)
=DIVIDENDDATA_FUND("VYM", "summary", TRUE)
=DIVIDENDDATA_FUND("JEPI", "sectorAllocation", TRUE)

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

✅ COMPANY KPIs, PROFILES, REVENUE SEGMENTS, CRYPTO & COMMODITIES

=DIVIDENDDATA_KPIS("MSFT", "summary", TRUE)
=DIVIDENDDATA_PROFILE("AAPL", "summary", TRUE)
=DIVIDENDDATA_SEGMENTS("AAPL", "product", TRUE)
=DIVIDENDDATA_CRYPTO("BTCUSD", "price")
=DIVIDENDDATA_COMMODITIES("GCUSD", "price")

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

📋 BUILT FOR

- Dividend portfolio trackers & income calculators
- Dividend snowball models
- Dividend Aristocrats, Kings & Champions screeners
- Stock watchlists with live yields & payout ratios
- DCF and valuation models
- ETF comparisons: SCHD vs VYM vs JEPI vs DIVO
- Retirement income planning spreadsheets
- DRiP (Dividend Reinvestment) trackers
- Financial statement analysis
- Google Finance™ power users who need deeper data

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🔗 ALSO FOR MICROSOFT EXCEL
Same functions, same data. Uses dot separator: =DIVIDENDDATA.DIVIDENDS()
Docs: github.com/divdatdev/DividendData-Excel-Docs

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

RELEASE NOTES

Mar 2026 (v2.0): Full 16-function library launched. Function Builder, Quick Action Sidebar, dark/light mode. Excel parity. Free tier introduced.
Dec 2025: Early access. Core dividend functions. 30+ years of history. Batch pulls.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

DISCLAIMER: Not financial advice. Data provided 'as is' for informational purposes only.

Google Finance™ is a trademark of Google LLC.
Google Sheets™ is a trademark of Google LLC.