STOCKHISTORY
Retrieves historical data about a financial instrument
Syntax
STOCKHISTORY(stock, start_date, [end_date], [interval], [headers], [properties])
Parameters
- stock: Required. The ticker symbol or instrument identifier
- start_date: Required. The start date for the historical data
- end_date: Optional. The end date for the historical data. Defaults to today
- interval: Optional. 0=daily (default), 1=weekly, 2=monthly
- headers: Optional. 0=no headers, 1=show headers (default), 2=instrument and headers
- properties: Optional. 0=Date/Close (default), 1=Open, 2=High, 3=Low, 4=Close, 5=Volume
Example
=STOCKHISTORY("MSFT", "1/1/2024", "3/1/2024", 0, 1, 0)