Indian Options Trading Journal for F&O

What is an Indian F&O Trading Journal?

An Indian F&O trading journal is a record of every NSE or BSE futures and options trade with the fields that actually drive P&L in this market: entry timestamp, underlying spot, strike, premium, lot size, SPAN + exposure margin blocked, Greeks at entry, India VIX, a strategy tag, and a full charges breakdown (brokerage, STT, SEBI fee, stamp duty, exchange transaction charges, 18% GST). It is the tool that separates the 7% of Indian F&O traders who make money from the 93% who do not.

That 93% figure is not opinion. According to SEBI’s September 2024 study of 9.6 million individual traders in the equity F&O segment, 93% lost money over FY22–FY24, with aggregate losses of ₹1.81 lakh crore. The earlier January 2023 SEBI study had already flagged the problem: 89% lost money in FY22 at an average of ₹1.1 lakh per trader. In neither study did the losing traders lack conviction. They lacked tracking.

Why Indian F&O Needs Its Own Journal (Not a Repurposed US Options Tool)

Most options journaling guides on the internet are written for US traders — SPX, QQQ, monthly and 0DTE expiries, Section 1256 tax treatment, flat per-contract fees. None of that transfers to Indian F&O:

• Lot sizes are fixed, not per-contract. A Nifty lot is 75 (up from 25 on 20 November 2024); BankNifty is 35 (up from 15); FinNifty is 40 (up from 25). Your journal must record lot size at the time of trade or historical notional P&L breaks.
• STT on ITM exercise is 0.125% of intrinsic — an asymmetric tax that can erase deep-ITM profits if you forget to square off before 15:30 IST on expiry Thursday. US traders have no equivalent.
• Weekly expiry is now one per exchange. Post 20 November 2024, NSE retains only Nifty weekly; BSE retains Sensex weekly. BankNifty and FinNifty are monthly-only. Any journal template still assuming BankNifty Wednesday weeklies is out of date.
• Minimum contract value is ₹15 lakh. SEBI raised it from ₹5–10 lakh in October 2024. A single Nifty lot now carries roughly ₹18–19 lakh notional, changing margin and position-sizing math.
• F&O is business income under Section 43(5), not capital gains. Turnover is calculated per the ICAI Guidance Note as absolute profit + absolute loss + premium received on options sold — a number that can cross ₹10 crore and trigger a tax audit even for small accounts.

Trading Hours

Session	Open (IST)	Close (IST)	Notes
Pre-Open	09:00	09:15	Order matching, no execution
Regular	09:15	15:30	All F&O execution

The first 30 minutes after open (09:15–09:45 IST) and the last 60 minutes (14:30–15:30 IST) concentrate most of the day’s volatility, especially on expiry Thursdays when gamma accelerates near ATM strikes. Expiry-day settlement cuts off at 15:30 IST sharp — any ITM position left unclosed triggers the 0.125% STT on intrinsic value. Log session-bucket of entry (open, mid-day, close) and execution-timing patterns emerge within 30 trades.

Worked Example: Journaling a BankNifty Monthly Bull Put Spread

A concrete example matters more than a checklist. Here is a complete journal entry for a typical Indian F&O trade, post Nov 2024 rules.

Setup (Monday, monthly expiry week):

• BankNifty spot: 51,200
• Strategy: Bull Put Spread (monthly expiry, last Thursday)
• Leg 1: Sell 50,800 PE at ₹180
• Leg 2: Buy 50,600 PE at ₹120
• Net credit: ₹60 × 35 (lot size) = ₹2,100 gross
• SPAN + exposure margin blocked: around ₹28,000 (hedged spread)
• India VIX at entry: 14 (roughly 40th percentile of trailing 90-day range)
• Greeks at entry: net delta +0.15, net theta +₹45/day, net vega around −₹12 per IV-point

Expiry Thursday outcome:

• BankNifty closes at 51,400 — both legs expire worthless
• Gross profit: ₹2,100

Full charges breakdown (this is what a thin journal hides):

Charge	Formula	Amount
Brokerage (Zerodha)	Flat ₹20 × 4 orders	₹80
STT (sell-side premium only)	₹180 × 35 × 0.0625%	₹3.94
SEBI fee	₹10 per crore turnover	₹0.40
Stamp duty	0.003% on buy side	₹1.26
Exchange transaction charges	NSE rates on premium	₹12.30
GST	18% on brokerage + transaction	₹17.33
Total charges		around ₹115

Net P&L: ₹2,100 − ₹115 = ₹1,985 on ₹28,000 margin = 7.09% monthly ROI.

Journal fields captured:

date: 2026-04-15
strategy: bull-put-spread
underlying: BANKNIFTY
expiry: 2026-04-30 (monthly)
legs:
  - action: SELL
    strike: 50800
    type: PE
    qty: 35
    entry_price: 180
  - action: BUY
    strike: 50600
    type: PE
    qty: 35
    entry_price: 120
spot_at_entry: 51200
india_vix: 14
vix_percentile: 40
net_credit: 2100
margin_blocked: 28000
net_delta: 0.15
net_theta: 45
exit_reason: expired_worthless
gross_pnl: 2100
charges_total: 115
net_pnl: 1985
roi_on_margin: 7.09%
psychology_note: "Target was 80% premium decay. Would have freed ₹28k margin on Wednesday — missed opportunity to redeploy."

The psychology note is where the 93% failure rate gets attacked. Gross P&L said “win.” The psychology note identifies the capital-efficiency gap between what you did and what was optimal. Over 100 trades, those gaps are where alpha lives.

