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