How to make google spreadsheet refresh itself every 1 minute?

google-apps-script google-sheets google-finance
user781486 picture user781486 · Apr 8, 2014 · Viewed 99.4k times · Source

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.

Answer

rickcnagy picture rickcnagy · Apr 8, 2014

If you're on the New Google Sheets, this is all you need to do, according to the docs:

change your recalculation setting to "On change and every minute" in your spreadsheet at File > Spreadsheet settings.

This will make the entire sheet update itself every minute, on the server side, regardless of whether you have the spreadsheet up in your browser or not.

If you're on the old Google Sheets, you'll want to add a cell with this formula to achieve the same functionality:

=GoogleClock()

EDIT to include old and new Google Sheets and change to =GoogleClock().

Related questions

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
Google Sheets - googlefinance not working

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 …

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