IMHO the way to do this accurately is to offer an option for each share purchase to be setup in a new pot (thinking Monzo Pots) and for that pot/position to then have its own set of calculations to work with.
It would need to be an option because if you are trying to DCA you would not want that feature turned on.
Taking it to the extreme, bad UI / incorrect calculations led Robin Hood to show a -700k loss to one trader. He took his own life.
On a more realistic point, I wonder what view HMRC would take if someone provided tax information that was incorrect from Freetrade? Who would be liable?
I couldnāt work out why the shares I bought to average down were $11.80 how can I have averaged down past that to to $10.89 dollars?
Freetrade tell me they use a FIFO (first in first out) cost queue which doesnāt make sense to me; or at least doesnāt give me the information I want.
Unless Iām missing something fundamental - this is actually fairly possible; new to this - I see the price per share as the number of shares I own divided by the amount of money I paid for the shares.
When I sell shares, the PPS should simply take into account the profits/loss from my overall shares in that stock and re-calculate based on that.
most likely the result of FX fluctuations. The price GBP/USD when the dealings were executed is likely different from the price when you did your control calculations.
Did you buy all 2500 shares in one deal? Did you buy only 2500 shares before selling 2500 shares?
I never realised this happened I donāt sell much but this is interesting as I am interested in my long āreal termsā price I pay for my shares. Glad I have a spreadsheet page that doesnāt work on the FIFO principle as it gives a very inaccurate picture of your long term performance on a stock.
For a GIA (correct me if Iām wrong) this is only in the first 30 days. Stocks after that are lumped in one averaged pool with no distinction between when they were bought or sold (a section 104 holding).
I was trying to give a simplified idea of what happens, just a rule of thumb. I think, if I can recall, you mentioned in other posts things may get more complex with the 30 day rule and others. Feel free to fire away
Yeah I think for GIA accounts the 30 day rule is meant to simplify things for tax purposes but it does throw in an extra things to calculate if your just trying to verify your own numbers.
Iām not sure how ISAs are calculated? I assumed it was all just one pile since thereās no tax implications, but I may be wrong.
Just thought It wrong mentioning in case anyone does calculate it all and still comes up with a slightly different number
So i have 40 stocks which i hold and had a avg price of around $38.80 ish i then sold 15 shares of at $39.11 however the avg price went up to $44.88 how does that make sense as is there any way i can calculate the new avg price?
I have just noticed that for the calculation of average share price, it takes into account the selling shares too. So even if I buy and sell some shares at the same price, it seems to use the sold shares to average down (which it shouldnāt)