If you have a Trading 212 Invest account, you will probably need to calculate your Capital Gains tax after May 6th 2026.
I have made a Windows executable that converts the CSV file which you can download from Trading 212 - History and my program will convert the .csv file into a suitable text file which will load into the free cgtcalculator.com web app.
The steps are:
1. Download your CSV file from Trading212.
T212 only allows 12 months at a time (stupidly). So if the first trade is older than 12 months ago, you need to download all CSVs for all years. Note that you should only select ORDERS.
| Example - only 12 months allowed! |
Note that you should do this after May 6th 2026 (after tax year end) because of the 30-day rule. You need ALL orders in the CSV for all previous orders.
2. If you have multiple CSVs, you need to combine them into one CSV. The easiest way is to use the Windows command line, e.g.
copy T212_2024.csv + T212_2025.csv + T212_2026.csv test212.csv
Or just load each one into Excel and combine them by cutting and pasting.
There should be only one heading row but the program should ignore any extra heading rows.
Note that stock splits are not handled by the program and you may need to manually edit the final file. The example below shows that some lines were skipped/ignored.
3. Download and run my T212_convert.exe program from the Windows command line - e.g. T212_convert test212.csv
The .exe program and the .csv file should be in the same folder.
The program will only process 'Market Buy' or 'Market Sell' rows.
There are two output files - one is a .csv file with headings, but the other is a .txt file suitable for input into the free cgtcalculator tool. The two files will have _CVT appended to the name.
4. Go to cgtcalculator.com and click on 'Choose File' and then select the _CVT.txt file. Now click on 'Format/Sort' and check it looks OK. Finally click on the CALCULATE button.
If you would like to try the .exe file, please contact me at email:easy2boot@gmail.com and I will email it to you.
The program is written in Python and then compiled into a Windows .exe. I used ChatGPT to make it since I don't know Python.
The cgtcalculator has some converters but not Trading 212 AFAIK.
No comments:
Post a Comment