You can use Stock Quote in Excel to get the real-time prices of stocks. The Stocks data type is connected to an online source that contains more info.

If Stock Data Types is not showing or missing in Excel, repairing Microsoft 365, or updating or reinstalling Office. Learn more.

When this field is used by itself, Analyze Data returns a unique count. Excel’s Analyze Data returns a lot of great information considering how easy it is to implement and use.

Microsoft has teamed up with Nasdaq and Refinitiv, to bring real-time financial data to Excel spreadsheets. Users have access to the latest stock and bond prices, plus other relevant information.