Re: Custom Report monthly returns

[ Q2 03 - Q4 05 Archive ] [ Current Message Board ] [ Archives ] [ Search ]

In Reply to: Re: Custom Report monthly returns posted by Steve Waller on April 09, 2003 at 08:45:50:

: : : I am trying to make a report that shows monthly percent returns. I am putting in beginning and ending portfolio value and have tried various gain choices but it doesn't seem to do the monthly gain or loss. Help please.

: : Hi Steve,

: : There are a few ways you can calculate %Gain. There is %Gain-I, %Gain-F, and
: : %Gain-C availabe in the custom report. In the Portfolio Performance report
: : there is also a %Gain-V. Each one is documented in the online help on the
: : equation being used. How would you like to calculate it? I can help you
: : find the appropriate one.

: : Thanks,
: : Mark
: : --
: : Mark Beiley
: :
: : Fund Manager, portfolio management software for Windows 95/98/ME/NT/00/XP
: :

: Mark, I just want to show percent returns for each month from 1/1/99 to 12/31/99. I am submitting the monthly performance numbers. I need the month to month % return to match the beginning and ending month to month values. I have tried all the % buttons in the custom menu and my settings must not be right. Some positives and the negatives show correctly but others don't. I assume it is due to internal starting values. Thanks

Hi Steve,

Are you looking for a simple %gain = (end - beg)/beg type of return number?
If so, this is %Gain-V, in the Portfolio Performance report. One thing
that can cause confusion, is that the beginning values are the values
at the close of the prior day, or the beginning of that day. For example,
the beginning value for a report starting on 1/1/03 is the same as the ending
value on 12/31/03.

Maybe it would be easier if you sent me one investment file, and give me
an example of what numbers you're trying to show? I can then try and give
more specific answers.

Thanks,
Mark
--
Mark Beiley

Fund Manager, portfolio management software for Windows 95/98/ME/NT/00/XP

Replies:

• Re: Custom Report monthly returns Steve Waller 08:25:00 04/10/03 (1)
  • Re: Custom Report monthly returns Mark 09:39:39 04/10/03 (0)