What GOOGLEFINANCE does and does not do
The function returns current and historical prices and a set of attributes (price, volume, market cap, P/E, EPS, 52-week range, currency rates and mutual-fund data) with a formula such as `=GOOGLEFINANCE("NASDAQ:AAPL", "price")` or `=GOOGLEFINANCE("AAPL", "close", DATE(2026,1,1), TODAY(), "DAILY")`. Its limits, per Google's help page and 2026 reviews: prices are delayed up to about 20 minutes and never stream; there are no income statements, balance sheets or cash-flow statements; options, many international tickers and ETF holdings are missing; and data cannot be exported from the function to other apps. That is enough for a watchlist and a simple portfolio, not for a valuation model.
| Capability | GOOGLEFINANCE | Wisesheets | YHFINANCE | MarketXLS | Market Data | Free API via Apps Script |
|---|---|---|---|---|---|---|
| Real-time prices | No (delayed) | Yes | Yes | Yes | Yes | Depends on API |
| Historical prices | Yes | 30+ years | Yes | Yes | 15 years | Yes |
| Financial statements | No | Up to 20 years | Yes | Yes | Limited | Yes (FMP, EDGAR) |
| Options chains | No | Limited | Yes | Full chains with Greeks | Yes | Depends |
| ETF and fund data | Basic | Yes | Yes | Yes | Yes | Depends |
| Cost | Free | Paid tiers | Free trial; ~$19/mo+ | Paid | Free with subscription | Free tiers with limits |
| Setup | None | Install add-on | Install add-on | Install add-on | Install add-on | Script and API key |