Re: 8.6 -- %gain calc

[ Message Board ] [ Archives ] [ Search ]

Posted by Mark on July 24, 2007 at 12:11:39:

In Reply to: 8.6 -- %gain calc posted by Louis Goluboff on July 24, 2007 at 11:54:15:

: Hi Mark,
: I just downloaded the 8.6 and in my custom reports I am not getting accurate %Gain(btw) calculations and in the totals line it is showing N.A.?

: Thanks,
: Lou

Hi Lou,

How are you determining the %Gain(btw) is not accurate? If you add Gain(btw) and OOP Basis(btw) to your report, and then check that:

%Gain(btw) = Gain(btw) / |OOP Basis(btw)|

that should help. Note that in 8.6 the absolute value of OOP Basis(btw) is now used in the denominator, which handles reporting on short positions.

If an investment is both long and short within the time period you're reporting on, then the %Gain will be reported as "N/A".

Thanks,
Mark
--
Fund Manager - Portfolio Management Software

Replies:

• Re: 8.6 -- %gain calc Louis 12:15:03 07/25/07 (5)
  • Re: 8.6 -- %gain calc Mark 12:30:51 07/25/07 (4)
    • Re: 8.6 -- %gain calc Louis 12:51:03 07/25/07 (3)
      • Re: 8.6 -- %gain calc Mark 13:04:28 07/25/07 (2)
        • Re: 8.6 -- %gain calc Louis 14:02:43 08/13/07 (1)
          • Re: 8.6 -- %gain calc Mark 16:24:58 08/13/07 (0)