Simple gain/loss in portfolio view?


R

RichT

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.

Richard
 
Ad

Advertisements

C

Cal Learner

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How is "gain" calculated in Portfolio view? 8
Portfolio View 2
Portfolio view 0
"TR all" vs. "% gain" in portfolio view? 8
Portfolio view 2
Portfolio Views 2
Portfolio View 0
portfolio views 1

Top