Home › Functions › Information › STOCKHISTORY
fx
STOCKHISTORY
Information  ·  Since: Microsoft 365  ·  9 languages

The STOCKHISTORY function retrieves historical data about a financial instrument and loads it as an array, which will spill if it's the final result of a formula. This means that Excel will dynamically create the appropriate sized array range when you press ENTER.

🌐 Translations

English STOCKHISTORY
Deutsch BÖRSENHISTORIE
Français HISTORIQUE.ACTIONS
Español HISTORIALCOTIZACIONES
Italiano CRONOLOGIA.AZIONI
Português HISTÓRICODEAÇÕES
Nederlands AANDELENGESCHIEDENIS
Polski HISTORIA.AKCJI
Русский ИСТОРИЯАКЦИЙ

📦 Availability

Excel versionAvailable
Excel 2007 ✗
Excel 2013 ✗
Excel 2019 ✗
Excel 2021 ✗
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

STOCKHISTORY(stock,start_date,[end_date],[interval],[headers],[property0],[property1],[property2],[property3],[property4],[property5])

Arguments

stock (required) — Function returns historical price data about the financial instrument corresponding to this value. Enter a ticker symbol in double quotes (e.g., "MSFT") or a reference to a cell containing the Stocks data type. This will pull data from the default exchange for the instrument. You can also refer to a specific exchange by entering a 4-character ISO market identifier code (MIC), followed by a colon, followed by the ticker symbol (e.g., "XNAS:MSFT"). Learn more about our data sources.
start_date (required) — The earliest date for which data is retrieved. Note that if interval is not 0 (daily), the first data point may be earlier than the start_date provided - it will be the first date of the period requested.
end_date (optional) — The latest date for which data will be retrieved. Default is start_date.
interval (optional) — Specifies the interval each data value represents as follows: 0 = daily, 1 = weekly, 2 = monthly. Default is 0.
headers (optional) — Specifies whether to display headings as follows: 0 = no headers, 1 = show headers, 2 = show instrument identifier and headers. Default is 1 (i.e, show headers). When included, headers are rows of text that are part of the array returned from the function.
property0 - property5 (optional) — The columns that are retrieved for each stock as follows: 0 = Date, 1 = Close, 2 = Open, 3 = High, 4 = Low, 5 = Volume. If any of them is present, only the indicated columns are returned in the order provided. Default is 0,1 (i.e., Date and Close).

▶ Examples

=STOCKHISTORY(stock,start_date,[end_date],[interval],[headers],[property0],[property1],[property2],[property3],[property4],[property5])

Related functions

Copied to clipboard