Is Google Finance real-time? No — it's delayed 15-20 minutes
Wondered why your Google Sheets prices lag the market? You're right: Google Finance (the GOOGLEFINANCEfunction) is delayed 15-20 minutes. Here's exactly how much, how to check it, and how to get live prices instead.
Free · no sign-up needed · real-time on every plan.
July 5, 2026 · Updated Aug 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 →Is GOOGLEFINANCE real-time?
No. For US stocks, GOOGLEFINANCE prices are exchange-delayed by roughly 15-20 minutes. The number in your cell isn't the current price — it's where the stock was a quarter of an hour ago.
How much is Google Finance delayed?
It depends on the asset — but for most things you'll track, it's not live:
- US stocks & ETFs — delayed about 15-20 minutes.
- Many foreign / international stocks — often worse, and some are end-of-day only.
- Mutual & index funds— priced once a day at NAV (that's normal for funds, not a GOOGLEFINANCE quirk).
- Crypto— GOOGLEFINANCE's coverage is limited and also lags; it was never built for 24/7 markets.
Why is it delayed?
Real-time market data costs money; exchanges charge for it. GOOGLEFINANCE uses the free, delayed feed instead — the same ~15-20 minute lag you see on many free finance sites. It's a data-licensing choice, not a bug.
And it freezes when the sheet is closed
There's a second catch: GOOGLEFINANCE only recalculates while the sheet is open and refreshing. Close the tab and the numbers freeze at their last value; reopen and they reload (sometimes flashing #N/Afor a moment). So even the delayed price only moves when you're actively looking.
How to check if your Google Sheets prices are delayed
Quick test: put a ticker in a cell with =GOOGLEFINANCE("AAPL"), then open the same stock on a real-time source (your broker, or an exchange page). During market hours you'll usually see the two numbers differ by a few cents to a few dollars — that gap isthe delay. If they match exactly, the market just hasn't moved in the last 15-20 minutes.
How to get real-time prices in a spreadsheet
Two realistic options:
- A paid Sheets add-on(MarketXLS, Finsheet, and the like) — real-time, but you're still building formulas inside a real spreadsheet.
- Stealth Quotes— real-time stock and crypto prices in a spreadsheet-style grid, with no formulas and nothing to set up. Prices update live, and keep streaming even when the tab isn't in front of you.
A 15-20 minute delay is fine for a slow, long-term glance — but if you're reacting to the market, it's not the current price, and that gap matters.
Keep reading
Frequently asked questions
Is Google Finance real-time?
No. Google Finance (the GOOGLEFINANCE function) shows exchange-delayed prices — about 15-20 minutes behind for US stocks — and they only update while the sheet is open.
How much is Google Finance delayed?
About 15-20 minutes for US stocks and ETFs. Many foreign stocks lag more or are end-of-day only, and mutual/index funds price just once a day at NAV.
Does Google Finance update in real time?
No — the price you see is roughly 15-20 minutes old, and it stops updating the moment you close the sheet. It's fine for a slow glance, not for reacting to the market.
Is Google Finance data accurate?
It's accurate for what it is — a delayed snapshot. The number is real, just ~15-20 minutes old, so it can differ from the live price by cents to dollars while the market moves.
Why is GOOGLEFINANCE delayed?
It uses free, exchange-delayed market data — the standard ~15-20 minute lag that comes with not paying for a real-time feed.
Do GOOGLEFINANCE prices update when the sheet is closed?
No. It only recalculates while the sheet is open and refreshing, so prices freeze the moment you close the tab.
How do I get real-time stock prices in a spreadsheet?
Either pay for a Google Sheets add-on (and still build formulas), or use a tool like Stealth Quotes that shows real-time prices in a spreadsheet-style grid with no formulas.
See the real price, not a 20-minute-old one.
Real-time stocks and crypto in a spreadsheet-style grid — no formulas. Free, no sign-up needed.