GOOGLEFINANCE
TheGOOGLEFINANCE
formula is used to retrieve market data from Google Finance. This formula can be used to retrieve stock quotes, currency exchange rates, futures, and mutual funds. It is most commonly used to retrieve stock quotes. The formula requires a ticker symbol as input and can also take additional optional parameters such as the attribute to retrieve, the start and end dates, and the interval of time between data points.
 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:
 ticker (required):
The ticker symbol of the security to retrieve data for. This can be a stock, fund, futures contract, or currency.  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.  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.  end_datenum_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.  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
Here are a few example use cases that explain how to use theGOOGLEFINANCE
formula in Google Sheets.
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
GOOGLEFINANCE
not working? Here are some common mistakes people make when using the GOOGLEFINANCE
Google Sheets Formula:
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 yyyymmdd.
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.