GOOGLEFINANCE vs Excel STOCKHISTORY
They get compared constantly, but they don't do the same job: one returns a single delayed value for free, the other returns historyand needs a Microsoft 365 subscription. Here's the honest side-by-side.
Free · no sign-up needed · real-time on every plan.
October 3, 2026 · 6 min read
| A | B | C | D | |
|---|---|---|---|---|
| 1 | SYMBOL | NAME | PRICE | Δ% |
| 2 | Apple Inc. | … | ||
| 3 | Bitcoin | … | ||
| 4 |
Those are real, live prices — no formula, no sign-up. Edit any ticker, or type one in the empty row (stocks or for crypto).
Open the full sheet →The short answer
They're not really competitors. GOOGLEFINANCEfills one cell with one value — a delayed price, volume, market cap — and it's free with any Google account. STOCKHISTORY spills a table of past prices across a date range, and it needs a paid Microsoft 365 subscription.
If you want a watchlist, GOOGLEFINANCE is the closer fit. If you want to chart two years of closes in Excel, STOCKHISTORY is. Neither one is real-time.
| GOOGLEFINANCE | STOCKHISTORY | Stealth Quotes | |
|---|---|---|---|
| Cost | Free | Needs M365 | Free |
| Current price in a cell | |||
| Historical series | |||
| Real-time (not delayed) | |||
| Updates on its own | |||
| Works without a subscription | |||
| Crypto beyond the top coins | |||
| No setup / no formulas |
Cost: free vs a subscription
GOOGLEFINANCE is free — any Google account, any browser, nothing to install. STOCKHISTORY and the Stocks data type are Microsoft 365-only: on perpetual Office (2019, 2021, 2024) the function doesn't exist, which is why so many people hit #NAME?and assume it's broken (more on those errors).
What each one actually returns
- GOOGLEFINANCE — one value per call:
=GOOGLEFINANCE("AAPL","price"). It has a fixed list of attributes (price, volume, marketcap, pe…), and no dividend attribute at all. - STOCKHISTORY — a spilled array:
=STOCKHISTORY("MSFT",DATE(2024,1,1),TODAY())gives you a dated table of closes. For a current quote in Excel you use the separate Stocks data type, which is delayed ~15 minutes and refreshes only when you run Refresh All.
Delay: both are behind the market
This is the part people miss when choosing between them. Neither is real-time. GOOGLEFINANCE is exchange-delayed 15–20 minutes, and Excel's data type runs on a similar delay — plus it won't move at all until you refresh it. Picking between them is picking between two flavours of late.
Crypto: both are weak
GOOGLEFINANCE handles crypto through CURRENCY:BTCUSD and covers only a few major coins; Excel reaches crypto through its Currencies data type with comparable limits. If you hold anything outside the top names, both will leave you with blanks and errors.
Want a current price instead of a late one? Type a ticker and watch it stream — stocks and crypto, no subscription, no formulas. Free, no sign-up.
Try it free →Which should you pick?
- Quick, free watchlist in a browser→ GOOGLEFINANCE. It's the lower-friction option and costs nothing.
- Historical analysis in Excel, and you already pay for 365→ STOCKHISTORY. That's what it's built for, and it does it well.
- You actually want the current price, updating on its own→ neither. That's a different kind of tool.
That last case is why Stealth Quotes exists: a spreadsheet where the prices are streamed in real time instead of fetched by a formula. Type a ticker in column A and the live price appears beside it — stocks and crypto, no Microsoft 365, no #N/A, no refresh button.
Keep reading
Frequently asked questions
What's the difference between GOOGLEFINANCE and STOCKHISTORY?
GOOGLEFINANCE returns a single (delayed) value in a cell — a current-ish price, volume, market cap and so on — and it's free. Excel's STOCKHISTORY returns a historical series of prices over a date range, requires a Microsoft 365 subscription, and isn't meant for a current quote at all.
Is STOCKHISTORY real-time?
No. STOCKHISTORY is a historical function — it returns past prices, typically end-of-day. For a current-ish quote in Excel you'd use the Stocks data type instead, which is delayed about 15 minutes and only refreshes when you tell it to.
Which is better for tracking a watchlist?
GOOGLEFINANCE, if you only have those two options — it gives you a per-ticker value in a cell, free, with no subscription. But it's delayed 15–20 minutes and stops updating when the sheet is closed, so neither is a real live watchlist.
Do either of them handle crypto well?
Not really. GOOGLEFINANCE covers only a handful of major coins through its CURRENCY: syntax, and Excel's coverage comes through the Currencies data type with similar limits. For anything beyond the top coins, both return errors or nothing.
What should I use if I want real-time prices?
Neither function can give you real-time data — both are built on delayed feeds. A streaming tool like Stealth Quotes shows real-time stock and crypto prices in a spreadsheet-style grid with no formulas, no subscription, and no refresh button.
Neither late nor locked behind a subscription.
Real-time stock and crypto prices streamed into a spreadsheet — no M365, no formulas, no refresh. Free, no sign-up.