Import trades from Excel / MT5
Three ways to bulk-load trades without typing them one by one.
The essentials
- MT5 XLSX/CSV report — for initial history.
- JTTS_EA — recommended for production, syncs every trade in ~5 seconds.
- Your own Excel — adapt your columns to the journal format.
The three routes
1 · MT5 XLSX/CSV report
- In MT5 → Account History → right-click → Save As Report (HTML/XLSX).
- In /trades → "Import" → pick the file. Standard columns auto-detected.
- Automatic dedup by (account_id, mt5_deal_id) — re-importing the same report doesn't create duplicates.
2 · JTTS_EA (recommended for production)
- Once installed, syncs every closed trade automatically in ~5 seconds.
- For history, in Connect → Integrations click "Sync" to pull the last 30 days.
- See "Connect MT5 with JTTS_EA" in Integrations for setup.
3 · Your own Excel
- If you keep a prior Excel journal, adapt the columns to the journal format and upload in /trades → Import.
- Minimum columns: account, date, asset, profit_usd. The rest optional.
When to use each
- New setup with history
- JTTS_EA bootstrap or XLSX report.
- Day-to-day
- JTTS_EA on auto.
- Crypto / cTrader / NinjaTrader
- Use the native integration of each platform.
Related
Log a trade manually
Go to /trades → "New Trade". The modal asks for the essentials so the journal can compute meaningful metrics.
Connect MT5 with JTTS_EA
JTTS_EA is the MetaTrader 5 Expert Advisor that syncs your trades and applies Risk-config rules in real time.
Supported platforms
JournalByTTS connects with the main propfirm platforms and brokers to sync trades and apply risk rules automatically.