Portfolio Performance Report calcs w/ Transfer in/out

[michael]

Hi Mark,

We communicated briefly off the message board about the fact that an investment's transfers in and out affect the the gain/loss calculation on the Portfolio Performance Report. So if we transferred shares of a security with an existing gain from one portfolio to another, the position in the transfer out portfolio will have a related loss reported and the position in the transfer in source portfolio will have a corresponding gain. I copied your Portfolio Performance help screen below and highlighted item in red. It probably comes as no surprise to you that I'm clueless about programming. But I was wondering if you think there is any possibility of having the option to exclude the effects of transfers from this calculation in a future release?

Thanks again for all your help.
Michael


This report can be created by selecting the Reports / Portfolio Performance... command from within any window.



This report gives you an insight into how well your invested money performed. Customize which fields are displayed in this report using the Report Preferences - Portfolio Performance Dialog. The following columns can be displayed for this report type:



Beg Value
The market value of this line item at the start of the beginning report date. (i.e. This is the closing value on the date prior to the report's starting date.)

Cash Flow Style: Invested and Distrib.




Invested


Net out of pocket contributions made by the investor. The sum of all purchases minus all redemptions within the specified date range. (Does not include reinvested distributions.) Includes OOP cost of Transfer In transactions. Transfer Out transactions reduce this amount by the OOP cost transferred out.

Distrib.


Sum of all distributed (not reinvested) distributions during date range

Cash Flow Style: Contributions, Withdrawals, and With-Distrib. (more info)




Contributions


Out of pocket contributions (deposits) made by the investor from the starting, through the ending report date

Withdrawals


Out of pocket withdrawals made by the investor from the starting, through the ending report date

With-Distrib.


Sum of any withdrawn distributed distributions (cash distributions) during date range. Does not include retained or reinvested distributions.

End Value


The market value of this line item on the ending report date.

Gain


The value gained by this line item for the specified time period. Gain will be the same for both cash flow styles, and can be calculated with either formula:

(Gain = End Value + Distrib. - Invested - Beg Value)
or
(Gain = End Value + Withdrawals + With-Distrib. - Contributions - Beg Value)

%Gain


The percent gain for this line item for the specified date range.

%Gain-I


The percent gain on investment for this line item for the specified date range.

%Gain-V


The percent gain of value for this line item for the specified date range. If the beginning value is zero, this figure is not applicable and is reported as "N.A.".

Yield


The ROI yield for the specified date range.



This report shows cash flow in/out of the item being reported on. You can choose from 2 different styles of displaying cash flow in the Report Preferences - Portfolio Performance Dialog. For more details on cash flow, see External Cash Flow.
See Also

[Mark]

Hi Michael,

I do agree this would be a useful option or change. I can understand why you'd like to see the gain numbers using transfer market value instead of OOP. We'll look into this for a future version.