Google Sheets pulling wrong price for TLT

[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 2449 times

For what it's worth, the calls to GoogleFinance for currency conversion are still working.

[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...

[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

[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.

[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

[dualstow]

A bit late, but here’s an official support page.
https://support.google.com/docs/thread/101835956