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

Re: Excel Portfolio Tracker



PureBytes Links

Trading Reference Links

Thanks for the help.
Norm Wiss
cutup2@xxxxxxxx
----- Original Message -----
From: "Tim Lumley" <tlmly@xxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: Monday, June 04, 2001 10:28 PM
Subject: RE: Excel Portfolio Tracker


> Norman,
>
> Try this:  Cell A61 is a formula "sum(A1:A60)".  If you put your
cursor on
> cell A61 and insert a row, the formula will move to cell A62 and
> automatically change to "sum(A1:A61)".  When you put the new value
in the
> new row (cell A61), the sum of the column will still be correct with
the new
> entry.  There is an icon that can be added to the toolbar -- see
> View|Toolbars|Customize -- that will automatically insert the row if
you are
> interested.
>
> TGL
>
> -----Original Message-----
> From: owner-metastock@xxxxxxxxxxxxx
> [mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of Norman
> Sent: Monday, June 04, 2001 4:50 PM
> To: metastock@xxxxxxxxxxxxx
> Subject: Re: Excel Portfolio Tracker
>
>
> 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
>
>
>