Trading 212 history into a journal, Invest and CFD

Trading 212 exports from the History screen: the menu, History, then Export. On Invest and ISA accounts you choose a timeframe and what to include, and a CSV downloads. On CFD accounts you pick categories like Closed Positions and press Generate, up to 12 months per file. For an Invest export, rename two price and share columns and the journal pairs your buys and sells into trades.

Invest and ISA accounts

1. Open the menu (the three lines) and choose History.
2. Press the export button.
3. Choose the timeframe and the data to include: orders, transactions, dividends. For a journal, orders is what you need.
4. The CSV downloads to your device.

The help centre does not state a range limit for Invest exports. Trading 212's community has mentioned a one year maximum per file, so export year by year to be safe.

Two renames before importing

A Trading 212 Invest export has an action column with values like Market buy and Market sell, which the journal understands. But share and price headers may be written in a way the reader does not recognise, such as "No. of shares" and "Price / share". We tested both versions:

Before the renames, two rows came in as two separate entries with zero P&L. After, a buy of 10 shares at 150 and a sale at 155 paired into one trade worth 50. Rows for deposits and dividends are skipped because they are not buys or sells.

Currency

Trading 212 shows prices in the instrument's currency and results in your account currency, with an exchange rate column between them. The journal calculates P&L from prices, so a US stock in a GBP account comes out in dollars. If you want account-currency results, compare the journal with Trading 212's Result column for a few trades and note the difference, or keep a separate journal account per currency.

CFD accounts

Trading 212's CFD export works a little differently. Menu > History > Export, choose the timeframe and categories, press Generate, and find past files under Recent exports. Each file holds up to 12 months. Categories include Closed Positions, Orders, Transactions, Dividends adjustment, Overnight Interest and Interest on Cash. Every row has a RecordType, and Trading 212 names columns such as Result, Total result, Spread, FX fee, Overnight interest, Position ID and Order ID.

Export Closed Positions on its own. Then import through the column mapper: tag Result or Total result as Net P&L, and the spread, FX fee and overnight interest columns as commission and swap if you want fees tracked.

What to look at

• FX fees. Trading foreign shares in a GBP or EUR account adds currency conversion on both sides. Total it.
• Overnight interest on CFDs. Compare result with total result on trades held for days.
• Trade versus invest. Keep long-term holdings in their own journal account.

Pies and automatic investing

If you use pies or recurring investments, their buys show up in the same export. They are not trading decisions in the usual sense. Filter them out before import, or put them in a separate journal account, so your trading stats describe the trades you chose yourself.