You’re using GoogleFinance inside Google Sheets, but you keep seeing
GoogleFinance Internal Error when trying to use the data it provides, causing calculation chaos.
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.
Navigate to File -> Spreadsheet Settings.
Try the following settings:
If you found this post useful and would like to show you’re appreciation, join the Brave movement and send me a tip :)