Skip to main content
Skip to main content
Microsoft 365

Microsoft, Nasdaq, and Refinitiv empower everyday investors with real-time data and insights in Excel

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.

Animated screenshot of the Stocks Data Type in action in Excel.

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 (This link open in new tab) Excel for Office 365 today and this (This link open in new tab) template to help you track your investments.

Related posts

Image for: View live transcripts in Microsoft Teams meetings, track Excel changes, and increase hybrid work security—here’s what’s new to Microsoft 365

View live transcripts in Microsoft Teams meetings, track Excel changes, and increase hybrid work security—here’s what’s new to Microsoft 365

This month, we're announcing some top requested features like tracking changes in Excel and live transcriptions in Teams, as well as some soon-to-be-favorites like meeting recaps, turning Word documents in presentations, and more.

Image for: Family hanging out at home baking holiday cookies using Lenovo Ideapad Flex 3 to make holiday cards

New apps and features in Microsoft 365 for individuals and families this fall

Since we introduced Microsoft 365 to individuals and families earlier this year, we have continued to deliver new innovations across our apps and services to help you and your family save time and stay connected. See what’s new below. Locate your loved ones and build better driving habits with Microsoft Family Safety Stay connected even…

Image for: A man is using his Lenovo laptop like a tablet while sitting in a comfortable chair in a Modern office setting

Microsoft Productivity Score and personalized experiences—here’s what’s new to Microsoft 365 in October

As I reflect on an action-packed few weeks, I’m struck by how much work has evolved in these past months. And I know our customers feel it too. After quickly moving to remote and hybrid work models this spring, organizations are now seeking sustainable ways to help people collaborate, be productive, and prioritize their wellbeing…