In microsoft.public.uk.money, RichT wrote:
>In Money UK 2005, is there a setting to make portfolio show a simple
>gain/loss on a share or fund?
>
>It is a mystery for me how the "gain" figures are calculated. I have seen
>the options "Actual Cost basis", Average Cost basis (single category) and
>"Average Cost Basis (double category)" - but not sure what they mean. All I
>want to see is a simple gain/loss.
I think Gain would be [what you got from sales if any] + dividends
-[what you paid]. So a holding that you have sold out of could have
a gain or loss. It should be a good column.
What would be a simple gain/loss to you? I like the total return
(TR) columns. They are not simple, but they are meaningful.
I recommend that you configure to not use the "%Gain" column. There
are so many useful columns available in the Portfolio, and for me
"%Gain" is not one.
http://support.microsoft.com/kb/176334/en-us
seems to have a reasonable description, but the "basis" part can be
weird if there have been sales.
The main difference between % Gain and Total Return All (TR all)
appears to differ if sales have been made.
Both appear to take dividends into account. If showing sold
securities,
%gain can go negative ... buy at 100, sell at 1, big negative.
So total return ~? value/(spent-returned) ??
% gain ~? gain/ remainingBasis
test buy 100 at $10.00
Sell 99 at $10.10
%gain says 100% TR All says 1%
So, to reiterate, get rid of %gain and use the TR columns. With so
many useful columns, don't use the one dud.
Similar Threads
