GOOGLEFINANCEformula 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
- Examples of using
GOOGLEFINANCEformula not working?
- Similar formulas to
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_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.
- 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.
ExamplesHere are a few example use cases that explain how to use the
GOOGLEFINANCEformula 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.
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.
GOOGLEFINANCEnot working? Here are some common mistakes people make when using the
GOOGLEFINANCEGoogle 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.
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.
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.
The following functions are similar to
GOOGLEFINANCE or are often used with it in a formula:
GOOGLETRANSLATEformula 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.
You can learn more about the
GOOGLEFINANCE Google Sheets function on Google Support.