EXCEL - New STOCKHISTORY Function available to all Office 365 subscribers
DOWNLOAD the file: https://tinyurl.com/Excelstockhistory
Subscribe to the channel / scuolatech
Leave a comment for any feedback you might need!
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.
Syntax
=STOCKHISTORY(stock, start_date, [end_date], [interval], [headers], [property0], [property1], [property2], [property3], [property4], [property5])