Map your CSV columns
Every broker names its columns a little differently, so the import wizard has a mapping step that tells Tradestacker which column is which. Most of the time it's done for you — here's how it works and how to fix it if needed.
Auto-detection
When you upload a file, Tradestacker reads the header row and auto-detects the common fields by matching against known broker column names. Picking your broker in Step 1 makes this even more accurate, because Tradestacker knows exactly which headers to expect from that platform.
The fields you can map
You can confirm or set each of these by hand:
- Symbol — the ticker / instrument
- Side — buy/sell (long/short)
- Entry — entry price
- Exit — exit price
- Qty — quantity (shares / contracts / units / lots)
- P&L — realized profit/loss, if your broker provides it
- Date / time — entry time, and exit time where the file has both
- Commission / fees — trading costs
To change a mapping, open the dropdown next to a field and pick the matching column from your file.
💡 Tip: Not every column needs a match. If your broker doesn't include separate entry/exit prices (only fills), Tradestacker pairs the fills with FIFO and works out the rest — see Executions and FIFO pairing.
Preview before importing
Once the mapping looks right, Tradestacker shows a preview of the rows it's about to import. Scan a few rows to confirm the symbols, sides, prices, and P&L look correct, then confirm. Nothing is saved until you do.
If something looks wrong
- Symbols look blank or jumbled: map the Symbol field to the correct column.
- Buys and sells are flipped: check the Side mapping.
- P&L is off by a fixed factor on futures: that's usually a symbol point-value issue, not a mapping one — see Symbol settings.
- Imported the wrong file: you can undo it within 24 hours — see Undo an import.
Related articles
Still stuck? Email support@tradestacker.co and we'll help.