[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: Excel Portfolio Tracker



PureBytes Links

Trading Reference Links


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