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.

How to Do Live Stock Market Updates in Excel. The Microsoft Office store provides an Excel application that lists stock market updates. This free app inserts the data in a table on your worksheet.