Broker guides

Trading 212 export guide: getting your full history out

Trading 212 makes exporting easy, once you know where they hid it. This guide covers the route, the columns that deserve a second look, the Pies quirk that confuses everyone at least once, and what to verify before you trust anything built on the file.

Why bother exporting

Trading 212's app is pleasant to use, which is precisely why so few people ever pull their data out of it. But the app answers a narrow set of questions — what do I hold, how does the line look — and stays silent on the ones that determine whether the whole exercise is working. What is your time-weighted return, the figure you can honestly compare with an index? What did you really pay for each position once fees and currency conversion are counted? What did dividends contribute, and at what rate are they arriving?

All of those answers live in your transaction history, and the export is the only complete, portable copy of that history you can get. It is also your record if you ever switch brokers, do your taxes, or simply want your bookkeeping to exist somewhere other than one company's app. Downloading it costs a few minutes; not having it costs you the ability to check anything independently.

Where it is

In the app or web: Menu → History → the export icon (top right). Pick your date range and the data types, include Orders, Dividends, and Transactions (deposits/withdrawals). You'll get a CSV by email within a few minutes.

Maximum range per export is one year, so for a full history you'll export a few files. Any decent tracker merges them without complaint.

Include all three data types even if you only care about one of them right now. Orders rebuild your positions and cost basis; Dividends record the income your holdings generated; Transactions establish when money entered and left the account, which is what return calculations are anchored to. Leave one out and the resulting picture is not slightly incomplete — it is wrong in ways that don't announce themselves. A missing deposit, for instance, makes your return look better than it was, an error nobody rushes to investigate.

The columns worth understanding

The Action column is where everything lives: "Market buy", "Limit sell", "Dividend (Ordinary)", "Deposit". One file, every event type mixed together, actually convenient, because nothing gets lost between files.

No. of shares can be fractional, 0.0384741 of an Apple share is a perfectly normal line in a T212 export. If you ever move to a spreadsheet, format those cells before Excel rounds your history into fiction.

Exchange rate is included per transaction, which is genuinely helpful: your euro cost basis for USD stocks is computable without external FX data.

The fractional-shares point deserves emphasis, because it's the single most common way people mangle this file. Seven decimal places of a share is exactly how fractional investing works, and those digits are load-bearing: rounded to two decimals, your share counts stop matching reality, your cost basis shifts, and small phantom gains or losses appear from nowhere. The same caution applies to the exchange-rate column. That per-transaction rate is what makes an honest home-currency cost basis possible — it records the conversion that actually happened, rather than forcing you (or your tool) to guess with external data. If you're doing the arithmetic yourself, average cost basis explained walks through what to do with it.

Watch for: the pies

If you invest through Pies, individual purchases still show up as separate order lines, good. But rebalancing generates a burst of tiny buys and sells that can look alarming in your realized-gains view. It's normal. It's also a good reason to track realized results per position rather than per transaction.

The underlying logic: a rebalance trims what has grown and tops up what has lagged, so it necessarily sells slivers of your winners — each sliver realizing a tiny gain — and buys slivers of the rest. Fifty micro-transactions later, your history looks like the work of a hyperactive day trader, when in fact you changed nothing about your strategy. Viewed per position, the noise collapses back into a sensible story. If the distinction between realized and paper results is fuzzy, realized vs unrealized gains covers it.

Common mistakes

A short list, in descending order of frequency. Exporting only Orders and wondering where the dividends went — they're a separate data type; tick all three. Leaving a gap between files — the one-year maximum means a multi-year history takes several exports, and a missing year produces sells without buys and positions without origins. Opening the CSV in Excel, saving it, and uploading the saved copy — Excel's helpful reformatting of dates and decimals is how clean files become broken ones; upload the original from the email. And exporting a range that starts after your first trade, which quietly corrupts the cost basis of everything you bought before the cutoff.

What to check after exporting

Two minutes of verification saves an hour of confusion later.

Confirm the earliest file reaches back to your first-ever trade, and that consecutive files leave no gap in dates.
Net out the buys and sells for a couple of holdings and check the result matches what the app shows today.
Spot-check that dividend rows exist for months you know you were paid.
Confirm every deposit you remember making appears as a Transaction row.

If anything is missing, the fix is almost always another export with a corrected range or the missing data type ticked — the underlying record at Trading 212 is complete; the export settings are where things go astray.

Frequently asked questions

Why does the export arrive by email instead of downloading directly? That's simply how Trading 212 delivers it: you request the file, and the CSV lands in your inbox within a few minutes. Mildly old-fashioned, entirely functional.

Can I get my whole history in one file? No — the maximum range per export is one year. Export one file per year and upload them together; merging is the tracker's job, not yours.

Do the Pies show up in the export? Yes, as ordinary order lines. The export doesn't label which Pie a purchase belonged to, but for cost basis, returns, and dividends that doesn't matter — a buy is a buy.

Does uploading the CSV give anyone access to my account? No. A file-based tracker never sees your login, only the history you chose to export — the argument for keeping it that way is in portfolio tracking without broker login.

How often should I export? Monthly suits most people. The file is cumulative history, so a fresh export always contains everything the previous one did, plus whatever happened since.

From export to insight

The export tells you what happened. It doesn't tell you your time-weighted return, whether your picks beat an index tracker, or what your dividend run-rate looks like. Upload the same CSV to BullBenchmark and those answers are on one screen, updated daily against the S&P 500 and QQQ.

The first week of BullBenchmark is free, no card, upload the export you just downloaded and see where you stand.