Why is GOOGLEFINANCE delayed?
GOOGLEFINANCE prices are about 15–20 minutes behind. Here's why — and how to get genuinely real-time stock and crypto prices in a spreadsheet instead.
Free · no sign-up needed · real-time on every plan.
July 15, 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: yes, it's delayed ~15–20 minutes
The GOOGLEFINANCE function in Google Sheets returns US stock prices delayed by roughly 15–20 minutesduring market hours. It's free and convenient, but the number you see is not the current price — it's where the stock was a quarter-hour ago.
Why it's delayed: real-time data isn't free
Real-time exchange data is licensed, and it costs money. Exchanges make a delayed version — the standard ~15–20 minute feed — freely available, and that's what free tools use. GOOGLEFINANCE is a free feature inside Google Sheets, so it serves that delayed data. Getting the actual current price means using a source that pays for a real-time feed.
The second delay you don't notice: it freezes when the tab closes
There's a second, sneakier staleness. GOOGLEFINANCE only recalculates while the sheet is open and actively refreshing. Close the tab or step away and the last value just sits there — so a “live” dashboard you glance at in the morning can be showing yesterday's number until it recalculates.
So how do you get real-time prices in a spreadsheet?
Two realistic paths:
- A paid Google Sheets add-on (Finsheet, Market Data, MarketXLS, Wisesheets) — real-time is a paid tier, and you still install the add-on and write formulas. Their free tiers are delayed or capped.
- Stealth Quotes — a spreadsheet-style grid where real-time stock and crypto prices stream into the cells, with no formulas, no add-on, and no cost. Type a ticker, get a live price.
| GOOGLEFINANCE | Paid add-ons | Stealth Quotes | |
|---|---|---|---|
| Real-time (not delayed) | 15–20 min | ||
| Free | |||
| No formulas / no add-on | |||
| Live crypto included | |||
| Current the moment you reopen |
The takeaway
GOOGLEFINANCE is free and fine for a rough check, but it's ~15–20 minutes behind and freezes when you close the tab. If you want the current price, you need a real-time source: a paid Google Sheets add-on, or Stealth Quotes — real-time stock and crypto in a spreadsheet-style grid, free, with no formulas.
Keep reading
Frequently asked questions
Is GOOGLEFINANCE delayed?
Yes. GOOGLEFINANCE prices are delayed by about 15–20 minutes for US stocks. It also only recalculates while the sheet is open, so the numbers freeze the moment you close the tab.
Why is GOOGLEFINANCE delayed?
Because it uses free, exchange-delayed market data — the standard ~15–20 minute lag that comes with not paying for a real-time feed. It also only recalculates while the sheet is open and refreshing, so the numbers freeze the moment you close the tab.
How delayed is GOOGLEFINANCE exactly?
About 15–20 minutes for US equities during market hours. On top of that, GOOGLEFINANCE only updates while the sheet is open and refreshing, so if you close the tab the last value just sits there — effectively infinitely stale until you reopen it.
Can you make GOOGLEFINANCE real-time?
No — there's no setting that removes the delay from the built-in function. To get real-time prices you either pay for a Google Sheets add-on, or use a spreadsheet-style app where live prices are built in, like Stealth Quotes — real-time, free, and no formulas.
How do I get real-time stock prices in a spreadsheet?
Two ways: a paid Google Sheets add-on (Finsheet, Market Data, Wisesheets — real-time is a paid tier, and you install an add-on and write formulas), or Stealth Quotes, a spreadsheet-style app where real-time stock and crypto prices stream into the cells with no formulas, no add-on, and no cost.
Skip the delay — real-time in a spreadsheet, free.
Open the sheet, type a ticker, watch it stream. No add-on, no formulas, no sign-up.