Swing Trading Journal for Trading 212 | Excel Trading Journal with CSV Import & Position Sizer
Stop retyping your Trading 212 trades. Export your history from Trading 212 as CSV, paste it into this workbook and its formulas turn every buy and sell into a clean round-trip trade. Scale-ins, partial exits and fees are handled. Then paste the trades into a swing-trading journal that calculates P&L, R-multiples, holding days and return on cost.
In Trading 212 (Invest or Stocks ISA), open History, choose Export, pick the period and tick Orders. The importer reads Action, Time, Ticker, No. of shares, Price / share and the fee columns by header name; deposits, dividends and interest rows are skipped. UK shares priced in pence (GBX) are converted to GBP. No macros, add-ins, logins or subscription, and your data never leaves your file.
The column layout is taken from public sources on the Trading 212 export format (official help or developer pages and public sample files, listed in the User Guide). If Trading 212 renames a column, type the new header on the Import Setup sheet; nothing else needs to change.
It also has a built-in position-size calculator. Enter your entry, stop and target to get shares, position value, % of account and reward:risk, capped by your max position size. The portfolio heat table pulls your open trades from the journal and warns you before total open risk goes over your limit.
The dashboard updates itself: net P&L, win rate, profit factor, expectancy in R, payoff ratio, max drawdown, an equity curve, and P&L by month, setup, weekday and side. A 'cost of mistakes' table shows what chasing entries or moving stops really cost you.
It comes with 22 fictional example trades, a fictional sample Trading 212 file to practise the import (36 executions, 17 trades) and a 10-page PDF guide with a step-by-step import walkthrough.
What's included
• Rangefolio-Swing-Journal-Trading212.xlsx (11 sheets: Start Here, Settings, Trade Journal, Dashboard, Position Sizer, T212 Import, Import Setup, Import Results, Lists, plus 2 protected helper sheets)
• sample-trading212-history.csv (fictional sample, 36 executions / 17 trades)
• User-Guide.pdf (10 pages: setup, Trading 212 export walkthrough with public format sources, importing, journaling, sizing, dashboard, troubleshooting)
Who it's for
• Stock and ETF swing traders who use Trading 212 (Invest and Stocks ISA)
• Traders who think in R-multiples and want to know their real expectancy
• Anyone who wants a risk-first routine: size every trade and cap total portfolio heat
• People who prefer a spreadsheet they own to a monthly journaling subscription
File formats and compatibility
• Microsoft Excel .xlsx workbook, sample CSV and PDF user guide, delivered as one zip
• Built for Microsoft Excel 2019/365 (.xlsx, no macros). Tested in LibreOffice Calc. Google Sheets import is possible but not officially supported.
• Formulas only: no macros or VBA, no add-ins, works offline
• Instant digital download; no physical item is shipped
FAQ
Q: Does it connect to my Trading 212 account?
A: No. Nothing logs in or syncs. You export a file from your broker, open it and paste it in. Your data stays in your own file.
Q: Does it handle partial exits and scaling in?
A: Yes. Fills are grouped from flat to flat for each symbol. Adds are averaged into the entry price and partial sales into the exit price. A trade stays marked Partial until it's fully closed.
Q: Which currency is P&L in?
A: In the share's own currency (for example USD for US shares). Fees charged in your account currency are converted using the row's exchange rate, so P&L can differ from Trading 212's Result column, which is in your account currency.
Q: Does it support CFD accounts?
A: No. Invest and Stocks ISA exports only; CFD exports use a different layout. Trading 212 Invest has no short selling, so every imported trade is Long.
Q: How is this different from the IBKR version?
A: It's the same journal, sizer and dashboard. Only the import sheet differs: this one reads Trading 212's export instead of an Interactive Brokers Flex Query. You only need the version for your broker.
Q: Is this financial advice?
A: No. It's a record-keeping and calculation tool for education only. It doesn't recommend any trade. All example data is fictional.
Not affiliated with or endorsed by Trading 212.
Disclaimer: For educational and record-keeping purposes only. Not financial, investment, tax or trading advice. Trading involves substantial risk of loss. Example data is fictional. Trading 212 is named only to describe file compatibility. Not affiliated with or endorsed by Trading 212. Export formats are based on public documentation and can change.