Automatically sync your watchlist across MSN Money on the web and your mobile apps for quick access to the stocks you care about. Finance simplified Know more about your money with the world’s best financial news and data. Please note that both this options work Excel 2003 and above. Download MSN Money and enjoy it on your iPhone, iPad and iPod touch. Just go wild 😀īonus 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. 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. The screen should look something like this:ĭont 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.
Then ALT+CLICK on that cell, this will open “Research task pane” on the right side of the screen. 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.įirst enter the stock code in a cell (this works for US stocks only), for eg.
0 kommentar(er)
