Check columns and number conventions
The trade-list format uses Account, Symbol, Contract, Entry Date, Exit Date, Side, Quantity, Gross P/L and Net P/L. Check the delimiter and decimal convention in your own export. The difference between gross and net results is used as the cost amount.
Dates and times use YYYY-MM-DD HH:mm:ss. The timestamp columns do not carry a time-zone identifier, so document the export zone separately. The sample defines its times as UTC; this is a property of the example, not an automatic conversion performed by the importer.
Check the target account and preview
Choose the target account explicitly in the import dialog. The file’s Account column does not replace that choice. Before saving your own file, check the preview for trade count, sides, quantities and date assignments. The table here is a visible reconciliation example.
Use reconciliation totals
The on-page example reconciles to USD 150 before costs, USD 40 in costs and USD 110 after costs. If it does not, first check decimal separators, signs and double-counted costs. Also check for trades already imported. Reconcile your own records against the totals in the original export.
A reproducible example
| Measure | Before costs | After costs |
|---|---|---|
| Sum of winning trades (USD) | 550.00 | 530.00 |
| Absolute sum of losing trades (USD) | 400.00 | 420.00 |
| Balance: wins minus losses (USD) | 150.00 | 110.00 |
| Profit Factor | 1.375 | 1.262 |
USD 550 in wins − USD 400 in losses = USD 150 balance before costs. After 8 × USD 5 in costs, USD 110 remains. Net profit factor first deducts costs from each trade: 530 / 420 ≈ 1.262.
- Balance before costs
- 150.00 USD
- Total costs
- 40.00 USD
- Balance after costs
- 110.00 USD
- Profit factor after costs
- 1.26
- Expectancy per trade
- 13.75 USD
- Max. drawdown
- 175.00 USD
| # | Entry (UTC) | Trade before costs | Costs | Trade after costs | Plan followed |
|---|---|---|---|---|---|
| 1 | 2026-09-10 13:30:00 | 150.00 | 5.00 | 145.00 | Yes |
| 2 | 2026-09-10 13:40:00 | -100.00 | 5.00 | -105.00 | Yes |
| 3 | 2026-09-10 13:50:00 | 250.00 | 5.00 | 245.00 | Yes |
| 4 | 2026-09-10 14:00:00 | -150.00 | 5.00 | -155.00 | Yes |
| 5 | 2026-09-10 14:10:00 | 50.00 | 5.00 | 45.00 | No |
| 6 | 2026-09-10 14:20:00 | -50.00 | 5.00 | -55.00 | Yes |
| 7 | 2026-09-10 14:30:00 | 100.00 | 5.00 | 95.00 | Yes |
| 8 | 2026-09-10 14:40:00 | -100.00 | 5.00 | -105.00 | No |