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 →| Underlying | Strike | CE/PE | Lots | Entry Premium | Exit Premium | Days Held | Breakeven % Move | Net P&L |
|---|---|---|---|---|---|---|---|---|
| NIFTY | 25000 | CE | 1 | 120 | 98 | 2 | 0.88 | −1,493 |
| NIFTY | 24800 | PE | 1 | 102 | 131 | 1 | 0.81 | +1,819 |
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).
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
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
- Note spot at entryWrite the underlying price when you buy so Breakeven % Move can be filled.
- Estimate thetaCopy theta per unit from your broker’s option chain into Theta Est (₹/day).
- Set a time exitDecide how many days you will hold if nothing happens and log breaches in Violations.
- 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.
Related templates
Read next
Free calculators
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.