Page 2 of 2
Re: Google Sheets pulling wrong price for TLT
Posted: Fri Mar 12, 2021 7:36 am
by Mark Leavy
As of last night, Google Sheets hasn't been pulling any equity prices in for me. I haven't made any changes to it.
Is anyone else having this issue? No amount of restarting my browser or reloading the page is fixing it.

- GoogleFinanceError.png (243.14 KiB) Viewed 2477 times
For what it's worth, the calls to GoogleFinance for currency conversion are still working.
Re: Google Sheets pulling wrong price for TLT
Posted: Fri Mar 12, 2021 7:53 am
by Cortopassi
All my data from Google shows N/A. Yesterday was fine. Must be a Google thing. Or maybe this is another feature we will now have to pay for...
Re: Google Sheets pulling wrong price for TLT
Posted: Fri Mar 12, 2021 7:56 am
by Cortopassi
This is why I have a complete backup of everything in Google photos and drive locally. Google should be a really safe place to keep things, but you never really know
Re: Google Sheets pulling wrong price for TLT
Posted: Fri Mar 12, 2021 10:50 am
by Tyler
Funny how a problem in a simple spreadsheet function can set the entire financial world on high alert. I get it!
If you depend on things like Google Sheets to pull daily price data, I saw a pretty
good idea on Bogleheads to make it more robust for times when the data service goes down. Basically, for any one ticker set up queries to pull the data from multiple sources. Then set an order of priority for what gets used.
Pull Google data.
iferror in Google data, pull Morningstar data.
iferror in Morningstar data, pull Yahoo data.
...and so on.
Data feeds are notoriously fickle and go down from time to time. But since it would be extremely rare for all of those sources to fail at once, that seems like an elegant way to always have data handy.
Re: Google Sheets pulling wrong price for TLT
Posted: Fri Mar 12, 2021 11:06 am
by Mark Leavy
Working for me also now. Thanks everyone!
Although, based on what I’m seeing, I might’ve preferred for it to stay down the rest of the day

Re: Google Sheets pulling wrong price for TLT
Posted: Fri Mar 12, 2021 11:26 am
by dualstow
A bit late, but here’s an official support page.
https://support.google.com/docs/thread/101835956