Iron Condor & Credit Spread Journal
A 12-column Excel log that records a whole spread on one row: the legs, net credit, max loss, margin blocked, any adjustment and what it cost to close.
The .xlsx opens in Excel, LibreOffice or Google Sheets (upload it to Drive, then open with Sheets). Delete the sample row before you log real trades.
See a worked example →| Date | Underlying | Strategy | Legs | Net Credit (₹) | Max Loss (₹) | Close Cost (₹) | Net P&L |
|---|---|---|---|---|---|---|---|
| 02/06/2026 | NIFTY | iron-condor | 24800/24700P + 25200/25300C | 2,015 | 4,485 | 585 | +1,233 |
| 16/06/2026 | NIFTY | credit-spread | 24900/24800P | 845 | 5,655 | 1,690 | −945 |
What is inside
Logging four legs on four rows hides the trade you actually made. This sheet keeps the spread as one decision, with the maximum loss written down before entry next to the credit you collected.
Comparing Net P&L with Max Loss over twenty or thirty trades shows whether the occasional full loss wipes out the steady small wins. The Adjustment column tells you whether your rolls helped.
Trade Log · 12 columns
One row per spread or condor, not per leg.
- Date
- Underlying
- Strategy
- Legs
- Net Credit (₹)
- Max Loss (₹)
- Margin (₹)
- Adjustment
- Close Cost (₹)
- Net P&L
- Expiry Tag
- Notes
Worked example
A one-lot Nifty iron condor
With Nifty near 25,000, sold 24,800/24,700 puts and 25,200/25,300 calls for a net 31 points and bought it back for 9 points (illustrative).
Eight orders cost about ₹197 here, mostly brokerage. On small credits, charges are a real share of the profit, so log them.
The numbers
Formulas to paste in
The download has headers and a sample row, not formulas. These match its column letters.
- Max Loss (F2), width in points in a helper cell
- =(100*65)-E2
- Net P&L (J2), charges in M2
- =E2-I2-M2
- Return on max loss
- =J2/F2
How to fill it
- Write max loss before entryFill Legs, Net Credit and Max Loss when you open the position, not after it moves.
- Copy margin from your brokerEnter the margin your broker actually blocked in Margin (₹).
- Log adjustments on the same rowDescribe any roll in Adjustment and keep the cost inside Close Cost (₹).
- Review by expiry tagOnce a month, compare Net P&L for weekly-expiry and monthly-expiry trades.
Same review, without the typing
TradeLyser imports trades from supported Indian brokers by sync or CSV, with charges, and shows win rate, profit factor and drawdown for each strategy.
Related templates
Read next
Free calculators
Terms on this sheet
Questions traders ask
Should I log each leg separately?
For review, no. One row per spread keeps credit, max loss and outcome together. Your broker’s contract note still has the leg-by-leg detail if you need it.
How do I calculate max loss on an iron condor?
Take the wider wing width in points, subtract the net credit in points, and multiply by the lot size. With 100-point wings and a 31-point credit on one Nifty lot of 65, that is ₹4,485.
Is the Iron Condor & Credit Spread Journal free?
Yes. The download link on this page needs no sign-up or email. The workbook ships with column headers and one sample row; add your own formulas or use the ones listed on this page.