none
[MSN] Money Portfolio Gain Misculated RRS feed

  • Question

  • I have recently started to use MSN money as my portfolio manager, but I have noticed an issue where gain is being miscalculated. 

    I bought some shares in March, and they cost £1500 approx with an additional £12.50 commission.

    Luckily for me, they have now got a market value of £3,750 ish, but MSN Money My Watchlist is only taking the cost of the commission as the Cost Basis.

    I have taken a screenshot and shown the issue - am I going nuts?

    http://i.imgur.com/5LSZ1N9.png

    Thanks for any feedback.


    • Edited by johncarter9 Monday, May 25, 2015 9:50 PM forgot image link
    Monday, May 25, 2015 9:48 PM

Answers

  • Change your cost amounts to pence: price 8 pence, not 0.08, commission 1,250.

    The reported gain is against an apparent total cost of £15.11, not the actual cost of £1,511.

    • Marked as answer by johncarter9 Tuesday, May 26, 2015 8:22 AM
    Tuesday, May 26, 2015 7:09 AM

All replies

  • Your screen shot has some problems.  The arithmetic for the purchase appears correct.  18,734 shares @ 0.08/sh is worth 1498.72

    But the second shot makes no sense.  18,734 shares at 20.00/sh is worth 374,680.00, not 3746.80.  The latter value means the price per share had to be 0.20.

    Furthermore, 3746.80 - (1498.72+12.50) is 2235.58, not the 2122.58 you computed manually.

    The total gain reported of 3731.69 means that the cost basis was 15.11 which just happens to be exactly 1% of the actual cost.

    The day gain of 93 would be 600+% for a cost of 15 but only ~7% of the actual cost of 1511.

    I have no idea why so many values are off by a factor of 100.

    Tuesday, May 26, 2015 5:54 AM
  • Change your cost amounts to pence: price 8 pence, not 0.08, commission 1,250.

    The reported gain is against an apparent total cost of £15.11, not the actual cost of £1,511.

    • Marked as answer by johncarter9 Tuesday, May 26, 2015 8:22 AM
    Tuesday, May 26, 2015 7:09 AM
  • Apologies for the miscalculations, but thanks for spotting the issue. Really appreciate your help.
    Tuesday, May 26, 2015 8:26 AM
  • DominicP, thanks for giving me the answer to the problem.

    Guess is the problem when I deal with blue chip companies and AIM listed companies - look after the pennies and the pounds will look after themselves.

    Thanks to you both.

    Tuesday, May 26, 2015 8:28 AM