When you purchase through links on our site, we may earn an affiliate commission. Here’s how it works.

Microsoft announces new Excel function that lets you visualize stock history

Microsoft has announced a new function for Excel, which is designed to help users visualize the historical data data for a company over time. Called STOCKHISTORY, the new function leverages the Stocks data type, and the dynamic arrays feature that was added recently to grab stock values for different dates and list them all.

For those unfamiliar, dynamic arrays made it possible for a function to be introduced in a single cell but spill out data in multiple cells. This capability launched with functions such as SORT, FILTER, and more, but now STOCKHISTORY is also making use of it to display historical stock data.

The function can be used with a multitude of arguments that let you set what data you want to see. The stock argument defines which company or financial instrument you want the data on, and it can also be used to define which exchange to get the data from; start_date defines the first point in time when data should be collected; end_date defines the last point you want data on, but it's optional; interval defines whether you want daily, weekly, or monthly data, and it's also optional, setting to daily by default; and headings lets users create additional header rows are needed for the results returned by the function. There are also five properties that can be added to select which information to be includes, such as the date, the opening or closing value, high, low, and volume.

The new STOCKHISTORY function is currently available to Microsoft 365 users in the Beta channel, which used to be known as the Office Insider Fast ring on Windows devices prior to a name change announced yesterday. It should make its way to everyone over time.

Report a problem with article
Reddit logo in black background
Next Article

Reddit appoints Michael Seibel to fill in Alexis Ohanian's seat at the board

Microsoft Edge Dev written next to an Edge Dev logo and three vertically slanted green lines
Previous Article

Edge Dev build 85.0.538.0 is out with minor improvements

Join the conversation!

Login or Sign Up to read and post a comment.

9 Comments - Add comment