How to Use GOOGLEFINANCE in Google Sheets?
Easily access live stock prices and historical market data directly in your Google Sheets with the GOOGLEFINANCE function.
Formula Genius can generate a draft from a plain-English prompt. Supported formulas can be checked with sample cases; review the coverage on the result.
The formula
"Pull live stock prices, historical data, and market cap into a Google Sheet using GOOGLEFINANCE"
=GOOGLEFINANCE("GOOG", "price")The GOOGLEFINANCE function retrieves current or historical market data for a specified stock symbol.
Step-by-step breakdown
- Specify the stock symbol, e.g., 'GOOG' for Google.
- Choose the attribute you want, such as 'price', 'marketcap', or 'close'.
- Optionally, add a start date for historical data retrieval.
- Optionally, add an end date for historical data retrieval.
Edge cases & warnings
- Using an invalid stock symbol will return an error.
- Requesting data for a non-trading day will return no data.
- Exceeding the Google Sheets function call limits may cause errors.
- Historical data requests without valid dates will not return results.
Examples
"=GOOGLEFINANCE("AAPL", "price")"
Returns the current price of Apple Inc."=GOOGLEFINANCE("MSFT", "marketcap")"
Returns the market capitalization of Microsoft Corporation.Frequently asked questions
What stock symbols can I use?
You can use any valid stock symbol listed on major exchanges.
Can I get historical data?
Yes, by specifying a start and end date in the formula.
Why is my data not updating?
Data may not update if the market is closed or if there are connectivity issues.
Can't find what you need?
Describe a formula in plain English. Formula Genius drafts and explains it, and can check supported formulas on sample cases.