Dividend Data is a spreadsheet add-in that pulls 30+ years of stock market data for 80,000+ tickers directly into Google Sheets and Microsoft Excel, eliminating manual copy-paste.
What is Dividend Data?
Dividend Data lets investors type custom formulas in any cell to instantly retrieve dividends, financial statements, ratios, and 100+ metrics. It accepts a ticker symbol and a data point (e.g., =DIVIDENDDATA_DIVIDENDS("AAPL","fwd_yield")) and returns the live value. The add-in runs inside Google Sheets and Microsoft Excel and is developed by DividendData.com.
Key Features
- Instant formulas — 16+ custom functions covering dividends, statements, metrics, ratios, quotes, batch queries, and more. Each formula returns a single value or a full table.
- 30+ years of history — Access annual and quarterly data for income statements, balance sheets, cash flow, dividend history, and ratios.
- Batch mode — Pull data for 50+ stocks at once with one formula (e.g.,
=DIVIDENDDATA_DIVIDENDS_BATCH). One call fills an entire watchlist.
- Quick Actions sidebar — One-click table loading for statements, dividends, key metrics, ratios, KPIs, and price targets. No formulas needed. Free users get 5/month; paid plans get unlimited.
- 30+ years of data — Financial statements, dividend histories, and ratios reach back three decades.
- Free tier — 2,500 credits/month with no credit card required. Each cell formula = 1 credit. Attributed watermark on free plan.
- Works in both platforms — Google Sheets (4.9 stars) and Microsoft Excel (5.0 stars). Documentation available: Google Sheets Docs → and Excel Docs →.
Who is it for?
- Dividend income investors — Track yields, ex-dates, payout ratios, and growth rates for a portfolio of 35+ stocks automatically.
- Financial analysts — Screen 200+ stocks weekly using batch formulas and historical ratio tables.
- DIY spreadsheet users — Replace
GOOGLEFINANCE limitations with live, searchable data for any US-listed ticker.
What can you do with Dividend Data?
- Build a portfolio tracker: Pull forward yield, ex-dividend date, 5-year CAGR, and payout ratio for each holding in seconds. Example:
=DIVIDENDDATA_DIVIDENDS("MSFT","fwd_yield") → 0.72%.
- Load full financials instantly: Use Quick Actions to insert an income statement, balance sheet, or cash flow for any stock with one click. 30+ years of annual and quarterly data.
- Screen stocks with ratios: Compare P/E, ROE, debt-to-equity, and profit margins across a watchlist by using batch formulas or the Ratios Quick Action tab.
How does it work?
- Create a free account — Sign up with email; no credit card required.
- Install the add-in — From Google Workspace Marketplace or Microsoft AppSource (takes 30 seconds).
- Type a formula — Enter
=DIVIDENDDATA_* in any cell, pick a ticker and a data point, and the value appears instantly.
Pricing
Freemium with four tiers:
| Tier | Price | Credits/month | Key limits |
|---|
| Free | $0 | 2,500 | 5 Quick Actions/month, 5 years history, watermark |
| Hobby | $89/year | 25,000 | Unlimited Quick Actions, 30+ years, batch functions |
| Pro (Most Popular) | $399/year | 150,000 | Terminal web app, estimates, segments, KPIs, crypto, commodities |
| MAX | $1,599/year | 1,000,000 | Commercial license, dedicated support |
30-day money-back guarantee on all paid plans.
FAQ
Is there a free tier?
Yes. The Free plan gives 2,500 credits/month with 5 Quick Actions, 5 years of data, and an attribution watermark. No credit card required.
What counts as a credit?
Each cell that uses a Dividend Data formula consumes one credit when the formula recalculates. A typical investor tracking 25 stocks × 8 metrics × 10 refreshes/month uses ~2,000 credits.
