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. Finance Train’s users now get a 25% exclusive discount on the purchase the stock quotes in excel add-in. 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 post on alternative to MSN Stock Quotes Add-in.

UPDATE 3: Finance Train’s users now get a 25% exclusive discount on the purchase the stock quotes in excel add-in. Try the new Stock Quotes in Excel Add-in.

  • Dave

    Thanks! Very Helpful!

  • http://steellogic.com Norman Alterman

    Will this update stock quotea in Excell 2007

    • http://financetrain.com/members/admin/ admin

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

      • sergio

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

  • Jonka

    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

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

      • Jonka

        This variant worked for a while (USD instead of US)
        =MSNStockQuote.Functions.MSNStockQuote(“msft”,”Last Price”,”USD”)

  • sergio

    Thanks it works !

  • WILLIAMBREAKEY

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

  • Keppler

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

    • http://www.facebook.com/johnericrichards John Richards

      Was there ever an answer on this — I just upgraded to Excel 2010 64-bit and it doesn’t work!

  • http://www.facebook.com/people/Thomas-Perry/1090847422 Thomas Perry

    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!

  • Brad

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

    • http://financetrain.com/members/admin/ Manish

      These quotes are delayed by 15 minutes.

    • http://financetrain.com/ Manish

      The quotes are delayed by 15-20 minutes.

  • http://www.facebook.com/eburford1972 Eric Burford

    thank you for posting this! works great

  • tom

    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

  • kinshuk chandra

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

    • http://financetrain.com/members/admin/ Manish

      Hi Kinshuk,

      We are building stuff for India. Please check http://stockbol.com

  • http://www.facebook.com/hector.delgado.3344 Hector Delgado

    ok

  • http://profile.yahoo.com/3RHZWMXUM5MBQBREGWJSDQG7ZI Sumi

    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!

  • Roger Q

    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

  • Richard

    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

  • http://nil prem

    Thank you very much.its working well

  • Michael

    I actually just released a free app for Excel that pulls in stock quotes. But unlike other solutions (VBA/Add-ins), this one works in Excel Web App (Excel Online) too:

    https://store.office.com/stock-connector-WA104379220.aspx?assetid=WA104379220