Microsoft has partnered with Nasdaq and Refinitiv to bring automatic pulling of stock info to Excel to enhance the experience of tracking stocks using from within Microsoft's spreadsheet editing application. The company brought Stocks as a Data Type in Excel last year for allowing users to keep up with information such as price, change, currency, among others.
The new partnership will bring real-time data tracking straight from the Nasdaq Stock Market along with the financial markets data from Refinitiv to help users of Excel to track their stocks and manage their portfolios much more easily. In addition to tracking stock prices, trading volume, and other financial information straight from within Excel, users will now also be able to keep up with bitcoin, bonds, foreign currencies, extended-hours pricing information, and various company data. Additionally, previous data will still be available to users such as mutual funds and stock indexes, including those from Nasdaq Composite, Dow Jones Industrial Average, the S&P 500, and various others.
“At Microsoft, our mission is to enable every person to achieve more,” said Rob Howard, Senior Director at Microsoft in a statement. “Pulling real-time and historical U.S. equity data from Nasdaq right into Excel helps users track personal investments better and make informed decisions faster.”
For those unfamiliar with how this all works, users can type in the name of a company they wish to track, and Excel will automatically recognize it and allow them to convert it into an entity that is linked to various information such as real-time price changes, last trade time, and 52-week highs and lows. Users can then use any of the available information in their own cells or directly in formulas, as well.
Microsoft is also working on various other additions coming down the road including updates that allow users to check historical data, as well as automatic price updating.
If you want, you can see for yourself how Excel can be used to keep track of your portfolio using a free template, visit here. Additionally, feel free to leave your comments below as to how you use excel to manage your expenses and budgets.