Retrieving up to date stock market prices for Excel is a snap with the free Stock Connector add-in. Here's a walkthrough of how you get it and how it works.

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.