Simple gain/loss in portfolio view?

Discussion in 'Microsoft Money UK' started by RichT, Sep 4, 2009.

  1. RichT

    RichT Guest

    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
     
    RichT, Sep 4, 2009
    #1
    1. Advertisements

  2. RichT

    Cal Learner Guest

    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.
     
    Cal Learner, Sep 4, 2009
    #2
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. ~^ beancounter ~^

    gain / loss on sale of assets vs. capital gain ??

    ~^ beancounter ~^, Jan 27, 2006, in forum: Accounting
    Replies:
    0
    Views:
    585
    ~^ beancounter ~^
    Jan 27, 2006
  2. Replies:
    1
    Views:
    1,139
    James Lewis
    Jan 29, 2006
  3. Tony
    Replies:
    3
    Views:
    728
    John McConkey
    Mar 9, 2005
  4. brett

    "TR all" vs. "% gain" in portfolio view?

    brett, Sep 24, 2008, in forum: Microsoft Money
    Replies:
    8
    Views:
    344
    Cal Learner-- MVP
    Sep 25, 2008
  5. Frustrated Money User

    cap gain report and portfolio view error for foreign currency inve

    Frustrated Money User, Feb 21, 2005, in forum: Microsoft Money UK
    Replies:
    0
    Views:
    223
    Frustrated Money User
    Feb 21, 2005
Loading...

Share This Page