end_date (optional): The latest date for which you want information.start_date: The earliest date for which you want information.This can be a ticker symbol or a Stocks data type. stock: The identifier for the financial instrument targeted.STOCKHISTORY(stock, start_date,, ,, ,, ) Let’s look at an overview of the function signature: We are thrilled to be able to bring this functionality into Excel. Getting the history of a financial instrument over time is crucial information you need. We know that this wasn’t enough to complete the goals you have for analyzing your portfolio in Excel. The Stocks data type began this journey by enabling refreshable quotes for stocks, bonds, funds, and currency pairs. We also added a way for the function to spill formats dynamically instead of stamping a format on a cell.Įasily pulling stock prices into Excel has been one of the most requested features on UserVoice. We have added many needed improvements to support service-side errors and data retrieval, including new errors like #BUSY! that show in Excel while data is being processed. STOCKHISTORY requires a Microsoft 365 Personal, Microsoft 365 Family, Microsoft 365 Business Standard, or Microsoft 365 Business Premium subscription.Įxcel is introducing a dynamically updating service-backed function that builds on the flexibility of dynamic arrays and fills a gap in the Stocks data type by providing access to historical data.

Think cell license price