Constantly updating stock prices

Note: We've found that, a few times a week, a server error will occur on Google's end and the script will fail to run.

By default, you'll receive an email to notify you that this has happened.

House of Representatives Speaker Paul Ryan on Wednesday left the door open to a possible delay in implementing a huge corporate tax cut, following a media report that his fellow Republicans in the Senate are exploring the option.

Strong company reports bolstered European shares on Wednesday though banking stocks weighed as doubts around U. tax reform plans dented investor sentiment in the sector, and Credit Agricole fell after reporting a fall in profits.

Google Sheets has a built-in function called GOOGLEFINANCE which fetches current or historical securities information from Google Finance to a Google Sheet.

This article details how this function can be used with our Spreadsheets integration to display market data on your Geckoboard dashboard.

This isn't particularly helpful so we've written a script that you can adapt to update the market data every minute, even when the Google Sheet is closed.