Microsoft has partnered with Nasdaq and Refinitiv to give financial investors real-time data and insights in Excel.
The announcement seems to take a cue from Microsoft Advertising in the way it
will provide real-time data through Excel, Bing, MSN and other Microsoft-owned platforms and services. The data will become available to the general public, including individual investors and
students, so they can leverage real-time U.S. stock equity market data from Nasdaq.
The idea is to use a variety of data, including data from Bing, to improve financial literacy. “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,” stated Rob Howard, senior director at Microsoft.
The Stocks Data Type turns Excel into a tool for tracking personal investments such as the latest stock prices, trading volume, and other financial information without leaving Excel to search outside sources.
The financial data includes bitcoin, bonds, international currencies, extended-hours pricing information and information about the company such as industry and company description, in addition to mutual funds and stock indexes, such as the Nasdaq Composite, Dow Jones Industrial Average, and S&P 500.
Here’s how it works: Open Stocks in Excel and type in MSFT and click Stocks, and Excel recognizes it as a stock and returns an option to convert it into a link with properties of related information and real-time attributes such as Price, Change, Last trade time, 52-week high/low, and other pricing information.
Users can choose whether to capture these attributes in different cells or use them directly in formulas and add a list of ticker symbols from a stock portfolio in one column. Excel can provide the price for daily gains or losses, refreshed with the click of a button.