Financial investments are among the more important things we need to track in everyday life, and millions of people choose Excel to manage their budgets and track their assets. To help make this seamless, last year we introduced Stocks, a Data Type in Excel powered by artificial intelligence (AI), which turns a stock ticker into an interactive entity with layers of rich information like price, change, currency, and much more.
Today, we’re excited to announce we’re working with Nasdaq and Refinitiv to pull current financial information for the full range of U.S. exchange-listed equities, including stocks on the Nasdaq Stock Market, the world’s largest exchange company, and from Refinitiv, one of the world’s largest providers of financial markets data and infrastructure, right into the Excel Stocks Data Type.
The Stocks Data Type turns Excel into a more robust tool for tracking personal investments, enabling you to track the latest stock prices, trading volume, and other financial information without leaving Excel to search outside sources. Now with trusted, real-time data from Nasdaq and Refinitiv, this becomes even better. Stocks in Excel now expands financial data to include bitcoin, bonds, international currencies, extended-hours pricing information and information about the company, like industry and company description, in addition to other previously available data like mutual funds and stock indexes, such as the Nasdaq Composite, Dow Jones Industrial Average, the S&P 500, and more.
“Expanding the reach of real-time market data is essential to making markets more accessible,” said Oliver Albers, Senior Vice President and Head of Strategic Partnerships for Nasdaq’s Global Information Services. “Our collaboration with Microsoft is a significant step towards bringing important market information to individual investors. Microsoft’s focus on empowering individuals aligns perfectly with our mission to make financial markets more inclusive.”
“Anyone with an interest in financial information needs quick, reliable data to navigate today’s complex and fast-moving global markets,” said Brennan Carley, Global Head of Enterprise at Refinitiv. “Refinitiv has many years’ experience in delivering data to financial professionals within Microsoft Excel and we are now delighted to give everyday investors access to these capabilities via our partnership with Microsoft.”
To understand more deeply how Stocks in Excel works, let’s look at the Microsoft stock. When you type in MSFT and click Stocks, Excel recognizes it as a stock and gives you an option to convert it into a rich entity linked with many properties of related information, including real-time attributes such as Price, Change, Last trade time, 52-week high/low, and other pricing information. You can choose to capture these attributes in different cells or use them directly in formulas. Recently updated data cards provide a better experience for Excel users working with such information allowing a quick preview of available categories. Imagine adding a list of ticker symbols from your stock portfolio in one column and having Excel provide the price and your daily gains or losses, refreshed with the click of a button.
By bringing together the power of Microsoft-backed data services with highly trusted sources of market information like Nasdaq and Refinitiv, we’re helping everyday investors like you access the same data as the market sees, enabling better financial literacy. And this is just the beginning: soon, you’ll be able to see historical data and automatically update the prices every few minutes.
We’re excited to continue our journey to continually improve Excel to help you get the most out of your data. Start tracking your personal investments using Excel for Office 365 today and this template to help you track your investments.
Source: Office Blog