Importing trades with CSV can save significant time, but a reliable import begins before you click “Import”. Every column should have a clear meaning and remain useful for later analysis.
Define a stable structure
At minimum include date, time, market, symbol, direction, entry, exit, size and result. If your journal analyzes process, also include strategy, timeframe, risk/R, fees, mistakes, plan adherence and notes.
Normalize formats
- Use one consistent date format across all rows.
- Do not mix decimal commas and decimal points in the same column.
- Use consistent labels for direction, market and strategy.
- Check timezone when exporting from different brokers or platforms.
Clean before importing
Look for duplicate rows, cancelled orders, test positions and missing values. If multiple fills are combined into one trade, define the rule before import so individual executions are not accidentally counted as separate trades.
Validate afterwards
Compare trade count, total PnL, commissions and a few specific trades against the original source. A technically successful import can still contain incorrect mappings.
Enrich after import
Broker exports usually contain execution data but not always strategy, mistake or plan adherence. Add those fields afterwards to turn a transaction history into an analytical journal.
Practical application
A reliable import starts before you click “Import”. Most errors come from inconsistent dates, mixed decimal formats, changing headers or categorical values written in several different ways.
Review checklist
- Keep an untouched backup of the original CSV.
- Use one timezone and one consistent date format.
- Normalise market, strategy and direction names.
- Validate a small sample before importing everything.
Frequently asked questions
What if my file does not contain one of the columns?
It depends on whether the field is required. Optional fields can remain empty or be completed later; avoid inventing data simply to fill columns.
Can I import the same file twice?
Avoid doing so unless the importer explicitly deduplicates records. A second import may create duplicate trades and distort statistics.