
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.
Google finances how to#
GoogleFinance function in action Example: How to display Google's stock price on a dashboard Interval: (Optional)- The frequency of returned data either "DAILY" or "WEEKLY". Start_date: (Optional) - The start date when fetching historical data.Įnd_date|num_days: (Optional) - The end date when fetching historical data, or the number of days from start_date for which to return data. Ticker: The ticker symbol for the security to consider.Īttribute: (Optional - "price" by default ) - The attribute to fetch about ticker from Google Finance. The Office of the Commissioner of Financial Regulation, established in 1910, is Marylands consumer financial protection agency and financial services.

Here's the syntax of the GOOGLEFINANCE function: CIBC Mobile BankingCIBCFREE - On Google Play. If this isn't fast enough for your needs, you can run a script and set your own refresh interval. on how to prepare for retirement while taking into account both your financial and emotional wellbeing. Note: Widgets powered by spreadsheets using the GoogleFinance function refresh approx. This article details how this function can be used with our Spreadsheets data source to display market data on your Geckoboard dashboard. Simplify your finances with our services including bank accounts, mortgages, credit cards, savings and insurance.

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