Brokers

Trading 212 portfolio tracker: benchmark your Trading 212 portfolio against the S&P 500

We read the Trading 212 CSV as it arrives in your inbox and turn the Action column into positions, income and cash flows. One file holds every event type together, so a market buy, a dividend and a deposit sit in the same list without anything getting lost between files. The range is capped at one year per export, so a longer history is usually several files and they are merged when you upload them.

What the file contains

The Action column names the event: a market buy, a limit sell, a dividend, a deposit. Every row carries a Time, and trades add ISIN, Ticker and Name so a holding can still be identified when a ticker is reused on another exchange.

No. of shares holds the quantity and it is often fractional to seven decimals. Price / share comes with a currency column of its own, Total comes with another, and Exchange rate records the conversion that actually happened on that row. That last column is why a euro cost basis for a dollar holding can be worked out from this file without any outside data.

Currency conversion fee and stamp duty reserve tax have their own columns. We book them as costs rather than folding them into the price, so the price stays the price and the charge stays visible.

The export comes as CSV, and we read the file as it is: no renaming, no reformatting, no cleaning up in a spreadsheet first. The columns we look for in this export are Action, Time, ISIN, Ticker, Name, No. of shares, Price / share, Currency (Price / share), Exchange rate, Total, Currency (Total), Currency conversion fee and Stamp duty reserve tax.

How the import works for Trading 212

Trading 212 has a reader of its own, tested against real exports. Upload the file as it came off your account and the columns are recognised without you mapping anything.

The export icon in the history screen, with orders, dividends and transactions all ticked; the CSV is delivered by email. The full route is in our Trading 212 export guide.

Tick all three data types even when you only care about one. Orders rebuild the positions, dividends record the income, and the transaction rows establish when money entered and left, which is what a fair comparison with an index is anchored to. A missing deposit does not announce itself as an error; it presents itself as a better return.

If an action appears that we do not handle, the row is named in the import report instead of being counted as something it is not.

What to watch for with Trading 212 files

Fractional shares. A line of 0.0384741 of a share is ordinary here. Those digits carry weight, so a file that has passed through a spreadsheet and come back rounded produces share counts that no longer agree with your account.

Pies. A rebalance inside a pie generates a burst of small purchases and sales, each one banking a small result. Nothing about your strategy changed, which is why realised results are totalled per holding rather than per transaction.

One year per export. A multi-year history takes several files. Uploading them together is fine, and uploading the same file twice changes nothing, because rows already known are recognised and skipped.

Two currency columns. The price and the total each name their own currency, and the two are not always the same. We keep them apart instead of assuming a single account currency.

What you see after the upload

Your file becomes a verdict first: your time-weighted return next to the S&P 500 and the Nasdaq 100 over the same period, with your own deposits replayed into the index so both sides carry the same timing. Under it sit your positions with their cost basis, the dividends you received and the income your holdings are expected to pay, your allocation across positions and currencies, and a year report you can keep for your records.

Because the file dates every deposit and every dividend, the yearly report separates what your holdings paid out from what you put in, per holding and per year.

You can look at all of that on the demo portfolio before you upload anything of your own. The first two weeks are free and no card is asked for.

Frequently asked questions

Why does the export arrive by email? That is simply how Trading 212 delivers it. You request the file and the CSV lands in your inbox a few minutes later. Upload the attachment as it came, rather than a copy you opened and saved, because a spreadsheet round trip is the most common way a clean export turns into a broken one.

Do purchases made inside a pie show up? Yes, as ordinary order rows. The export does not label which pie a purchase belonged to, and for cost basis, returns and dividends that makes no difference: a purchase is a purchase. Rebalancing simply adds more rows, which is why the file can look busier than your actual activity.

My dividends are missing. What went wrong? Almost always a data type that was not ticked when the export was requested. Orders, dividends and transactions are selected separately, and a file containing only orders has no income in it at all. Request a new export with all three selected and upload it; the overlap with what you already imported is handled.

How often should I upload a new file? Monthly suits most people, and more often if you trade weekly. Each export is cumulative history for the range you picked, so a fresh file contains everything the previous one did plus whatever happened since. Re-uploading an overlapping period does not double anything up.