All Articles

Fixing Google Finance '#N/A' Error In Google Sheets


googlesheets

Problem

Summary

You’re using GoogleFinance inside Google Sheets, but you keep seeing #N/A & GoogleFinance Internal Error when trying to use the data it provides, causing calculation chaos.


Solution

Summary

It looks like the GoogleFinance API under the hood either needs to be aligned with your local country & timezone OR UK & UTC (GMT 00:00 No Daylight Saving).

For me those are the same thing, so I’ve been unable to clarify which exactly fixes the problem specifically, but setting UK & (GMT 00:00 No Daylight Saving) seems to get GoogleFinance working right away.

The sheet should refresh when you save the settings, and you should see all those beautiful numbers.

Example

Navigate to File -> Spreadsheet Settings.

Try the following settings:

googlefinance

Problem Solved?

If you have any questions you’d like to ask me about this post, feel free to reach me on Twitter or Github.

If you found this post useful and would like to show you’re appreciation, join the Brave movement and send me a tip :)