STOCKHISTORY

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 (default)
1 = Close (default)
2 = Open
3 = High
4 = Low
5 = Volume

REMARKS
* This function was added in Microsoft 365.
* The "stock" can be a text ticker symbol or a Stock Data Type.
* The "start_date" must be a weekday that the markets were open.
* The "start_date" format must match your regional settings, UK = dd/mm/yyyy and US = mm/dd/yyyy.
* If "end_date" is left blank, then "start_date" is used.
* If "properties" is left blank, then 0,1 is used which will display Date and Close.
* You can have a maximum of 249 properties.
* This information it being provided by LSEG.
* This function was first released in March 2020.
* You can use the FIELDVALUE function to return the value in a particular field from a linked data type.
* market identifier codes ink - support.microsoft.com/en-us/office/about-the-stocks-financial-data-sources-98a03e23-37f6-4776-beea-c5a6c8e787e6
* For the Microsoft documentation refer to support.microsoft.com

 A
1=STOCKHISTORY("MSFT", "06/09/2022", , , 0, 1) = 253.25
2=STOCKHISTORY("MSFT","06/09/2022",,,0) = {06/09/2022, $ 253.25}
3=STOCKHISTORY("XMIL:MSFT", "06/09/2022", , , 0, 1) = #VALUE!
4=STOCKHISTORY("EUR:USD", "01/07/2022", , 0, 0, 1) = 1.0428

1 - What is the closing price for MSFT on 6 September 2022.
2 - What is the closing price for MSFT on 6 September 2022 including both the Date and Close as properties.
3 - What is the closing price for MSFT on the Italian Exchange (Borsa Italiana).
4 - What was the exchange rate for EUR/USD on 1 July 2022.

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