How to Get Stock Quotes in Excel – MoneyCentral Stock Quotes Add-in

Note: Most people have complained that MSN Add-in does not work anymore. I will suggest you to try another add-in which is a great replacement for the MSN Stock Quotes add-in. It comes at a small price but it is definitely value for money. Try the new Stock Quotes in Excel Add-in.
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.

UPDATE 1: If you are using Excel 2010 and are unable to get this plugin to work, then please try the instructions provided here.

UPDATE 2: For most people, the add-in has stopped working. Please check our discussion forum for discussion on alternative to MSN Stock Quotes Add-in.

Tags: , , ,

27 Responses to “How to Get Stock Quotes in Excel – MoneyCentral Stock Quotes Add-in”

  1. Dave March 5, 2011 at 12:10 pm #

    Thanks! Very Helpful!

  2. Norman Alterman August 25, 2011 at 4:53 pm #

    Will this update stock quotea in Excell 2007

    • admin August 27, 2011 at 6:58 am #

      Yes it does. I’ve successfully tried it :)

      • sergio October 20, 2011 at 11:40 am #

        HI
        I downoloaded and installed but as soon I try to put any stock symbol come up a scripterror message.
        Any ideas?
        Thanks

  3. Jonka January 23, 2012 at 12:01 pm #

    You can manually add stock quotes directly into the spreadsheet. The syntax looks like this (for the current price of MSFT):

    =MSNStockQuote.Functions.MSNStockQuote(“msft”,”Last Price”,”US”)

    • dave March 21, 2013 at 7:42 pm #

      Thanks Jonka, unfortunately that does not work with Office 2013/365. Any solution???

  4. sergio January 26, 2012 at 5:56 am #

    Thanks it works !

  5. WILLIAMBREAKEY April 13, 2012 at 7:50 am #

    I KEEP GETTING AN ERROR MESSAGE AS A PROBLLEM WITH ATTRIBUTES. I HAVE BEEN SUCESSFULLY WORKING WITH THE PROGRAM FOR YEARS.  ANY IDEAS

  6. Keppler May 1, 2012 at 2:34 pm #

    I gonna upgrade to Excel 2010 64-bit. Will this work with it? 

  7. Thomas Perry May 23, 2012 at 3:26 pm #

    Ok, first off, this is going to save me a lot of copy and paste from various financial webpages.  I LOVE IT!
    Couple things I wonder if they could be added.  The amount of the last dividend, the date of the last dividend.  While some dividends do not change month to month or quarter to quarter, there are some that change each time. 

    BUT I LOVE IT!

  8. Brad May 26, 2012 at 8:33 am #

    Could anyone tell me if these are real time or delayed?

    • Manish May 27, 2012 at 9:41 pm #

      These quotes are delayed by 15 minutes.

    • Manish February 16, 2013 at 4:17 am #

      The quotes are delayed by 15-20 minutes.

  9. Eric Burford August 11, 2012 at 11:08 am #

    thank you for posting this! works great

  10. tom August 30, 2012 at 10:18 pm #

    i just started to get a message that there is a problem with attributions . This program has worked for me the last 5 years. Any ideas as to what to do????
    Tom
    tom.heger@gmail.com

  11. kinshuk chandra September 17, 2012 at 1:22 pm #

    Please support for India – NSE and BSE , by the way very handy tool though I can’t use it as of now

  12. Hector Delgado November 1, 2012 at 7:32 am #

    ok

  13. Sumi February 2, 2013 at 1:42 pm #

    Hi there! I got the stocks. I also want to download “options” “currency rates” and
    “investor major indices”.

    you
    can go to “data”, click on connections and add in “currency rates” and
    “investor major indices” however it’s not prompting in the “add in” page
    and do not know how to add that. Or Options. Or anything else.

    Help please!

  14. Roger Q June 21, 2013 at 11:02 am #

    All of you that use this on a regular basis will already know that this quit working about 4 days ago.

    I emailed Manish to ask if he knew if MSN was going to fix the problem since I wasn’t able to find anything about it through the searching I did. From what he had heard, MSN was probably not working on the problem and we should look for another solution. I was afraid that might be the case. Microsoft dropped the ball on their MS Money program that forced me to go to Quicken and I wondered how long it would take them to drop the stock-quote functionality as well.

    I have already found a viable spreadsheet alternative with Google Docs and am presently building a spreadsheet with it that will duplicate what I had in MS Excel. I can share that here when I get it done. I should be able to do that soon.

    In the mean time, you guys may want to look at this link that gives really good info on the Google spreadsheet functionality:

    http://seekingalpha.com/article/568641-using-google-spreadsheet-as-your-watch-list

  15. Richard July 6, 2013 at 5:29 pm #

    I have been using the plugin below for quite some time. Works great for me. It use Yahoo API and integrate it seamlessly with Excel as exposed custom functions.

    http://www.technitya.com/content/stock-quotes-excel

  16. prem September 30, 2013 at 11:58 pm #

    Thank you very much.its working well

Leave a Reply