Re: Excel Portfolio Tracker

["Norman" <cutup2@xxxxxxxx>]

AWong    I have only cost data in Column A (A1:A60). The sum of the
column is at A61. Is there a formula or set-up that would give me a
running total of Col A just below the latest entry as each entry is
made? There was a procedure in Lotus 1-2-3 to do this.
Norm Wiss
cutup2@xxxxxxxx
----- Original Message -----
From: "AWong" <toawong@xxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: Wednesday, July 04, 2001 3:48 PM
Subject: Re: Excel Portfolio Tracker


Building on Tim's suggestion, if the subtotal and counts were to be in
a different column than the data then please try this:

1.  Assume column A contains the data.  It can be a mix of text and
value cells.
2.  If cell B1 were to contain the sum of all numeric values in col A,
then B1's formula  would be SUM(A:A).
3.  If cell B2 were to contain the count of all numeric values in col
A, then B2's formula would be COUNT(A:A)

Please note that using this method col A cannot contain more than one
set of data eg only Close or Open but not both.

Regards,

Augie
  ----- Original Message -----
  From: neo
  To: metastock@xxxxxxxxxxxxx
  Sent: Monday, June 04, 2001 12:10 PM
  Subject: RE: Excel Portfolio Tracker


  Thanks Tim

  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?

  neo

    -----Original Message-----
    From: owner-metastock@xxxxxxxxxxxxx
[mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of Tim Lumley
    Sent: Monday, June 04, 2001 8:37 AM
    To: metastock@xxxxxxxxxxxxx
    Subject: 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.

    TGL
      -----Original Message-----
      From: owner-metastock@xxxxxxxxxxxxx
[mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of neo
      Sent: Monday, June 04, 2001 7:10 AM
      To: metastock@xxxxxxxxxxxxx
      Subject: 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?

      thanks, neo