The Best GOOGLEFINANCE Alternative for Dividend & Stock Data
Works alongside GOOGLEFINANCE — not a replacement.
Your existing GOOGLEFINANCE formulas keep working. Dividend Data adds the data Google cannot provide.
What GOOGLEFINANCE Does Well
GOOGLEFINANCE is excellent for real-time stock prices, volume, market cap, and 52-week highs. It is built into Google Sheets with zero setup. For simple price lookups, it is hard to beat.
Where GOOGLEFINANCE Falls Short
- No dividend history, yield, or ex-dividend dates
- No P/E ratio, payout ratio, or financial ratios
- No income statement, balance sheet, or cash flow data
- No earnings per share or revenue data
- No analyst estimates or price targets
- No growth rates or multi-year CAGRs
- Returns #N/A errors with no explanation
- Google Sheets only — no Excel support
Side-by-Side Comparison
| What You Want | GOOGLEFINANCE | Dividend Data |
|---|---|---|
| Live stock price | ✓ =GOOGLEFINANCE("AAPL","price") | ✓ =DIVIDENDDATA_QUOTE("AAPL","price") |
| Dividend yield | ✗ Not available | ✓ =DIVIDENDDATA_DIVIDENDS("AAPL","dividendYield") |
| P/E ratio | ✗ Not available | ✓ =DIVIDENDDATA_RATIOS("AAPL","peRatio") |
| Payout ratio | ✗ Not available | ✓ =DIVIDENDDATA_RATIOS("AAPL","payoutRatio") |
| Income statement | ✗ Not available | ✓ =DIVIDENDDATA_STATEMENT("AAPL","income",TRUE) |
| Free cash flow | ✗ Not available | ✓ =DIVIDENDDATA_METRICS("AAPL","freeCashFlow") |
| Revenue growth | ✗ Not available | ✓ =DIVIDENDDATA_GROWTH("AAPL","RevenueGrowth") |
| Analyst price target | ✗ Not available | ✓ =DIVIDENDDATA_ESTIMATES("AAPL","priceTarget") |
| Historical data | Limited (1 year) | ✓ 30+ years |
| Excel support | ✗ Google Sheets only | ✓ Both Sheets and Excel |
How to Migrate From GOOGLEFINANCE
Install the free Dividend Data add-on for Google Sheets or Excel.
Your existing GOOGLEFINANCE formulas still work — no need to change them.
Replace =GOOGLEFINANCE("AAPL","price") with =DIVIDENDDATA_QUOTE("AAPL","price") for more reliable data.
Add the data GOOGLEFINANCE cannot provide: =DIVIDENDDATA_DIVIDENDS("AAPL","dividendYield") and =DIVIDENDDATA_RATIOS("AAPL","peRatio").
Example Formula
Works Alongside GOOGLEFINANCE
Free plan · No credit card · Google Sheets + Excel
Frequently Asked Questions
Does Dividend Data work alongside GOOGLEFINANCE, or do I have to choose?
You can use both at the same time. Dividend Data does not replace GOOGLEFINANCE — it extends it. Your existing GOOGLEFINANCE formulas keep working. Simply add DIVIDENDDATA functions for the data GOOGLEFINANCE cannot provide, like dividend yield, payout ratio, and financial statements.
Will switching from GOOGLEFINANCE break my existing spreadsheet?
No. GOOGLEFINANCE and Dividend Data are completely independent. You can add Dividend Data formulas to any cell without touching existing GOOGLEFINANCE formulas. There is no migration required.
Is Dividend Data free like GOOGLEFINANCE?
Yes — Dividend Data has a permanent free tier with 2,500 data credits per month. No credit card required. For heavier usage, paid plans start at $89/year (Hobby) and $399/year (Pro). GOOGLEFINANCE is free because it is built into Google Sheets; Dividend Data is free because it offers a free tier add-on.
Why does GOOGLEFINANCE not have dividend data?
Google has never added dividend-specific data to GOOGLEFINANCE. The function focuses on price, volume, and basic market data. Dividend yield, payout ratio, and ex-dividend dates require financial data feeds that Google has not integrated.
Can I use Dividend Data in Microsoft Excel?
Yes. Dividend Data is available for both Google Sheets (via Google Workspace Marketplace) and Microsoft Excel (via Microsoft AppSource). GOOGLEFINANCE only works in Google Sheets. Dividend Data is the only solution if you prefer Excel.
What's the difference between Dividend Data and STOCKHISTORY in Excel?
STOCKHISTORY is a native Excel function for historical price data — similar to GOOGLEFINANCE. It does not support dividend data, financial ratios, or financial statements. Dividend Data extends Excel with 50+ metrics that STOCKHISTORY cannot provide.