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.

Microsoft Excel can provide real-time stock data Your spreadsheet can provide up-to-the-minute info.

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.

Import data from Google Spreadsheets seamlessly into Excel. Choose from close to 100 key financials for stock analysis in real-time in Excel.

We're happy to report that Microsoft has now brought back real-time stock prices, but they are available only in Office 365, and the steps for creating such a link are different.

Microsoft isn't pulling the data out of thin air, of course. It has partnered with popular stocks and financial companies like the famed Nasdaq and Refinitiv to provide such data.

Over the course of the last few years, Microsoft started adding the concept of “data types” to Excel; that is, the ability to pull in geography and real-time stock data from the cloud, for ...