Re: % Gain-I

[ Message Board ] [ Archives ] [ Search ]

Posted by Mark on January 04, 2007 at 10:08:51:

In Reply to: Re: % Gain-I posted by Robert A on January 04, 2007 at 01:00:49:

: Mark,
: The report you suggest gives me the % gain on the currently held shares, in this case 13.13%. But all the transactions for this one stock during the specified time frame have resulted in a 17.6% gain. I find it frustrating that FM can combine all the transactions and accurately compute the OOP (+20,328), and the gain (+3576), but cannot put the two together to get 17.6%. Is there a way I can write my own formula for a report, in this case gain divided by OOP?

: Robert

Hi Robert,

There are multiple versions of the OOP fields, one for currently held shares, one for between a date range, and one from inception. I gave you the case for the currently held shares. You can use the "between" version to get what you're looking for. Please create a custom report with these fields:

Out of pocket basis (between)
Value (ending)
Gain (between)
%Gain (between)

The last field is the gain divided by the OOP for the report date range.

Thanks,
Mark
--
Fund Manager - Portfolio Management Software

Replies:

• Re: % Gain-I Robert A 12:31:56 01/04/07 (1)
  • Re: % Gain-I Mark 12:51:41 01/04/07 (0)