What to use instead of GOOGLEFINANCE

The product

Google Finance is two things that share a name. One is the website, which Google rebuilt around AI research and charting — testing began on 8 August 2025 and Google's blog announced it out of beta on 25 June 2026. The other is the GOOGLEFINANCE function in Google Sheets, which is the reason this page exists: for a lot of people it is where stock data lives, because it is free, needs no key and is already in the spreadsheet.

There has been no API behind either since 2012. Google's documentation recorded the Finance API as "officially deprecated as of May 26, 2011", and an archived copy of the developer page from January 2013 reads "The Google Finance APIs are no longer available", last updated 22 October 2012.

What the function does is described on Google's Docs Editors Help page, read on 3 October 2026. GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval]) returns a live attribute — price, open, high, low, volume, market cap, P/E, EPS, 52-week range, beta, shares outstanding — or a daily or weekly history of open, high, low, close and volume. The same page fences it on five sides:

• "Real-time price quote, delayed by up to 20 minutes", and "solely for informational purposes, not for trading purposes or advice."
• "The data is not for financial industry professional use or use by other professionals at non-financial firms (including government entities)."
• It "does not support most international exchanges", requires the exchange prefix — NASDAQ:GOOG, not GOOG — and no longer takes Reuters codes such as XYZ.AX.
• "Historical data cannot be downloaded or accessed via the Sheets API or Apps Script." A script that tries gets #N/A.
• "Mutual fund attributes are currently not supported in Google Sheets." This is new. An archived copy of the same page from 7 September 2026 still listed 19 fund attributes — NAV date, net assets, one-week to five-year total returns, distributions, the Morningstar star rating and the expense ratio — with a worked example. Somewhere in the following four weeks the list went and that sentence replaced it. We found no announcement from Google.

Google's Finance disclaimer page names who supplies the numbers — end-of-day prices from Morningstar, corporate actions and company metadata from Refinitiv, intraday data possibly from ICE Data Services — and adds a term the help page does not: "You agree not to copy, modify, reformat, download, store, reproduce, reprocess, transmit or redistribute any data or information found herein or use any such data or information in a commercial enterprise without obtaining prior written consent."

That is the status on this page. Nothing has been switched off for the person who types a ticker into a cell to see a price. Everything past that — a script, a fund, an exchange outside the majors, a model at work — is where the terms stop it.

What to use instead

The list is ordered by how little has to change, because the people who arrive here usually have a sheet that broke rather than a data strategy. Everything except the last pick stays in the spreadsheet. The spreadsheets collection lists every card with an add-in; this page is about which of them replaces which of the function's limits.

If you want the same sheet with different formulas, Wisesheets is the shortest move. Its documentation gives WISEPRICE for live and historical prices and dividend dates and WISEFUNDS for fund fields such as NAV and expense ratio — the pair closest to what GOOGLEFINANCE did and to the fund half it just dropped — and every function takes ranges, so a column of tickers is one formula. Pro is 60 dollars a year, billed annually, individual use only.

If the budget is zero, Alpha Vantage publishes a free Google Sheets add-on whose functions all start AV, on a free key. The free key is 25 requests a day, which is the honest test: a sheet that only needs a handful of closes survives on it, and one that recalculates a hundred rows does not.

If the exchange is the problem, EODHD is the one to look at — Sheets and Excel add-ons over 60-plus exchanges, with end-of-day prices for all of them from 19.99 a month. Real-time streaming is the US and 18 European markets; everywhere else is a 15–20 minute delayed quote on every plan.

If what you were really after was fundamentals, GOOGLEFINANCE never had them: P/E and EPS are as deep as it goes. Financial Modeling Prep has an official Sheets add-on over statements, ratios and estimates, free at 250 end-of-day calls a day. The how-to on fundamentals in a spreadsheet covers that job in full.

If the funds were the point, the cheap answer is to stop doing fund research in a cell. Stock Rover covers 40,000 mutual funds and 7,000 ETFs alongside North American stocks, names Morningstar as its primary data source — the supplier Google names for fund data too — and exports tables to CSV, metered by plan. Full fund reports are only on its Ultimate tier; below that they are a sample.

What you give up

Free, with nobody counting. GOOGLEFINANCE has no key, no plan and no per-day cap of its own. Every pick here meters something — Alpha Vantage at 25 requests a day free, Financial Modeling Prep at 250, EODHD's paid plans at 100,000 calls a day with fundamentals costing ten each — and a spreadsheet recalculating on every edit spends a quota faster than a script does.

Last-sale prices from NYSE and Nasdaq at no charge. Google's disclaimer marks those exchanges real-time for trades that execute on them, with consolidated volume 15 minutes behind. The cheap tiers of the replacements are mostly delayed: EODHD's quote is 15–20 minutes on its end-of-day plans and Alpha Vantage's first paid plan is 15-minute delayed at 49.99 a month, with real-time from 99.99.

Zero setup. No add-on to authorise, no key to paste into a task pane, nothing that stops working when a card expires. That convenience is exactly what the terms pay for — and it is the thing people underestimate when they move a shared sheet to an add-in that resolves against one person's account.

Migration notes

None of the cheap plans is a professional licence either. The reason many readers leave is that GOOGLEFINANCE excludes professional use. Wisesheets Pro and Elite are individual-use, with commercial use only on a quoted Enterprise tier; EODHD's 19.99–99.99 plans are labelled personal use, with commercial licensing from 399 a month. Moving a work model off GOOGLEFINANCE onto a personal plan swaps one licence problem for another.

Ticker formats change. GOOGLEFINANCE wants EXCHANGE:SYMBOL, and each provider here has its own convention for exchanges and share classes. Build a mapping column once rather than editing formulas by hand, and check class shares and non-US listings first — they are where two providers disagree.

Dates can shift by a day. Google's help page says it treats dates passed to the function as noon UTC, so exchanges that close before then may land on the previous or next day. A history rebuilt from another provider will not line up row for row with an old GOOGLEFINANCE pull, and the difference is the convention rather than the data.

Paste the old history as values before you rewire it. A GOOGLEFINANCE range is a live array: replace the formula and the numbers go with it. If an old series matters — a backtest you trust, a chart you have published — keep a values-only copy before switching, so you can compare the new provider against it.