How to Use GOOGLEFINANCE in Google Sheets?
Live Stock Prices in Google Sheets is a Google Sheets function that the googlefinance function retrieves current or historical market data for a specified stock symbol.. Formula Genius generates and validates this formula automatically from a plain-English prompt.
Easily access live stock prices and historical market data directly in your Google Sheets with the GOOGLEFINANCE function.
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 any formula in plain English and Formula Genius will generate, explain, and validate it — instantly.