ExcelFree · no sign-upF&O and derivatives

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 →
SettingsSetup TagsTrade LogWeekly Summary
DateUnderlyingStrikeCE/PELotsEntry PremiumExit PremiumSetup TagNet P&L
09/06/2026NIFTY25000CE2118142directional-ce+3,030
10/06/2026NIFTY24900PE19674vwap-rejection−1,489
12/06/2026NIFTY25100CE184101directional-ce+1,043
Trade Log with illustrative rows. Net P&L is after STT, brokerage, exchange charges, GST and stamp duty.
FormatExcel (.xlsx)
Trade Log sheet20 columns
Best forNifty option traders
Fill itEvery session

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

Gross P&L
₹3,120
Charges
₹90
Net P&L
+₹3,030
R-multiple
1.01R

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

Gross = (Exit − Entry) × Lot size × Lots(142 − 118) × 65 × 2 = ₹3,120
STT = 0.15% × sell-side premium0.15% × 142 × 130 = ₹28
Other charges (Brokerage column)₹40 brokerage + exchange, GST and stamp ≈ ₹62
R = Net ÷ ((Entry − Stop) × Lot size × Lots)3,030 ÷ 2,990 ≈ 1.01R

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

  1. 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).
  2. Edit the setup listKeep only setups you actually trade in Setup Tags. Five clear tags beat twenty vague ones.
  3. 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.
  4. 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.

Try TradeLyser free

Read next

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.