Download and Keep Track of Stocks in Excel 2007



Microsoft Excel is used by companies and individuals to keep track of and compute virtually anything that requires numbers. If you are computing financial symbols, did you know there's a way to have Excel automatically update those values online?

You can use smart tags in Excel to keep track of your stock quotes.  (Keep in mind you do need an Internet connection for this).  With this feature Excel will connect to MSN Money Central to download the information.

First we need to enable the smart cell feature by clicking the Office Button \ Excel Options \ Proofing \ AutoCorrect Options and click on the Smart Tags tab. Make sure and place a check next to Financial Symbol.  Click OK twice to get back to your worksheet.

1

Now that smart tags are enabled all we need to do is enter in our favorite stock symbol using all capital letters (in this instance I am using Microsoft).  Now hover the mouse over the lower left corner of the cell until the smart tag appears and click.  Select Insert refreshable stock price.

1

Now select where you would like the starting cell or you can also choose a new work sheet.  Click OK.

1 

Excel will go retrieve the information regarding the stock from MSN Money Central.  This will also include hyperlinks to additional information which will open in a separate browser.

1

Is this a feature you'd actually use?