If you’re like most people, you keep track of your stocks in a variety of different ways. Maybe you use a paper stock portfolio tracker, or an online stock tracker. Maybe you just remember the ticker symbols for the companies you own. Whatever system you use, it’s important to keep track of your stocks in Excel 2007. You can download a free trial of Excel 2007 at Microsoft’s website, and we’ll show you how to use it to keep track of your stocks. First, open Excel 2007 and create a new workbook. (If you don’t have Excel 2007 installed on your computer, click here to download a free trial.) In the new workbook, click on the Insert tab and select the Worksheet button. Then select the Range button and choose the A1:D10 range from your spreadsheet. (If your spreadsheet has multiple columns with data in them, choose the range that includes all of the columns that you want to include in your stock tracking.) Now we’ll show you how to add a column to your stock tracking spreadsheet that will hold information about each stock that is tracked. To do this, click on cell A1 and type =STOCK_Ticker into the cell. (You can also press Ctrl+Enter.) This will insert the ticker symbol for each company into cell A1. Now we’ll add another column to our stock tracking spreadsheet that will hold information about each day’s trading activity for each stock. To do this, click on cell B1 and type =DATE_TRADING into the cell. (You can also press Ctrl+Enter.) This will insert today’s date into cell B1. Next we’ll add another column to our stock tracking spreadsheet that will hold information about each day’s volume for each stock. To do this, click on cell C1 and type =VOLUME_TRADING into the ..
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.
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.
Now select where you would like the starting cell or you can also choose a new work sheet. Click OK.
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.
Is this a feature you’d actually use?
