Q: where do I get the MSN Money Stock Quotes addin for Excel XP

I cannot seem to find where to download the MSN Money Quotes add-in for Excel XP



I had the same problem.  It's just a matter of finding the right link.




You will often find the need to get the real-time stock quotes in excel for the purpose of analysis or tracking your portfolio. There are many ways you can get these quotes. In this article I will tell you about how you can make use of MSN MoneyCentral Stock Quotes Add-in for this purpose.

This article shows you the process in MS Office 2010.

The first step is to install the add-in. You can download the plugin from the following link:

MSN MoneyCentral Stock Quotes Add-in Download

If for some reason the link is broken, just send me an email, and I’ll send you the add-in file.

Once downloaded run the installer, and you are ready to go.

The add-in will appear as a separate toolbar, as shown below:

Click the “Insert Stock Quotes” button. A stock quotes window will open as shown below:

Enter the stock symbol, for which you want the quotes. In this case, we have selected only the last price. You can also get additional properties such as 52 Week High, 52 Week Low, etc.

Click OK and you will have the desired data in the selected cell.

Notice that the Add-in uses the custom function MSNStockQuote to fetch the data.

You can simply type a stock symbol cells A2, and get the price in cell B2. The results can be used anywhere in your model. If you want to track a bunch of stocks, simply repeat the formula in multiple cells.

Did this solve your problem?

Sorry this didn't help.

Question Info

Views: 11,242 Last updated: June 21, 2018 Applies to: