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
|