Why is GOOGLEFINANCE delayed?

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.

This is the part almost no one explains. Real-time exchange data is licensed, and how you useit changes the price dramatically. There's a line between two things:

• Display — showing a price on screen for a person to look at. Comparatively cheap to license.
• Redistribution — handing someone the raw price value as data they can copy, reference in other formulas, and export. This carries far higher exchange fees (often per user).

GOOGLEFINANCE drops the raw value straight into an editable cell — that's squarely on the redistribution side. Serving that in real time, to millions of spreadsheets, for free, would be enormously expensive. So Google does the economical thing: it delays the function's data 15–20 minutes, which keeps it in the free, delayed-data tier. The delay isn't a technical limitation — it's the price of handing you exportable data for nothing.

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.

Two paths, and they map neatly onto that same licensing line:

• Pay for the redistribution. A Google Sheets add-on (Finsheet, Market Data, MarketXLS, Wisesheets) sells you real-time data on a paid tier — you cover the licensing. You install the add-on and still write formulas, and their free tiers are delayed or capped.
• Stay on the display side. A tool that only displaysprices — no export of the raw feed, no API — keeps the cheaper display-only license, so it can stream prices live for free. That's exactly how Stealth Quotes works: a spreadsheet-style grid where real-time stock and crypto prices stream into the cells, with no formulas and no add-on.

GOOGLEFINANCE is delayed because it gives you the data, not just the picture — and real-time data costs money to redistribute. If you only need to see live prices (and track a portfolio), a display-only tool sidesteps that cost entirely. If you need the raw numbers inside a real Google Sheet for models, a paid add-on is the honest answer.