Google Sheets - googlefinance not working

google-apps-script google-sheets google-finance google-finance-api
Syed Mohammed Mehdi picture Syed Mohammed Mehdi · Mar 27, 2018 · Viewed 9.3k times · Source

I have one google sheet using googlefinance function on multiple stocks. It was working fine until this morning. Now, googlefinace is not giving output for all stocks and giving output for only some of the stocks. Please share, if is anyone else facing the same issue?

Answer

Swagga Ting picture Swagga Ting · Mar 27, 2018

I am experiencing the same issue. For some symbols I am getting #N/A, and for others I am getting ridiculous values.

Looks like there is a thread here: https://productforums.google.com/forum/#!topic/docs/W-vvAbH8nMo

And to upvote this bug for Google to see, you can go here: https://issuetracker.google.com/issues/76403135

Related questions

How to make google spreadsheet refresh itself every 1 minute?

My google spreadsheet is using GOOGLEFINANCE('symbol','price) function to retrieve stock prices of my portfolio. Unfortunately, I have to refresh manually now. How can I make the spreadsheet refresh itself every 1 minute? Thank you for your help.

Read More
Google finance 200 day moving average is getting as #NA in Apps Script

I'm calculating Google finance 200 day moving average formula in google sheet using formula =average(query(sort(GoogleFinance("GOOG","price", TODAY()-320, TODAY()),1,0),"select Col2 limit 200")) Then in google app script I'm getting the above cell value in variable as below …

Read More
How to get the correct range to set the value to a cell?

I want to set text or number in Google Sheet from script. I want to set Hello or number 9 in cell F2. I found this code so far: SpreadsheetApp.getActiveRange().setValue('hello'); but that doesn't specify which cell.

Read More