3 min read · Updated 2026-10-28

GOOGLEFINANCE Not Working in Google Sheets? 7 Fixes

The GOOGLEFINANCE function is the easiest way to pull stock prices into Google Sheets, but it fails in confusing ways. Here are the most common problems and how to fix them.

1. Add the exchange to the ticker

Some tickers exist on more than one exchange, so Sheets cannot always guess which you mean. Write the exchange before the ticker: =GOOGLEFINANCE("NASDAQ:AAPL","price"). If you are not sure of the full symbol, search the stock on Google and copy the exchange and ticker shown at the top.

2. Put the attribute in quotes

Attributes such as price, name, changepct, high52 and low52 must be wrapped in quotation marks. =GOOGLEFINANCE(A2,"price") works; =GOOGLEFINANCE(A2,price) does not.

3. Check your separator (the semicolon problem)

In some regional settings Google Sheets expects a semicolon between arguments instead of a comma. If you copy a formula from a tutorial and get a parse error, change the commas to semicolons, or change the locale under File, then Settings.

4. Leave room for historical data

Asking for historical prices returns a small table with a header row. If cells below or beside the formula are not empty you will see an error saying the result was not expanded because it would overwrite data. Clear the cells or move the formula.

5. Pull a single value from a historical table

To get just one closing price, wrap the function in INDEX:

=INDEX(GOOGLEFINANCE("NASDAQ:AAPL","close",DATE(2026,1,2)),2,2)

The function returns a two-row table (header and data), so row 2, column 2 is the closing price on that date.

6. Remember the data is delayed and not universal

Prices can be delayed by up to about 20 minutes, and not every security, exchange or crypto asset is supported. If a ticker keeps returning #N/A even with the right exchange code, it may simply not be available through the function.

7. Wait, refresh and avoid overloading the sheet

Large sheets with hundreds of GOOGLEFINANCE calls can load slowly and sometimes show temporary errors. Reload the sheet, and consider keeping live prices to one column that the rest of your sheet refers to.

Building a portfolio on top

Once prices work, a basic tracker needs columns for ticker, shares, cost, current price, value and gain. Value is =C2*E2 and gain is =F2-D2. For a simple walkthrough of the underlying sheet layout, our guide to building in Google Sheets covers the same formula habits.

Prefer a finished tracker?

The GridX Investment Tracker is a ready-made Google Sheets layout. Here is the Etsy listing. This is general spreadsheet help, not investment advice.

Frequently asked questions

Why does GOOGLEFINANCE show #N/A?

The most common causes are a missing exchange prefix on the ticker, a ticker the function does not support, or a temporary data problem. Try the format NASDAQ:AAPL and reload the sheet.

How do I get just one historical price from GOOGLEFINANCE?

Wrap it in INDEX, for example =INDEX(GOOGLEFINANCE("NASDAQ:AAPL","close",DATE(2026,1,2)),2,2), which returns the closing price from the second row and second column of the table.

Is GOOGLEFINANCE real time?

No. Prices can be delayed by up to about 20 minutes, so it is not suitable for time-critical trading decisions.

Related guides

• How to Make a Budget in Google Sheets (Step by Step)
• Debt Snowball Spreadsheet for ADHD: Build One in Google Sheets
• How to Track Subscriptions in a Spreadsheet (and Cancel the Ones You Forgot)

Planner that goes with this guide: Investment Tracker. All guides