Google Sheets offers 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 the Spreadsheets data source to display market data on your Geckoboard dashboard.
Syntax of the GoogleFinance Function
To use this function, you'll need to understand the syntax so you can modify the function to meet your requirements. Here's the syntax for this function:
=GOOGLEFINANCE(ticker, [attribute], [start_date], [num_days|end_date], [interval])
ticker: The ticker symbol for the security to fetch data for
attribute: The attribute to fetch about
tickerfrom Google Finance (optional)start_date: The start date when fetching historical data (optional)
end_date|num_days: The end date when fetching historical data, or the number of days from
start_datefor which to return data (optional)interval: The frequency of returned data; either "DAILY" or "WEEKLY" (optional)
How to display Google's stock price on a dashboard
In this example, we'll use the GOOGLEFINANCE function and a Google Sheet Number Widget to display Google's current stock price on a dashboard.
To fetch Google's current stock price into Google Sheets, open a new Google Sheet and type the following formula into cell
A2:=GOOGLEFINANCE("GOOG", "price")
Set a name for your Google Sheet.
Head to Geckoboard and add a new Spreadsheets widget.
Select the Google Sheets file that you just saved and make sure you're on the tab where your data is stored.
Select the cell where your data is stored.
Make any other configuration changes, then click Save to add the widget to your dashboard.
If you'd like to set a specific refresh rate for your data, see this guide for more details.