Accountant Forums


Reply
Thread Tools

Simple gain/loss in portfolio view?

 
 
RichT
Guest
Posts: n/a
Thanked:
 
      09-04-2009, 11:56 AM
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


 
Reply With Quote
 
 
 
 
Cal Learner
Guest
Posts: n/a
Thanked:
 
      09-04-2009, 01:39 PM
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.
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Quicken Portfolio - Import into M* Portfolio Analyzer - Problem BobLeavitt Quicken 0 08-06-2008 03:07 AM
website with SIMPLE portfolio charting? Robert UK Finance 0 05-10-2007 01:56 PM
Create or remove portfolio view item in Portfolio View Tony Quicken 3 03-09-2005 09:44 PM
Two simple SIMPLE-IRA questions gindie Tax 1 02-04-2004 03:16 AM
Can't sunchronize Money 2004 portfolio withMSN Money Portfolio Endo Microsoft Money 0 10-19-2003 08:48 PM


All times are GMT. The time now is 04:02 AM.
Posts in this forum do not constitute the advice of AccountantForums.com or its members. Financial advice should always be taken from qualified advisors before committing to a financial decision.