Is GOOGLEFINANCE real-time? The 20-minute delay, explained
Wondered why your Google Sheets prices lag the market? You're right: GOOGLEFINANCE is delayed 15-20 minutes. Here's why — and how to get live prices instead.
Free to start · no sign-up needed · real-time on every plan.
July 5, 2026 · 5 min read
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.
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 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 GOOGLEFINANCE real-time?
No. GOOGLEFINANCE prices are exchange-delayed by about 15-20 minutes for US stocks, and they only update while the sheet is open.
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.