# What to use instead of GOOGLEFINANCE

Google Finance has had no API since 2012, and its Sheets function bars professional use, scripted history and, since September 2026, fund data.

*https://stockmarketstack.com/alternatives/googlefinance*

## The subject

| Field | Value |
| --- | --- |
| Product | GOOGLEFINANCE |
| Status | restricted |
| Website | https://www.google.com/finance |
| Category | Stock Market Data APIs |

The free Google Sheets function that pulls quotes, price history and a few ratios from Google Finance into a cell — the only programmatic door Google still leaves open.

## Replacements

*Ordered by how little work the switch takes, least first. Paid placement does not affect this order.*

1. [Wisesheets](https://stockmarketstack.com/tools/wisesheets.md) — The nearest formula-for-formula swap — WISEPRICE for prices and history, WISEFUNDS for NAV and expense ratio, in the same Sheets grid, for 60 dollars a year.
2. [Alpha Vantage](https://stockmarketstack.com/tools/alpha-vantage.md) — A free Google Sheets add-on and a free key. At 25 requests a day that covers a short watchlist, not a column of tickers.
3. [EODHD](https://stockmarketstack.com/tools/eodhd.md) — For the international exchanges GOOGLEFINANCE does not support — Sheets and Excel add-ons over 60-plus exchanges, end-of-day from 19.99 a month.
4. [Financial Modeling Prep](https://stockmarketstack.com/tools/financial-modeling-prep.md) — For everything past P/E and EPS. An official Sheets add-on over statements, ratios and estimates, free at 250 end-of-day calls a day.
5. [Stock Rover](https://stockmarketstack.com/tools/stock-rover.md) — For the fund screens that left Sheets in September 2026 — 40,000 mutual funds and 7,000 ETFs in a browser screener, leaving as CSV.

## 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](https://stockmarketstack.com/collections/spreadsheets) 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](https://stockmarketstack.com/tools/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](https://stockmarketstack.com/tools/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](https://stockmarketstack.com/tools/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](https://stockmarketstack.com/tools/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](https://stockmarketstack.com/how-to/get-fundamentals-into-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](https://stockmarketstack.com/tools/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.

## FAQ

### Is there a Google Finance API?

No. Google deprecated its Finance API on 26 May 2011, and by early 2013 the developer page read that the Google Finance APIs are no longer available, with a last-updated date of 22 October 2012. What remains is the GOOGLEFINANCE function inside Google Sheets, and it is a function, not an interface you can call from code.

### Why does GOOGLEFINANCE return N/A for a mutual fund?

Because Google withdrew fund data from it. Google's help page, as read on 3 October 2026, says mutual fund attributes are currently not supported in Google Sheets. An archived copy from 7 September 2026 still listed 19 of them, from net asset value and multi-year returns to the Morningstar star rating and the expense ratio. We found no announcement of the change.

### Can I read GOOGLEFINANCE history from Apps Script?

No. Google's help page says historical data cannot be downloaded or accessed via the Sheets API or Apps Script, and that a script which tries will see N/A in place of the values. Live attributes still compute in the cell, but a job that copies price history out of the sheet is the use Google has closed.

### Can I use GOOGLEFINANCE at work?

Not if you work in finance, and not if you are a professional at a non-financial firm either. Google's help page says the data is not for financial industry professional use or for use by other professionals at non-financial firms, government included, and the Google Finance disclaimer forbids using the data in a commercial enterprise without prior written consent.

### Does Google Finance let me export a portfolio or prices?

Not that Google documents. Its help pages describe building a portfolio by uploading a picture, a spreadsheet, a CSV or a PDF, and say nothing about getting data out. The disclaimer page says you agree not to download, store or redistribute the data without prior written consent.