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.