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
39 Responses
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, Just like MSN stock quote addin, do msn addin quotes available for Indian stocks? I want it badly. Could some one help me pls?
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 🙂
Hi,
have you done any work on fetching intraday stock data from google, link http://www.google.com/finance/getprices?q=BANKBARODA&x=NSE&i=60&p=1d&f=d,c,o,h,l&df=cpct&auto=1&ts=1266701290218,
please let me know.
Thanks & Regards
Manish
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
great trick….dear…thank you so much for this.
Hi Chandoo,
I am using Excel 2010. It doesn’t show me “MSN Money … ” in options.
Please provide an alternative to get stock quotes in excel as there is no option for MSN Money Stock Quotes in Office 2010.
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.
I cant find “MSN Money Stock Quotes” on the “Thomas Gale company profiles” is on there but not “MSN Money Stock Quotes” any ideas?
Google leads to the following and it works!
http://financetrain.com/how-to-get-stock-quotes-in-excel-moneycentral-stock-quotes-add-in/
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
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,
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.
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
http://www.philadelphia-reflections.com/blog/2385.htm
You may try Spearian for Excel for obtaining more data from more sources with greater comfort
http://spearian.com/products/spearian-for-ms-excel
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.
Try this. All function based. Provides good flexibility.
http://technitya.com/content/stock-quotes-excel
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…
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
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?
This feature is in what version of Excel????
nice good for every one !
Thanks for this article. You can also get real time access to financial data in excel from IXBRANALYST to any of your device
Thanks for this article. I tried using https://findynamics.com/ixbrlanalyst as suggested by Babashola Joshua, and it’s really good. I got my financial data directly into my excel using microsoft 365, with their free trial. though it worked on any devices.Thanks for this article again it’s really helpful. Keep up the good work
.I am unable to write a macro to run that automatically. My Excel version (I suppose) also does not allow the refresh flag.