GOOGLEFINANCE

• How to use GOOGLEFINANCE formula?
• Examples of using GOOGLEFINANCE formula
• GOOGLEFINANCE formula not working?
• Similar formulas to GOOGLEFINANCE

Usage

Use the GOOGLEFINANCE formula with the syntax shown below, it has 1 required parameter and 4 optional parameters:

=GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])

1. ticker (required):
   The ticker symbol of the security to retrieve data for. This can be a stock, fund, futures contract, or currency.
2. attribute (optional):
   The type of data to retrieve, such as price, market capitalization, or volume. If this parameter is not specified, the formula will retrieve the current price by default.
3. start_date (optional):
   The start date of the data to retrieve. If this parameter is not specified, the formula will retrieve data from the earliest available date.
4. end_date|num_days (optional):
   The end date of the data to retrieve or the number of days of data to retrieve. If this parameter is not specified, the formula will retrieve data up to the current date.
5. interval (optional):
   The interval of time between data points, such as daily, weekly, or monthly. If this parameter is not specified, the formula will retrieve data at the default interval for the security type.

Examples

Retrieve the current stock price

To retrieve the current stock price for a given ticker symbol, simply use the GOOGLEFINANCE formula with the ticker symbol as the first parameter.

Retrieve historical stock prices

To retrieve historical stock prices for a given timeframe, use the GOOGLEFINANCE formula with the ticker symbol as the first parameter, the start and end dates as the third and fourth parameters, and the "Close" attribute as the second parameter.

Convert currencies

To convert between two currencies, use the GOOGLEFINANCE formula with the ticker symbol for the currency exchange rate as the first parameter, the "price" attribute as the second parameter, and the amount to convert as a separate cell reference. Multiply the exchange rate by the amount to get the converted value.

Common Mistakes

Incorrect Ticker Symbol

One common mistake is using an incorrect ticker symbol for the stock or security you want to track. Double check that the symbol you are using is correct.

Incorrect Attribute

Another common mistake is using an incorrect attribute in the formula. Make sure you are using a valid attribute for the type of data you want to retrieve.

Invalid Date Format

If you are using start and end dates in the formula, make sure they are in the correct date format. The formula uses the format yyyy-mm-dd.

Missing Parameters

Make sure you are including all required parameters in the formula. If a parameter is optional, you can leave it blank by including an empty set of parentheses, but make sure to include all necessary commas.

Unsupported Ticker or Attribute

Not all tickers or attributes are supported by the GOOGLEFINANCE formula. Check the documentation for a list of supported securities and data types.

Related Formulas

The following functions are similar to GOOGLEFINANCE or are often used with it in a formula:

• GOOGLETRANSLATE

  The GOOGLETRANSLATE formula is a Google Sheets function that can be used to translate text from one language to another. This formula uses Google's translation service to automatically detect the source language and translate it to the target language specified by the user. This function is most commonly used to translate text from one language to another without leaving the Google Sheets application.

Learn More

You can learn more about the GOOGLEFINANCE Google Sheets function on Google Support.