A GOOGLEFINANCE alternative that does dividends, crypto & real-time
GOOGLEFINANCE has no dividend attribute, breaks on most crypto, and is delayed 15–20 minutes. Stealth Quotes fixes all three — a spreadsheet- style tracker with real-time prices and no formulas.
Free to start · no sign-up needed · real-time on every plan.
Can GOOGLEFINANCE track dividends?
No — there's no dividend attribute.GOOGLEFINANCE can return a price, but it can't give you a stock's dividend, dividend yield, or the dividends you've received. The usual workaround is scraping another site with IMPORTXML, which is brittle and breaks whenever that page changes.
Stealth Quotes does dividends natively: enter your shares (or log your buys and sells) and it computes the dividends you've actually received, your yield on cost, and estimated annual income — automatically, no formulas.
Why isn't Bitcoin or crypto price working in Google Sheets?
Because GOOGLEFINANCE only supports a handful of top coins and returns errors (“#N/A”, “no data available”) for most of the rest. If you hold anything beyond the majors, it simply won't resolve.
Stealth Quotes handles crypto natively and in real time. Type a .X suffix — BTC.X, SOL.X — and the live price appears next to your stocks, in the same grid.
Is GOOGLEFINANCE real-time?
No — its prices are exchange-delayed by about 15–20 minutes, and they only update while the sheet is open. Stealth Quotes is real-time and keeps streaming even when the tab is closed.
| GOOGLEFINANCE | Stealth Quotes | |
|---|---|---|
| Dividends & dividend yield | ||
| Dividends received (auto) | ||
| Live crypto (beyond top coins) | ||
| Real-time (not 15–20 min delayed) | ||
| Portfolio return / XIRR | ||
| No formulas to build or break | ||
| Keeps updating when tab is closed |
Keep reading
Frequently asked questions
Can GOOGLEFINANCE track dividends?
No — GOOGLEFINANCE has no dividend attribute, so it can't return a stock's dividend, dividend yield, or the dividends you've received. People work around it with fragile IMPORTXML/IMPORTHTML scrapes of other sites, which break often. Stealth Quotes tracks dividends natively: dividends received, yield on cost, and estimated annual income — no formulas.
Why isn't the Bitcoin (or crypto) price working in Google Sheets?
GOOGLEFINANCE only supports a small set of top cryptocurrencies and frequently returns errors like '#N/A' or 'no data' for anything beyond them. Stealth Quotes handles crypto natively and in real time — type a .X suffix (e.g. BTC.X, SOL.X) and the live price appears.
Is GOOGLEFINANCE real-time?
No. GOOGLEFINANCE prices are exchange-delayed by about 15–20 minutes for US stocks, and they only refresh while the sheet is open. Stealth Quotes shows real-time prices that update within a second or two, and keeps streaming even when you're not looking.
How do I track dividends in a spreadsheet?
Because GOOGLEFINANCE can't do it, most spreadsheets either skip dividends or rely on manual entry and web-scraping formulas. Stealth Quotes does it for you: enter your shares (or log your trades) and it computes the dividends you've received, your yield on cost, and estimated income automatically.
Why does GOOGLEFINANCE show #N/A or 'no data available'?
Usually the ticker format is wrong, the symbol or attribute isn't supported (dividends, most crypto, some international listings), or the data is temporarily missing. Stealth Quotes avoids the whole class of formula errors — there are no formulas to break; you type a ticker and get a price.
Skip the formulas. Just type a ticker.
Real-time stocks and crypto, dividends, and your full portfolio — free to start, no sign-up needed.