Why Dividend Data for Excel?
Stop copying and pasting financial data. The Dividend Data Excel Add-in brings institutional-quality financial data directly into your spreadsheets with simple formulas.
Built for Dividend Investors
30+ years of dividend history for thousands of stocks
Dividend growth rates (1, 3, 5, 10-year CAGRs)
Payout ratios (EPS and Free Cash Flow based)
Ex-dividend dates, payment dates, frequencies
Complete Fundamental Data
Financial statements — Income, Balance Sheet, Cash Flow (annual and quarterly)
100+ financial metrics — Revenue, EPS, Free Cash Flow, and more
50+ financial ratios — P/E, ROE, Debt/Equity, Current Ratio, etc.
Growth rates — Revenue growth, EPS growth, dividend growth
Use Cases
Dividend tracking spreadsheets — Monitor your portfolio income
Stock screeners — Build custom screens with real data
Valuation models — DCF, DDM, and comparable analysis
Research dashboards — Track metrics over time
Watchlists — Live prices and key metrics in one view
Function Reference
All Excel functions use the DIVIDENDDATA. namespace:
=DIVIDENDDATA.DIVIDENDS()- Dividend data=DIVIDENDDATA.DIVIDENDS_BATCH()- Batch dividend data=DIVIDENDDATA.STATEMENT()- Financial statements=DIVIDENDDATA.METRICS()- Financial metrics=DIVIDENDDATA.RATIOS()- Financial ratios=DIVIDENDDATA.GROWTH()- Growth metrics=DIVIDENDDATA.QUOTE()- Stock quotes=DIVIDENDDATA.QUOTE_BATCH()- Batch quotes=DIVIDENDDATA.PROFILE()- Company profiles=DIVIDENDDATA.FUND()- ETF/Fund data=DIVIDENDDATA.SEGMENTS()- Revenue segments=DIVIDENDDATA.KPIS()- Key performance indicators=DIVIDENDDATA.COMMODITIES()- Commodities data=DIVIDENDDATA.CRYPTO()- Cryptocurrency data=DIVIDENDDATA.PRICE_TARGET()- Analyst price targets=DIVIDENDDATA.ESTIMATES()- Analyst estimates
Excel vs Google Sheets
Key difference: Excel uses DIVIDENDDATA. namespace (dot notation) while Google Sheets uses DIVIDENDDATA_ (underscore).
Example: =DIVIDENDDATA.DIVIDENDS("MSFT") in Excel vs =DIVIDENDDATA("MSFT") in Sheets