Please note that both this options work Excel 2003 and above. 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. 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.
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. Download MSN Money and enjoy it on your iPhone, iPad and iPod touch. 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)
