RE: Excel Portfolio Tracker

["neo" <neo1@xxxxxxxxx>]

Thanks 
Tim
<FONT face=Arial color=#008080 
size=4> 
This 
would give me the total summary. Is there also a way that Excel will 
automatically give me the # of rows that have data so that I can calculate the 
weekly and annualized returns?
 
<FONT face=Arial color=#008080 
size=4>neo
 

  <FONT face=Tahoma 
  size=2>-----Original Message-----From: 
  owner-metastock@xxxxxxxxxxxxx [mailto:owner-metastock@xxxxxxxxxxxxx]On 
  Behalf Of Tim LumleySent: Monday, June 04, 2001 8:37 
  AMTo: metastock@xxxxxxxxxxxxxSubject: RE: Excel 
  Portfolio Tracker
  The 
  easiest way would be to create your summation range (your formula that adds 
  the values) to include a lot of blank rows.  If there is no value in 
  them, they will not add to the running summary.  As you enter new values 
  from your trades that are within the range, they will add to the tally.  
  When you fill up the initial range, be sure to expand it with more blank rows 
  to keep your running total cell calculating properly.
  <FONT face=Arial color=#0000ff 
  size=2> 
  <FONT face=Arial color=#0000ff 
  size=2>TGL
  
    <FONT face=Tahoma 
    size=2>-----Original Message-----From: 
    owner-metastock@xxxxxxxxxxxxx [mailto:owner-metastock@xxxxxxxxxxxxx]On 
    Behalf Of neoSent: Monday, June 04, 2001 7:10 
    AMTo: metastock@xxxxxxxxxxxxxSubject: Excel Portfolio 
    Tracker
    I 
    would like to set up a spreadsheet to track all of my trades after they are 
    closed with a running summary. Is there a way with Excel to add all of the 
    values in a column without specifying the end of the 
    column?
    <SPAN 
    class=490020512-04062001> 
    <SPAN 
    class=490020512-04062001>thanks, 
neo