Get Stock Quotes in Excel

Posted on June 24th, 2008 in america , hacks , Learn Excel , technology - 33 comments

While trying to spell check one my sheets I have learned this cool trick to fetch real time stock quotes without any webqueries or vba or anything.

one-click-stock-quotes-in-excel

First enter the stock code in a cell (this works for US stocks only), for eg. AAPL for Apple, MSFT for Microsoft etc. Then ALT+CLICK on that cell, this will open “Research task pane” on the right side of the screen. The screen should look something like this:

research-stock-quotes-company-profiles-in-excel

Dont worry if you dont see the stock quote, that could be because your research type is set to either “all research books” or “thesaurus”, just click the drop-down and select “MSN Money Stock Quotes” – 2nd option from last (Excel remembers your selection, so next time you alt+click on a company code it automatically shows the stock quote) Once the quote is displayed in the research task pane, just click the “insert price” button to get the quote inserted in to your worksheet. Simple eh?

Now, if you want to track a bunch of company quotes, just create a simple macro to do the alt+click on each of the company code cells and you have a real time quote tracking terminal built into your excel sheet. Just go wild :D

Bonus tip: If you want a company profile data for a particular stock (like company address, phone number, exchange codes, last year revenue) select the “Thomas Gale company profiles” instead.

get-company-profiles-in-excel-one-click

Please note that both this options work Excel 2003 and above.

Also read: Create stock / mutual fund portfolio tracker in excel using web lookup queries

Your email address is safe with us. Our policies

Written by Chandoo
Tags: , , , , , , , , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

