NSE F&O Options Trading Journal
A 20-column Excel trade log for Nifty and stock options, with a Settings tab for lot sizes, a Setup Tags list and a Weekly Summary sheet for the Friday review.
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 | Strike | CE/PE | Lots | Entry Premium | Exit Premium | Setup Tag | Net P&L |
|---|---|---|---|---|---|---|---|---|
| 09/06/2026 | NIFTY | 25000 | CE | 2 | 118 | 142 | directional-ce | +3,030 |
| 10/06/2026 | NIFTY | 24900 | PE | 1 | 96 | 74 | vwap-rejection | −1,489 |
| 12/06/2026 | NIFTY | 25100 | CE | 1 | 84 | 101 | directional-ce | +1,043 |
What is inside
The log keeps the fields an Indian option trade needs: strike, expiry, CE or PE, MIS or NRML, and lots rather than quantity. Lots multiply by the lot size you keep in Settings, so when NSE revises a contract you change one cell.
Every row carries a Setup Tag and a Session Tag. That is what lets the Weekly Summary show which setup made money and which one gave it back on expiry day, instead of one blended P&L number.
Settings · 3 columns
Trading capital, max daily loss, max risk per trade %, Nifty and Bank Nifty lot size, broker.
- Setting
- Value
- Notes
Setup Tags · 4 columns
Your list of setups. Ships with directional-ce, directional-pe, iron-condor, expiry-theta and vwap-rejection.
- Setup Tag
- Description
- Ideal R:R
- Active?
Trade Log · 20 columns
One row per option trade.
- Date
- Time
- Underlying
- Strike
- Expiry
- CE/PE
- Product
- Lots
- Entry Premium
- Exit Premium
- Setup Tag
- Session Tag
- Planned ₹ Risk
- Gross P&L
- STT
- Brokerage
- Net P&L
- R-Multiple
- Violations
- Notes
Weekly Summary · 7 columns
One row per week for the Friday review.
- Week Ending
- Trades
- Net P&L ₹
- Win Rate
- Best Tag
- Worst Rule Break
- One Change
Worked example
Two lots of a Nifty call on expiry Tuesday
Bought 2 lots of Nifty 25,000 CE at ₹118 with a stop at ₹95 and sold at ₹142 (illustrative).
A 1R winner is fine if the checklist was followed. Tag it directional-ce so the Friday review can compare it with your other setups.
The numbers
Formulas to paste in
The download has headers and a sample row, not formulas. These match its column letters.
- Gross P&L (N2)
- =(J2-I2)*H2*Settings!$B$5
- STT (O2)
- =J2*H2*Settings!$B$5*0.15%
- Net P&L (Q2)
- =N2-O2-P2
- R-Multiple (R2)
- =Q2/M2
How to fill it
- Check lot sizes firstOpen Settings and confirm the lot sizes: Nifty 65 and Bank Nifty 30 (check the current NSE circular, lot sizes are revised periodically).
- Edit the setup listKeep only setups you actually trade in Setup Tags. Five clear tags beat twenty vague ones.
- Log each trade after the closeFill one Trade Log row per trade with lots, premiums, Planned ₹ Risk and both tags. Put all non-STT charges in the Brokerage column.
- Fill the Weekly Summary on FridayCount trades, total Net P&L, best tag and worst rule break, then write one change for next week.
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
Why does the journal ask for lots instead of quantity?
NSE options trade in lots, and lot sizes change when NSE revises contracts. Logging lots and keeping the lot size in Settings means one edit fixes every formula.
Where do brokerage, exchange charges and GST go?
STT has its own column. Put brokerage, exchange transaction charges, GST, SEBI fee and stamp duty together in the Brokerage column, or copy the total from your contract note.
Is the NSE F&O Options Trading 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.