ExcelFree · no sign-upF&O and derivatives

Directional Option Buyer Journal

A 23-column Excel log for option buyers. On top of the usual trade fields it records days held, an estimate of daily theta and the % move the underlying needed to break even.

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
UnderlyingStrikeCE/PELotsEntry PremiumExit PremiumDays HeldBreakeven % MoveNet P&L
NIFTY25000CE11209820.88−1,493
NIFTY24800PE110213110.81+1,819
Illustrative rows, one lot of 65. Breakeven % is measured from the spot price at entry.
FormatExcel (.xlsx)
Trade Log sheet23 columns
Best forCE/PE buyers
Fill itEvery trade

What is inside

An option buyer can be right on direction and still lose if the move comes late or is too small. The Breakeven % Move and Theta Est columns make that visible on the row before you look at P&L.

Sort by Days Held after a month. If most losing trades were held past your planned exit day, a time-based exit rule will help more than a better entry signal.

Trade Log · 23 columns

One row per long option trade.

  • Date
  • Time
  • Underlying
  • Strike
  • Expiry
  • CE/PE
  • Product
  • Lots
  • Entry Premium
  • Exit Premium
  • Days Held
  • Theta Est (₹/day)
  • Breakeven % Move
  • Setup Tag
  • Session Tag
  • Planned ₹ Risk
  • Gross P&L
  • STT
  • Brokerage
  • Net P&L
  • R-Multiple
  • Violations
  • Notes

Worked example

Right direction, not enough move

With Nifty at 24,900, bought 1 lot of 25,000 CE at ₹120, stop ₹90. Nifty drifted up but the option was sold at ₹98 two sessions later (illustrative).

Breakeven move
0.88%
Net P&L
−₹1,493
R-multiple
−0.77R

The trade needed a 0.88% move at expiry and did not get it in time. Note "held past time exit" in Violations if your rule was one day.

The numbers

Breakeven % = (Strike + Premium − Spot) ÷ Spot(25,000 + 120 − 24,900) ÷ 24,900 = 0.88%
Gross = (Exit − Entry) × 65(98 − 120) × 65 = −₹1,430
Net = Gross − charges−1,430 − 63 = −₹1,493
R = Net ÷ ((Entry − Stop) × 65)−1,493 ÷ 1,950 = −0.77R

Formulas to paste in

The download has headers and a sample row, not formulas. These match its column letters.

Breakeven % Move for a CE (M2), spot in a helper cell X2
=(D2+I2-X2)/X2*100
Gross P&L (Q2), lot size in Settings
=(J2-I2)*H2*65
Net P&L (T2)
=Q2-R2-S2

How to fill it

  1. Note spot at entryWrite the underlying price when you buy so Breakeven % Move can be filled.
  2. Estimate thetaCopy theta per unit from your broker’s option chain into Theta Est (₹/day).
  3. Set a time exitDecide how many days you will hold if nothing happens and log breaches in Violations.
  4. Review losers by Days HeldOn Friday, sort losing trades by Days Held and look for a pattern.

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

Terms on this sheet

Questions traders ask

What is a good breakeven % for buying Nifty options?

There is no fixed number. Compare the breakeven move with how far Nifty usually moves in the days you plan to hold. If the needed move is larger than a normal day’s range and you hold one day, the odds are against you.

Does the journal calculate theta for me?

No. Theta Est (₹/day) is a manual column. Copy the theta from your option chain at entry; it is an estimate and changes every day.

Is the Directional Option Buyer 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.