33 Responses to “Get Stock Quotes in Excel”

  1. [...] Get stock quotes with one click in excel, and company profiles tooDont worry if you dont see the stock quote, that could be because your research type is set to either “all research books” or “thesaurus”, just click the drop-down and select “MSN Money Stock Quotes” – 2nd option from last (Excel … [...]

  2. Hi,

    Your blog is nice and informative. We would like to share few information’s with users. Indian stock market is not a place for speculators anymore. As it has become too volatile. Still day traders are requested to trade with strict discipline and a small suggestion for Long term players is don’t take any long term delivery position as Nifty and Sensex are still in bearish zone. Just wait for right time and opportunity before taking long position.

    For any doubt please feel free to ask us.

    Thanks

    Regards

    SHARETIPSINFO TEAM

    • raj says:

      Hi, Just like MSN stock quote addin, do msn addin quotes available for Indian stocks? I want it badly. Could some one help me pls?

  3. alt codes says:

    [...] company / stock code eg. YHOO and alt+click on the cell – you have the stock quotes now… learn howhttp://chandoo.org/wp/2008/06/24/get-stock-quotes-in-excel/Read “?? Oh, I love using the alt codes ??????????? ? ?? ?? ?? Finally I learned it here [...]

  4. [...] Just enter the stock symbol (MSFT, GOOG, AAPL etc.) in a cell, alt+click on the cell to launch “research pane”, select stock quotes to see MSN Money quotes for the selected symbol. You can fetch company profiles in the same way. Learn more. [...]

  5. Nicolas says:

    Hi, i really like your excel idea. I am trying to create a macro to automatically update all the stocks but i have been unsuccessful. Can you help me out please?
    Thank you

  6. [...] To get stock quotes in excel, enter a company stock symbol in the cell, alt+click on it to launch research pane. (works excel 2003 and above). Find out more. [...]

  7. [...] Just enter the stock symbol (MSFT, GOOG, AAPL etc.) in a cell, alt+click on the cell to launch “research pane”, select stock quotes to see MSN Money quotes for the selected symbol. You can fetch company profiles in the same way. Learn more. [...]

  8. RandirRandwa says:

    Nice informative article. I learned something new today. Thanks.

    Of late, I have been using a few scripts for my appetite for stock market information. I posted an article at http://www.boards.ie/vbulletin/showthread.php?threadid=2055574076 for retrieving stock quotes off internet. Do take a look. Feel free to use it if you find it useful. The script is written in biterscripting language. (As far biterscripting, it is free to download at http://www.biterscripting.com.)

    Randir

  9. Antonio says:

    Great info! It has been a giant help at work. I found a use right off.
    BUT…I am unable to write a macro to run that automatically. My Excel version (I suppose) also does not allow the refresh flag. (Excel 2003 Prof Edition).

    Is there a way of getting round it??

    cheers

  10. Manoj S Negi says:

    great trick….dear…thank you so much for this.

  11. Rahul says:

    Hi Chandoo,

    I am using Excel 2010. It doesn’t show me “MSN Money … ” in options.

  12. Please provide an alternative to get stock quotes in excel as there is no option for MSN Money Stock Quotes in Office 2010.

  13. Richard Rost says:

    Apparently Microsoft removed the “MSN Money Stock Quotes” option from Excel 2010. You can do something similar now using the “Get External Data” feature on the Data tab, but it’s not as elegant. I’m currently recording a tutorial in how to do this for my Excel Beginner Level 5 tutorial and I was ASTONISHED to see that they had removed it.

  14. Booth says:

    I cant find “MSN Money Stock Quotes” on the “Thomas Gale company profiles” is on there but not “MSN Money Stock Quotes” any ideas?

  15. [...] How to Get or to obtain Stock or Inventory Quotes or Estimates in or within Excel or Stand out &#821… Here is a or This is a very simple or quite simple trick or technique you can use to or will get or obtain latest or newest stock or inventory quotes or estimates from a or from the given or provided company or organization symbol or image (like or such as YHOO or or or even AAPL). Just or Simply enter the or go into the code or signal in a or inside a cell or cellular and or as well as ALT+CLICK on or upon that or which cell or cellular to launch or to produce research or study pane or lite . From here or Came from here insert or place the latest or the most recent stock or inventory quote or quotation directly or straight in to or directly into your or your own excel or stand out sheet or linen . Learn more or Find out more … [...]

  16. Sim Con says:

    There’s a spreadsheet at http://investexcel.net/218/importing-historical-stock-prices-from-yahoo-into-excel/ which helps you import stock quotes from Yahoo into Excel.

    The spreadsheet at http://investexcel.net/222/automatically-download-historical-forex-data-into-excel/ helps you import historical Forex data straight into Excel. You don’t need to mess around with CSV files – just provide two currency symbols, a couple of dates, and then Excel import the daily forex bid rates

  17. tips.biz says:

    Hi,

    Your post is different,unique and correlate with the topic.Definitely i will use it and share views here. We use excel sheet in our work to differentiate commodity tips investors and stock investors.

    Keep it up.

    Regards,

  18. [...] Just enter the stock symbol (MSFT, GOOG, AAPL etc.) in a cell, alt+click on the cell to launch “research pane”, select stock quotes to see MSN Money quotes for the selected symbol. You can fetch company profiles in the same way. Learn more. [...]

    • Barry says:

      Sorry but this doesn’t work. It brings up a research pane, but all there are is weblinks to investment news pages and no way to get a stock quote into the spreadsheet. A pretty useless feature actually.

  19. George Fisher says:

    For an Excel VBA function that returns any parameter provided in the Google Finance XML stream try

    http://www.philadelphia-reflections.com/blog/2385.htm 

  20. Jiri says:

    You may try Spearian for Excel for obtaining more data from more sources with greater comfort
     
    http://spearian.com/products/spearian-for-ms-excel

  21. Hiya! I just wish to give a huge thumbs up for the
    great info you’ve gotten right here on this post.
    I will be coming back to your weblog for more soon.

  22. Richard says:

    Try this. All function based. Provides good flexibility.

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

  23. Frederic says:

    You can also do it for free with no VBA, no code at all, by using the free Excel Add in Power Query:
    http://office.microsoft.com/en-us/excel/download-microsoft-power-query-for-excel-FX104018616.aspx

    in combination with Finviz for instance and this type of URL:
    http://finviz.com/screener.ashx?v=111&t=MSFT,AAPL

    Refreshable, elegant, easy…

  24. richard says:

    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

  25. Glenn says:

    I have been using your spreadsheet and find it excellent. I have however been finding questionable data appearing for the Ex-Dividend Date. As an example for CCJ (Cameco Corp) it shows the Ex-Dividend Date as 27Dec14 whereas if I look at http://finance.yahoo.com/q/ks?s=CCJ it shows it is 27Mar14. Where are you your data from and how do I correct it in my spreadsheet?

Leave a Reply