Popular Instruments (Post November 2024)

Index Options (highest volume):

• Nifty 50 Options — The most liquid derivative in India. Weekly expiry every Thursday, plus monthly expiry on the last Thursday. Lot size: 75.
• BankNifty Options — Monthly-only expiry (last Thursday) after the Nov 2024 framework. Lot size: 35. Still the second-highest volume index option.
• FinNifty Options — Monthly-only expiry after Nov 2024. Lot size: 40. Lower liquidity than Nifty/BankNifty.
• Sensex Options (BSE) — BSE retained its weekly expiry on Tuesday, making this the only weekly bank-heavy index option post Nov 2024. Lot size: 10.

Index Futures:

• Nifty 50 and BankNifty futures serve as hedging and directional instruments. Lower volume than options but critical for delta hedging.

Stock F&O:

• Over 175 stocks have F&O contracts on NSE. Stock options are less liquid than index options but offer event-based opportunities around earnings and corporate actions.

Popular Brokers and Import Support

Broker	Brokerage (F&O)	Import to JournalPlus	CSV Fields
Zerodha	Flat ₹20 or 0.03%, whichever is lower	Supported	Full charges breakdown included
Dhan	Flat ₹20 or 0.03%, whichever is lower	Not yet	Manual CSV export
Angel One	Flat ₹20	Not yet	Tradebook CSV available
Upstox	Flat ₹20	Not yet	API + CSV export available
Groww	Flat ₹20	Not yet	Growing F&O user base since 2024

Zerodha’s Console tradebook includes every line-item charge, making it the only broker where a complete charges-level journal can be built without manual input. For other brokers, plan to spend 5–10 minutes per trading day reconciling charges against the contract note PDF.

Challenges and Solutions

STT on ITM Exercise

Challenge. STT on options sold is 0.0625% of premium, but options exercised ITM attract 0.125% on the full settlement value. A deep-ITM position left to expire can see STT exceed the day’s profit.

Solution. Log STT as a separate cost field, not buried under “total charges.” Set a 15:20 IST expiry-day alert on any ITM position. Square off manually rather than let exercise happen automatically.

Weekly Expiry Overtrading

Challenge. Weekly Nifty expiry invites 20+ trades per week with no review cycle. SEBI’s 2024 study tied this overtrading pattern directly to the 93% loss rate.

Solution. Tag every trade by expiry cycle (Nifty weekly, Sensex weekly, BankNifty monthly, FinNifty monthly) and review weekly. When the data shows Nifty Thursday scalps lose money but BankNifty monthly iron condors make money, the capital reallocation is obvious.

Premium Decay Attribution

Challenge. Theta is the main profit mechanism for option sellers, but without recording theta at entry, it is impossible to distinguish skill from the mere passage of time.

Solution. Record theta at entry and expected decay over the planned holding period. Compare to actual P&L. If actual exceeds expected theta, directional moves helped; if less, IV or gamma hurt.

Strategy-Level Performance Blindness

Challenge. Running strangles, iron condors, and directional bets simultaneously without strategy tags makes it impossible to see which approach deserves more capital.

Solution. Use distinct tags per strategy and generate separate equity curves. Allocate more capital to strategies with Sharpe above 1.0; retire or rebuild anything below 0.5 after 30 trades.

Journaling Tips for Indian F&O

• Record spot at entry, not just the strike. Your strike selection strategy is only visible relative to spot.
• Log India VIX and its 90-day percentile. Premium selling is a fair-weather strategy — below the 30th percentile, the economics rarely work after charges.
• Track expiry-day trades in a separate bucket. Gamma dynamics and STT rules differ from positional trades. Mixing them corrupts every metric.
• Record actual lot size per trade. The Nov 2024 lot size revision (Nifty 25 to 75, BankNifty 15 to 35) means any pre-Nov 2024 historical P&L must be normalized before comparison.
• Review on Thursday after 15:30 IST. Weekly expiries demand weekly reviews; monthly cadence is four expiries too late.

Key Metrics to Track

• Win rate by strategy type — distinguish bull put spreads, iron condors, short straddles, directional trades.
• Net P&L as percentage of gross — target 85%+; anything lower means charges are eating your edge.
• STT cost as percentage of gross P&L — flag individual trades where this exceeds 10%.
• Theta captured vs. expected — isolates time-decay harvesting from directional noise.
• P&L by expiry cycle — Nifty weekly vs. BankNifty monthly vs. stock monthly.
• Maximum drawdown per strategy — for honest capital allocation.
• ROI on SPAN + exposure margin — not notional ROI. A 7% return on ₹28k hedged margin is 1.1% on ₹1.8 lakh naked margin.
• India VIX percentile at entry — tests the hypothesis that your premium-selling edge is VIX-regime-dependent.

How JournalPlus Helps

JournalPlus handles the India-specific demands above: Zerodha tradebook CSV imports with automatic mapping of lot sizes, expiry dates, and full charges breakdown; custom cost fields for STT (both 0.0625% and 0.125% variants), SEBI fee, stamp duty, exchange transaction charges, and GST; strategy tagging with separate equity curves per tag; and an India VIX field with percentile-at-entry analysis. The Thursday-aligned weekly review workflow filters by date range, strategy, and instrument so an entire expiry week can be reviewed in under 15 minutes. Multi-currency handling keeps INR as the reporting currency with USD equivalents for global benchmarking.