Excel STOCKHISTORY Formula Generator

Retrieve historical stock price data, including open, high, low, close prices, and volume for a given stock symbol.

Enter the stock ticker symbol (e.g., MSFT for Microsoft). You can also use a cell reference (e.g., A1).
Select the exchange where the stock is traded. This helps ensure accurate data retrieval.
Enter the start date for historical data. Can be a date (e.g., "2024-01-01") or cell reference (e.g., B2).
Optional. Enter the end date. If omitted, only start date data is returned.
Select the frequency of data points to retrieve:
Choose how column headers should be displayed:
Select the data columns to include (default is Date and Close):

STOCKHISTORY Examples

Scenario Formula Remarks
Formula to get daily Apple closing prices =STOCKHISTORY("AAPL", "2020-01-01", "2020-01-10") Result is closing prices for Apple from Jan 1 to Jan 10, 2020
Get Open, High, Low, and Close prices for Microsoft =STOCKHISTORY("MSFT", "2024-01-01", "2024-01-10", 0, 1, 2, 3, 4, 1)
Get weekly high prices for Google =STOCKHISTORY("GOOGL", "2024-01-01", "2024-02-01", 1, 1, 3)
Volume data for Amazon =STOCKHISTORY("AMZN", "2024-01-01", "2024-01-10", 0, 1, 5)