Last updated: 21 May 2026 · 9 min read
By Pulkit Mangal — F&O trader since 2017, founder of TradeDiary. Past trading experience across Zerodha, Kotak, and Dhan; built TradeDiary after losing ₹14L in 2021 to mistakes a journal would have caught.
If you trade NIFTY, BANKNIFTY, or stock options on Zerodha, Upstox, Dhan, or any Indian broker — and you've ended the last few months in the red — there's a 91% chance you're not alone. SEBI's January 2024 study on equity F&O traders found that 9 out of 10 individual traders lost money, with average losses of ₹50,000 over FY22. (SEBI study, 25-Jan-2024)
The bitter twist: most of those traders blame their strategy. The data says otherwise. They blame the strategy because they don't have a record of what actually happened on each trade. Without a record, every loss feels random — and you can't fix random.
That's exactly what an options trading journal fixes. This post walks through what one looks like for the Indian F&O market specifically — lot sizes, expiry days, STT, brokerage, the lot — with a template you can copy on Day 1.
💡 Short on time? Try our free F&O journal template — it auto-imports your Kotak / Zerodha contract notes and computes net P&L (after STT + brokerage) per leg.
1. What an options trading journal actually means
A trading journal is a structured log of every trade you place — entry, exit, instrument, quantity, P&L, reason for entering, exit trigger, what you got right, what you got wrong. Nothing exotic.
But in the Indian F&O context, three things make a generic global journal (e.g. Tradervue) feel wrong:
- Multi-leg complexity. A single iron condor on BANKNIFTY is four legs across two strikes. Most global apps treat each leg as a separate trade — so your "win rate" is meaningless because the legs are siblings of one strategy, not independent bets.
- Costs that are non-trivial. STT on the sell side of options is 0.15% of premium (since 1 April 2026); brokerage at ₹20/order plus exchange + SEBI + GST + stamp duty stacks up. A NIFTY straddle that "looks" profitable on screen can be flat after costs. A good journal computes net P&L after all charges, not just gross.
- Expiry-week semantics. NIFTY now expires on Thursdays only (post the 2024–25 SEBI rationalization); BANKNIFTY moved to monthly-only expiry from Nov 2024. Weekly P&L grouped by ISO calendar week is misleading — you want it grouped by expiry cycle of each underlying.
A journal that ignores those three things isn't an Indian options journal — it's an American spreadsheet with rupee signs glued on.
2. Why this matters more for Indian traders
2.1 Tax filing depends on it
If your F&O turnover exceeds ₹10 crore (Section 44AB of the Income Tax Act, amended 2023), you face mandatory tax audit. F&O income is treated as business income — meaning you need a trade-wise ledger to file ITR-3. Most retail traders only discover this in July, panic, and pay a CA ₹15,000 to reconstruct what a journal would have shown automatically. (Income Tax Act, Section 44AB)
2.2 Indian brokers don't compute per-trade net P&L
Zerodha's Console shows realised P&L by trading symbol — not by strategy. So a NIFTY 22500 CE leg of a bull-call-spread shows up next to an unrelated NIFTY 22500 CE swing trade from three weeks earlier. You can't separate them without a journal that captures strategy tags.
2.3 Position sizing in lots, not shares
NIFTY lot = 75 (revised Nov 2024). BANKNIFTY lot = 30. FINNIFTY = 65. A single NIFTY straddle around the at-the-money strike at ₹300 premium per leg is ₹45,000 of premium per leg × 2 legs = ₹90,000 exposed — and a margin requirement closer to ₹2L. A journal in lots (not rupees) helps you compare a NIFTY 1-lot bet to a BANKNIFTY 1-lot bet apples-to-apples.
2.4 SEBI lockdown periods affect strategy
When SEBI tightens margins (e.g. the SPAN + Exposure changes of 2023, the index-expiry cap of 2024), the math of a strategy you've used for a year can flip overnight. A journal lets you re-test old setups against new conditions — invaluable.
2.5 You're trading against algos that journal everything
If you're discretionary, you're competing with prop desks that A/B test every entry signal. Without a journal, you've conceded the game.
3. The framework: a 7-field minimum
Skip the 40-field bloated templates. The fields that actually drive improvement in Indian F&O:
| # | Field | Why it matters |
|---|---|---|
| 1 | Entry date + time | Lets you slice P&L by time-of-day (most Indian retail loses in the first 15 min and the last 30 min) |
| 2 | Underlying (NIFTY / BANKNIFTY / RELIANCE / etc.) | Group by index to spot which one you actually trade well |
| 3 | Strategy tag (e.g. "BNF expiry-day fly", "NIFTY directional CE") | Multi-leg trades roll up under one tag |
| 4 | Net P&L after costs | The only number that matters; gross P&L is a lie |
| 5 | R-multiple (P&L ÷ max planned loss) | Lets you compare a ₹2,000 win on a ₹2,000 risk to a ₹10,000 win on a ₹10,000 risk — same R, equally good |
| 6 | Why you entered (one sentence) | The single highest-impact field. Forces a thesis. Without it you'll re-enter the same losing setup six months later. |
| 7 | What you'd do differently | Filled at exit. Becomes your edge over six months. |
Optional but useful:
- Lots traded (helps spot sizing creep — "I doubled the lots when the trade started winning")
- Days held (expiry-week winners vs swing winners are different beasts)
- Notes / screenshot link
Anything beyond these and you'll abandon the journal in 3 weeks. Friction kills habits.
4. Step-by-step: building yours this week
Step 1 — Pick the medium (Day 1)
Three legitimate options:
| Medium | Pros | Cons |
|---|---|---|
| Google Sheet template | Free, fully customisable | Manual entry; no auto-import; you'll miss costs |
| Indian-built journal app (e.g. TradeDiary's Zerodha journal) | Auto-imports from Zerodha / Kotak XLSX, computes net P&L incl. STT, groups by expiry week, multi-leg aware | Subscription cost |
| Global app (Tradervue, Edgewise) | Mature feature set | Doesn't understand Indian costs, lot sizes, or expiry-day semantics |
Strong recommendation: if you trade ≥ 5 lots/month, the time saved on contract-note reconciliation pays for an Indian-built tool in a week. If you trade < 5 lots/month, the Sheet works fine. Pick one and commit — switching mediums every two months is how journals die.
Step 2 — Backfill 30 days (Day 2–3)
Don't start from scratch. Pull your last 30 days of contract notes from your broker, log them into your chosen medium, and tag each with strategy + why-entered (yes, retroactively — your guess is data). At the end of this exercise you'll spot a pattern that surprises you. Common ones:
- "I do well on NIFTY weeklies but get crushed on BANKNIFTY expiry day" (or vice versa)
- "My CE trades win 60% of the time; PE trades win 30%" → check for directional bias
- "I trade 4× the lots on revenge trades after a loss" → behavioural
Step 3 — Daily 5-minute close (every trading day)
After 3:30 PM, spend 5 minutes:
- Log every trade closed today (or use auto-import).
- Tick the W / L / scratch.
- Write one sentence: "What would I do differently?"
That's it. 5 minutes. Set a phone reminder.
Step 4 — Weekly review (Sunday, 20 min)
Every Sunday:
- Weekly P&L by underlying — does one index drag the others down?
- Weekly P&L by strategy tag — kill any strategy with negative expectancy after 20+ trades.
- Behavioural patterns — read the "why entered" column. How often was it "FOMO" / "boredom" / "felt right"? Those are your leak.
Step 5 — Monthly position-sizing audit (last Sunday)
- Average risk per trade — is it creeping up?
- Worst single loss — was it within your plan or 3× your normal R?
- Recovery factor: total P&L ÷ max drawdown — should trend up over months.
5. Real example with numbers
Trader: Anand (Bengaluru, salaried, 28). Started F&O in Jan 2025 with ₹3L capital. By Jan 2026 he was down to ₹1.7L. Sound familiar?
He started journaling Feb 1, 2026. Three months in, the patterns:
| Slice | Win rate | Net P&L | Insight |
|---|---|---|---|
| NIFTY weeklies (Mon–Thu) | 54% | +₹38,400 | Working |
| BANKNIFTY expiry-day flys | 31% | −₹47,200 | Killed this strategy |
| Stock options (any) | 22% | −₹19,800 | Killed this too |
| NIFTY positional CE (3+ days held) | 71% | +₹52,000 | Doubled allocation here |
Net result over the next quarter: +₹61,300 on ₹1.7L base = +36% in 90 days. The strategies didn't change — they were already in his behaviour. The journal just made the loser-strategies visible enough to remove.
The journal didn't make him a better predictor. It made him a better quitter.
6. Common mistakes that kill a journal
- Logging only the trades you remember. Selection bias — you'll log the wins, "forget" some losses, conclude you're profitable, and blow up again. Fix: auto-import everything, OR commit to logging within 1 hour of exit.
- Vanity metrics. Tracking 28 things (Greeks at entry, IV percentile, RSI, MACD, moon phase). The numbers that change behaviour are P&L, R-multiple, win rate by tag. Track those; everything else is procrastination.
- Tracking gross P&L not net. A 2% strategy edge gets wiped by 1% in round-trip costs in F&O. If you're not computing after STT, brokerage, exchange + GST + stamp, your "edge" is fiction. Use a calculator like our R-multiple calculator or any tool that ingests Indian charges.
- Skipping the "why entered" field. This is where 90% of the value lives. If a "good entry" reason is "Bollinger touch + EMA-20" you can test it. If it's "felt right" — that's the data.
- Quitting after a bad week. A journal during a winning streak is dopamine. A journal during a losing streak is the whole point. Quitting in week 3 because the data is uncomfortable means you forfeit months 4–12.
- Not separating trader from strategy. Backtest says iron condors are +EV in low-VIX regimes. You implement → −₹15K in two weeks. Was the strategy wrong, or were you wrong on the strategy (wrong strikes, late entry, panic exit)? Without a journal, you can't tell. With one, you can.
7. How TradeDiary helps
Most of this you can do in a Sheet — and if you're disciplined enough to do that, you don't need a tool. For everyone else:
TradeDiary is built for Indian F&O traders specifically. It auto-imports your Zerodha contract notes and Kotak F&O XLSX, computes net P&L per leg after STT + brokerage, groups your weekly performance by each index's native expiry cycle (NIFTY Thu, BANKNIFTY monthly, FINNIFTY Tue), and surfaces your behavioural leak via an AI assistant that reads your "why entered" notes. The free tier covers 50 trades/month — enough to journal your first month and see the patterns.
→ Start your free F&O journal — no card needed.
You may also like: the Zerodha trade journal guide, why an AI trading journal beats a spreadsheet, or our full guide to picking a trading journal app in India, or R-multiple trading explained to measure your edge in units of risk, or how to track your options Greeks, or which of your options strategies actually makes money, or how to journal an iron condor across all four legs, or what your F&O tax journal must record. For the complete picture, start with the trading journal India guide. For the complete F&O picture, read the options trading guide for India.
Frequently asked questions
Is keeping an options trading journal mandatory in India?
Not by law for retail traders. But if your F&O turnover exceeds ₹10 crore in a financial year (Section 44AB), you face mandatory tax audit and you'll need trade-wise records to file ITR-3 as business income. Even below that threshold, retaining contract notes is required for 7 years by SEBI rules. A journal is the cleanest way to satisfy both.
Can I use Excel as an options trading journal?
Yes — for the first 1–2 months and under 50 trades a month, a Google Sheet works well. After that the manual entry burden compounds. The break-even point for moving to a dedicated tool is roughly 20 trades per week or any multi-leg trading (iron condors, calendars) where the leg-level computation gets painful.
What's the difference between an options trading journal and an options strategy backtester?
A backtester runs a hypothesis on historical data — what if I had sold straddles every Thursday for three years? A journal records what you actually did in real markets, including the human-factor variance (sizing, entry timing, emotional exits). Both are useful; the journal is the more important one for individual traders because it captures your edge or leak, which is not in any backtest.
Does Zerodha provide a built-in options trading journal?
Zerodha's Console provides trade history and tax P&L reports, but not a strategy-tagged journal with notes, R-multiples, or behavioural fields. It's a record of what happened, not a tool for learning from it. Most active traders pair Console with a dedicated journal — see our Zerodha journal page for the integration.
How long until journaling actually improves my P&L?
Two patterns from talking to about 500 Indian F&O traders who journal: first, the initial visible improvement is usually behavioural — fewer revenge trades, smaller position-sizing creep — and shows up in two to four weeks. Second, strategy-level improvements (killing negative-expectancy strategies, doubling positive ones) need a 20 to 30 trade sample per strategy tag, which is typically six to ten weeks for a part-time trader. Don't expect overnight; do expect noticeable change by month two.
Risk disclaimer
This article is for educational purposes only and does not constitute investment advice. Trading in equity and derivatives in India carries substantial risk of loss. Past performance is not indicative of future results. As per SEBI's January 2024 study, 9 out of 10 individual F&O traders incurred net losses over FY22. Trade only with capital you can afford to lose, and consult a SEBI-registered investment advisor for personal recommendations.
Author: Pulkit Mangal — Founder, TradeDiary. F&O trader since 2017. Built TradeDiary after personal losses of ₹14L in FY21 highlighted the absence of a market-aware journaling tool for Indian retail.
Last updated: 21 May 2026.