ExcelFree · no sign-upF&O and derivatives

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 →
Trade Log
DateUnderlyingStrategyLegsNet Credit (₹)Max Loss (₹)Close Cost (₹)Net P&L
02/06/2026NIFTYiron-condor24800/24700P + 25200/25300C2,0154,485585+1,233
16/06/2026NIFTYcredit-spread24900/24800P8455,6551,690−945
Illustrative rows for one lot (65 units). Net P&L is after charges on all legs.
FormatExcel (.xlsx)
Trade Log sheet12 columns
Best forOption sellers using spreads
Fill itEvery spread

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).

Net credit
₹2,015
Max loss
₹4,485
Net P&L
+₹1,233
Return on max loss
27%

Eight orders cost about ₹197 here, mostly brokerage. On small credits, charges are a real share of the profit, so log them.

The numbers

Net credit = credit points × lot size31 × 65 = ₹2,015
Max loss = (wing width − credit) × lot size(100 − 31) × 65 = ₹4,485
Net P&L = credit − close cost − charges2,015 − 585 − 197 = ₹1,233

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

  1. Write max loss before entryFill Legs, Net Credit and Max Loss when you open the position, not after it moves.
  2. Copy margin from your brokerEnter the margin your broker actually blocked in Margin (₹).
  3. Log adjustments on the same rowDescribe any roll in Adjustment and keep the cost inside Close Cost (₹).
  4. 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.

Try TradeLyser free

Read next

Free calculators

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.