Click the Store button and navigate to the Stock Connector page. You can also reach the Office Store through the Insert tab in Excel. If you reach the Office Store through a web browser, before you click the Add button, you should probably sign in to your Office 365 account if you have one–it’s just easier that way. The first step is to download Stock Connector from the Microsoft Office App Store. How to insert absolute and relative hyperlinks in a Microsoft Word document How to return first and last times from timestamps in Microsoft Excel Master Microsoft Office with this accredited training Installing and using this free add-in can be accomplished with a few clicks. You can also use Stock Connector to follow market indexes like the S&P 500 (SPX). Stock Connector provides free access to the current stock price of any security trading on any exchange tracked by Yahoo Finance. Among my favorite outside data sources is an add-in called Stock Connector. The list of available sources ranges from other Excel worksheets to other Office documents to databases–and just about everything in between. One of the most powerful and most useful features in Microsoft Excel is its innate ability to bring in data from outside sources. For more info, visit our Terms of Use page. This may influence how and where their products appear on our site, but vendors cannot pay to influence the content of our reviews. We may be compensated by vendors who appear on this page through methods such as affiliate links or sponsored partnerships. Here's a walkthrough of how you get it and how it works. Retrieving up to date stock market prices for Excel is a snap with the free Stock Connector add-in. Track stocks like a pro with a free Excel add-in

Download stock quotes into excel