SubscribeGet Stock Quotes in Excel
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.
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:
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 
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.
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
Trackbacks & Pingbacks
- Pingback by Stock-Quote » DE - Stock Quote (Antique john deere pedal tractor) for Deere Co on June 25, 2008 @ 12:56 am
- Pingback by Get stock quotes with one click in excel, and company profiles too - Learn Excel on June 27, 2008 @ 2:51 pm
- Pingback by Excel can be Exciting - 15 fun things you can do with your spreadsheet in less than 5 seconds « ZamaZ Cool Blog on November 25, 2008 @ 11:52 am
- Pingback by Microsoft Excel Training - Using Mouse - 5 Tricks | Learn Excel | Pointy Haired Dilbert - Chandoo.org on March 3, 2009 @ 12:27 am
Comments
RSS feed for comments on this post. TrackBack URI
Leave a comment
If you have a question, please ask in the forums
At Pointy Haired Dilbert, I have one goal, "to make you awesome in excel and charting". PHD is started in 2007 and today has 300+ articles and tutorials on using excel, making better charts. 
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
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
@Nicolas: Welcome. And thanks for asking your questions.
While macros are a good way to automate tasks like this, you may want to consider a web service call (as shown here: http://chandoo.org/wp/2009/02/05/twitter-from-excel/). You can use Yahoo Finance or Google Finance (google has rest api, so I guess it is even more easier). It is relatively easy to build your own function to extract the relevant stock quote data.
I have been getting several requests for this that one of these days I might just do it. Meanwhile, if you could build a macro that could call google finance or yahoo finance, let us all know, and you will get a free donut
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
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