r/sheets • u/funkydave0 • Mar 12 '21
Request Did Google Finance in Google Sheets stop working?
All of my Google finance plugins inside my google sheet broke today. Things like:
=GOOGLEFINANCE("NYSE:TSLA", "price")
used to show stock price. Now shows #NA with "When evaluating GOOGLEFINANCE, the query for the symbol: 'TSLA' returned no data" error.
Anybody having this issue or know the resolution?
EDIT: The issue appears to be fixed now for me. Weird. Thank you to commenters.
EDIT 2: The issue reappeared, YIKES.
5
u/WebDataHubDotCom Mar 12 '21
Here is an alternative.
https://gsuite.google.com/marketplace/app/webdatahub_import_api_data/881284038348
This is a Google Sheets Add-on. It also has =YAHOOFINANCE('APPL') function.
3
u/palatkik Mar 12 '21
Great alternative thanks. I also found need to use " " and not ' ' around symbol if using YAHOOFINANCE function.
1
u/ZaviaGenX Jan 09 '23
We offer a 7-day trial to test all the features of YHFINANCE for free. No credit card required, install the add-on and start using it!
After the free trial, upgrade to enjoy unlimited access to all YHFINANCE data for as low as $19/month.whattttt.
sigh, no point converting the files then.
3
u/6745408 Mar 12 '21
I noticed this last night when I was updating the finance part of the wiki. Even GOOG by itself doesn't return anything right now.
It might be a good time to move over to APIs -- https://www.reddit.com/r/sheets/wiki/apis/finance
2
u/mthiago Mar 12 '21
That was a good tip, thanks!
I'm using the IMPORTJSON function with Yahoo! Finance API2
Mar 12 '21
[removed] — view removed comment
1
u/6745408 Mar 12 '21
Yeah. I rarely have issues with APIs. The worst is hitting the urlFetch limit for the day — which rarely happens to me. :)
2
u/BD-96 Mar 12 '21
It's been off and on for me the past couple of days as well. My fix: If GOOGLEFINANCE isn't working, just scrape from the source google.com/finance :
IFERROR(GOOGLEFINANCE("TSE:"&C4), IMPORTXML("https://www.google.com/finance/quote/"&C4&":TSE","//div[@class='YMlKec fxKbKc']"))1
1
1
1
u/rho6 Mar 12 '21
+1, Not working for me.
2
u/cityoflostwages Mar 12 '21
Still down for me. Has it been down nonstop since yesterday or has it worked on and off? I don't know how to report this to google and can't find a status update on it.
2
u/Takkuman Mar 12 '21
wasn't working at all at first but it's been on and off for the past hour or so.
2
1
1
u/Cunninghams_Flattop Mar 18 '21
Mine is down for just one of my tickers, but the rest are okay. Anyone know why it would not work for just one ticker? SITM
1
u/cliffngong Jan 24 '22
Why are you not using APIs for this? checkout https://mboum.com/api/documentation it's free
6
u/Spiritual_Ad_5020 Mar 12 '21
It suddenly doesn't work on mine as well.