How is the investment gain/loss computed?

I purchased 2 Amazon shares 1 each at different times
1 share - May 2019 at Ā£1500
1 share - Apr 2020 at Ā£1940

Today the share was trading at Ā£1900 and my investment gain/loss in +6% which is correct.
I would imagine that when I sell one share of Amazon at Ā£1900 my investment gain should still read as +6% ? But what I see is around -2% which is computed based on the share I purchased on Apr 2020 and not based on the average purchase price.

So I would like to understand if that is the intended calculation?

2 Likes

Normally the profit is calculated based on the average of those two purchases, which should be Ā£1720.

It may or may not explain the difference; but did you look at the GBP/USD exchange rate difference? It could have played a part, plus 0.45% FX fee in both transactions

I canā€™t find the other thread about the P&L calculation but ultimately itā€™s a first in first out calculation rather than a cost average one which would remain constant when you sell.

2 Likes

As you said, exchange rate and the FX rate doesnā€™t account for the 8% difference here, so i guess thats not the case here.

A cost average is the only way your purchase price should be calculated. Not including the price of the oldest shares when you sell, just doesnā€™t make sense.
FT should change this

5 Likes

Adding to this so I donā€™t start another topicā€¦

I bought Ā£100 of Tesla at $799.67 and at 16:10 today Tesla is at $811.11

That is a 1.43% rise, but Iā€™m down -0.15%ā€¦

What am I missing in my calculation? Even with the .45p fx fee, I should be at about +1.3%

Im sure itā€™s something simpleā€¦

Youā€™ll have the bid / offer spread at least as a difference too. Not sure what the spread is on tesla but itā€™s not unreasonable to see it around 0.3%

Just looked on HL. At the moment it looks like this.

Maybe more price movement at the time?

I get the bid offer spread means Iā€™m not guaranteed the price at point of sale but somewhere in between. But I actually got the share at $799 a few days agoā€¦ very odd and canā€™t quite figure it out.

Donā€™t forget about FX. GBP:USD in this case. Could be that FT is calculating your Ā£ then vs Ā£ now (rather than in $ terms). Iā€™m not sure about this but it could explain it.

Can anyone offer some guidance on how the FreeTrade investment gain/loss is calculated against a investment for one company? For example, I have invested in BP on the following dates, with two sells on the 18th May and with speculative sell using todayā€™s price of Ā£3.16 if I were to sell my entire holding.

ff73ee61bb0ac831c49065f0e7092845

Here is the FreeTrade snapshot

How come my gain is -Ā£1.79 yet FreeTrade shows Ā£4.46

3 Likes

Iā€™m pretty sure the gain/loss takes into account any dividends that youā€™ve received from the company, thatā€™s possibly why itā€™s higher than what you calculate.

I havenā€™t received any dividends yet from BP though.

Hmm, Iā€™m stumped then. I know there was an issue today with some of the pricing and the graphs, but I wouldnā€™t have thought that would have changed the calculation - maybe see if it changes tomorrow at market open, or drop Support a message?

Iā€™m guessing this is down to the first in first out calculation for FTs P&L rather than a cost average buy and sell.

Correct me if Iā€™m wrong but the profit/loss shown in FreeTrade in this example is wrong then? Because as you can see the profit if I sell is not Ā£4.46 but -Ā£1.79?

Itā€™s ā€œcorrectā€ though given how FT work out the AVG price which given a first in first out calculation makes the avg 5p less than your AVG price.

I think most users would prefer not to use a first in first out AVG calculation

6 Likes

I suspect many newbie investors are using this profit/loss calculation when selling out a position which in my instance would result in a -Ā£1.79 loss instead of Ā£4.46 gain.

Can someone from FreeTrade confirm this is how it works as it is very misleading.

5 Likes

I am using morningstar for portfolio tracking and it shows numbers completley different from the FT despite my best attempt to put all the fees in religiously. I am learning to live with it, although not sure what is causing the difference, possibly conversion rates (which wouldnā€™t apply to your BP stock).

1 Like

If I were to sell my entire BP holding this evening using the closing price of Ā£3.23 I would get back

The FreeTrade app showing that my position with BP is 3.57% (Ā£11.23) up.

But if I work out my gains manually Iā€™m only seeing an overall profit of Ā£5.28

0261107f244d4b42a29c359d1a7d6a39

Please can someone from FreeTrade look at this issue and advise if it is something Iā€™m doing wrong because there is a clear discrepancy between what FreeTrade shows as profit and what I am calculating.

4 Likes