# [MSN] Money Portfolio Gain Misculated

• ### 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 Monday, May 25, 2015 9:50 PM forgot image link
Monday, May 25, 2015 9:48 PM

• 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 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 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