Column Guide
Required columns marked with *
date * — Trade date (DD/MM/YYYY or YYYY-MM-DD)
sl * — Stop Loss distance from entry in points (always positive, e.g. 20)
tgt * — Target/Take-Profit distance from entry in points (always positive, e.g. 40)
ctc * — Close-to-Close: actual P&L of the trade in points (+ve = profit, -ve = loss)
sl_shift — Points SL was trailed in your favor (0 = no trail)
OPTIONAL - for deeper analysis:
trade_id for partial exits — Links partial exits together. Same trade_id = same trade. Each row = one exit.
direction optional — LONG or SHORT
quantity optional — Lots/contracts for THIS exit (not total)
entry_time / exit_time optional — Format: hh:mm (e.g. 09:30) or Xd hh:mm for multi-day (e.g. 1d 14:30)
mae optional — Maximum Adverse Excursion (worst unrealized loss during trade, in points)
mfe optional — Maximum Favorable Excursion (best unrealized profit during trade, in points)
charges optional — Brokerage + taxes per trade
entry_price / exit_price optional — Actual entry and exit prices