You get different methods -
FIFO
LIFO
AVCO
I use AVerage COst, but for all 3 in your scenario work out the same.
Even though you sold 20 shares for a quid, all you have done is realise a loss of Ā£20, the other shares you still hold, still cost you Ā£2 each, they didnāt become more expensive as the price you paid was the price at the time.
That only works if you bought shares in equal quantities and did not sell.
Yes thatās the way I would do but I canāt get the one I see on the app
If you wouldnāt mind, if you could share trade history for that one stock and what the current figure is, we could work between them. That way would have something to backup, if for whatever reason the numbers in the app were wrong.
| Time | ISIN | Ticker | Name | No. of shares | Price / share | Currency (Price / share) | Exchange rate | Result (EUR) | Total (EUR) |
|---|---|---|---|---|---|---|---|---|---|
| 25/09/2020 13:34 | US88579Y1010 | MMM | 3M | 1.0938659 | 159.52 | USD | 1.16329 | 150 | |
| 04/11/2020 14:56 | US88579Y1010 | MMM | 3M | 0.0031852 | 161.65 | USD | 1.1704 | 0.44 | |
| 18/11/2020 15:32 | US88579Y1010 | MMM | 3M | 0.0061542 | 173.57 | USD | 1.18696 | 0.9 | |
| 24/11/2020 14:35 | US88579Y1010 | MMM | 3M | 0.0035677 | 176.02 | USD | 1.18496 | 0.53 | |
| 30/11/2020 14:40 | US88579Y1010 | MMM | 3M | 1.7093364 | 175.43 | USD | 1.19938 | 250.02 | |
| 15/12/2020 15:53 | US88579Y1010 | MMM | 3M | 0.0035174 | 172.74 | USD | 1.21532 | 0.5 | |
| 18/12/2020 14:30 | US88579Y1010 | MMM | 3M | 1.7551961 | 177.4 | USD | 1.22461 | 254.26 | |
| 22/12/2020 14:35 | US88579Y1010 | MMM | 3M | 0.003632 | 175 | USD | 1.2223 | 0.52 |
I replied below hope this gonna help
Does this new feature only work for real accounts or even demo ones? I cannot find the CVS data download in the desktop app. Same thing for the android app, even after the update, I canāt find the download button.
Can exported data have price per share not rounded to 2 decimal digits? E.g.
Platform: 100 shares sold 0.2950/share = total 29.50
export: 100 shares sold 0.30/share = total 29.50
This thing still not fixedā¦
Just a thought, but if you think the dividend rate is showing as Net, can you not work out the actual amount for your taxes in the interim?
I need to prove that the 15% was paid, with this CVS file i cant do that as it has mistakes like this ā¦
a CSV file canāt act as proof in the first place. you can edit the values that are wrong to show the correct value, just like had you made the CSV file yourself to record your account history.
āproofā is evidence that the company pays a certain amount, your countries taxation treaty, (which are both public information) and how much you received in comparison to the original amount which is your own record. none of these have a signed document to vouch for them.
Just to bring up the issue of the pdf export as an option along side with the csv, since my eye didnāt catch any response.
Is it possible to have this option available? A pdf export with the T212 info, like a formal document.
Also for the dividend columns, can we name the title net price per share instead of price per share just to be clear that this refers to the net one?
These would help a lot.
Thanks
Yes, the PDF document was promised last year!!
I also miss to export the currently portfolio holdings in a CSV or XLS sheet!!
All these features are must havens!
Me 2. A simple but very useful feature.
A way to do that is copying (copy/paste) from the new beta web app. But it takes some time specially if you have a lot of opened positions.
Please @Team212 add the possibility to export our actual portfolio to an Excel file.
Still donāt understand why T212 shows only net values on their reports, causing confusion and dificulties on everyoneās tax calculations, as well as not including the used Exchange Rate on the dividends receivedā¦:
All the info should be easily available on the DBs, simple query change and itās doneā¦ Why make it harder for everyone (and for themselves to keep being asked the same things)?
T212 mentions some work on that:
Does anyone know if there is a way to export just your currently owned shares? The live viewer doesnāt seem copy and pasteable.
Problem with price / share
I am looking at the exported data and looks like āPrice / shareā column sometimes doesnāt match from contract note / app. Is it the case that āPrice / shareā is being rounded to 2 decimal places in export ?
Is it possible to keep it to itās original value ( 3 or 4 decimals ) ?
New Feature suggestion:
Can you also please add Ex-Dividend date to dividends export ?
Iāll need more details here so I can check the situation. A DM is on the way so keep an eye on your inbox 
Iāll pass this on for consideration and will keep you posted.