How to Get Stock Market Price Information in Excel

The STOCKHISTORY function is a new dynamic array function introduced in Excel 365. It allows you to retrieve historical stock prices and other information for a specified range of dates and a stock symbol.

The syntax for the function is as follows:

STOCKHISTORY(stock_symbol,[start_date],[end_date],[interval],[headers],[property])

Where:

·     stock_symbol: The symbol of the stock you want to retrieve information for. This can be a text string, cell reference or a range of cells.

·     start_date: (Optional) The start date of the period you want to retrieve information for. This can be a date or a reference to a cell containing a date. If omitted, the function will default to one year ago from today's date.

·      end_date: (Optional) The end date of the period you want to retrieve information for. This can be a date or a reference to a cell containing a date. If omitted, the function will default to today's date.

·      interval: (Optional) The frequency of the data to be returned. This can be "Daily", "Weekly" or "Monthly". If omitted, the function will default to "Daily".

·      headers: (Optional) A Boolean value indicating whether the function should return headers. If set to TRUE (default), the function will return headers.

·      property: (Optional) The type of information you want to retrieve. This can be "Open", "High", "Low", "Close", "Volume", "Adjusted Close", "Market Cap", "PE Ratio", "Dividend Yield" or "52-Week Range". If omitted, the function will default to "Close".

Here is an example usage of the function:

This formula will retrieve the weekly closing prices of Apple stock from January 1st, 2020 to February 27th, 2023. The function will return a dynamic array of cells containing the stock prices.