STOCKHISTORY(stock, start_date [,end_date] [,interval] [,headers] [,properties] [..])

Returns the historical data about a financial instrument.

stockA ticker symbol in double quotes or a cell reference.
start_dateThe earliest date for which data is retrieved.
end_date(Optional) The latest date for which data will be retrieved.
interval(Optional) The interval each data value represents:
0 = daily (default)
1 = weekly
2 = monthly
headers(Optional) Whether to display headings:
0 = no headers
1 = show headers (default)
2 = show instrument identifier and headers
properties(Optional) The columns that are retrieved for each stock:
0 = Date
1 = Close
2 = Open
3 = High
4 = Low
5 = Volume

Remarks

* link - techcommunity.microsoft.com/t5/excel-blog/announcing-stockhistory/ba-p/1404338
* If "end_date" is left blank, then "start_date" is used.
* If "properties" is left blank, then 0,1 is used.
* You can have a maximum of 249 properties.
* For the Microsoft documentation refer to support.microsoft.com

 A
1=STOCKHISTORY("MSFT","04/01/2021",,,0,1) = 217.69
2=STOCKHISTORY("MSFT","04/01/2021",,,0) = {04/01/2021, $ , 217.69}


© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top