STOCKHISTORY Function in Excel
The new STOCKHISTORY function in Excel can fetch you the Price History of a particular Stock for the time period specified inside the function. This will help the user to Analyze as well as Visualize the historical prices of stocks.
Syntax
Following is the syntax of STOCKHISTORY function (which is supposed to change before the official release)
=STOCKHISTORY(stock, start_date, [end_date],[interval],[headers], [property0], [property1] [property2], [property3], [property4], [property5])
Parameters
stock: The identifier for the financial instrument targeted. This can be a ticker symbol or a Stocks data type.
start_date: The earliest date for which you want information.
end_date (optional): The latest date for which you want information.
interval (optional): Daily (0), Weekly (1), or Monthly (2) interval options for data
headers (optional): Specifies if additional header rows are returned with the array.
property0 - property5 (optional): Specifies which information should be included in the result, Date (0), Close (1), Open (2), High (3), Low (4), Volume (5).
Example
The following formula will return the Stock Price History of Microsoft Corporation (MSFT) for a period 5 days from 01/06/2020 to 05/06/2020
=STOCKHISTORY("MSFT", "6/1/2020", "6/5/2020")#BUSY
With the STOCKHISTORY function Excel has introduced a new error called #BUSY. The function will return a #BUSY Error while data is being processed.
Data Provider
The data returned by STOCKHISTORY function is provided by one of the largest financial market data provider called Refinitiv.
Not Available to all Excel Users
As of today (13/06/2020), STOCKHISTORY function is available only to 50% of Microsoft 365 Subscribers in the Beta level of the Office Insider Program. STOCKHISTORY function is expected to take a few months before the official release to all Office 365 subscribers.
Originally published at XL n CAD