A Trading Journal for Option Sellers: The 12 Columns That Explain Your Losses

Most trading journal advice was written for people who buy things. Log the ticker, the entry, the exit, how you felt. Rate your discipline out of 10. That works fine if you buy a stock and sell it later. It falls apart the moment you sell a NIFTY strangle at 9:20 a.m. IST, adjust one leg at 11:40, get stopped on the other at 1:15, and close the rest at 3:15. Which trade was that? One, two or four?

Here's the short version of this article. An option seller's journal has to record the structure, the clock, the premium, the volatility, the stop rule you wrote down before entry, the reason each leg actually closed, and the slippage on every fill. Those are the places where short-premium losses hide. A generic journal skips most of them, so it can tell you that you lost money but not why.

EliteAlgo is a Delhi proprietary desk that has traded since 2006. Our team sells NIFTY and SENSEX options on expiry days and through the weekly cycle, and every rule we run goes through our own backtest engine first. The journal layout below is close to what we log per trade, simplified for a single trader working in a spreadsheet. You'll get the 12 columns, how to handle multi-leg trades without a mess, a ten-minute weekly review, and the point where a pattern in your journal is strong enough to turn into a rule.

Paper trade this first. Any time, threshold or strike in this article is an example of how to record and review trades, not a trade instruction. Run any rule you build from your journal on paper across several expiries before it touches live capital. This is EliteAlgo's analytical research, not investment advice.

Why a generic trading journal misses what matters for short options

A buyer's loss is usually easy to explain. You bought, price went the other way, you sold lower. The journal entry writes itself.

A seller's loss has more moving parts. The premium you collected depends on implied volatility at the minute you sold. The risk depends on how far your strikes sat from spot and how many days were left to expiry. The size of the loss depends on whether your stop fired where you planned, or 18 points later because the market gapped through it. And on a hedged structure, one leg can lose while another makes money, so the net figure hides which part of the trade did the damage.

That's why the stakes are high. According to SEBI's September 2024 study on equity derivatives, 93% of individual F&O traders lost money across FY22 to FY24. You can find SEBI's studies on its research reports page. A journal won't change those odds on its own. What it can do is stop you repeating the same loss for 2 years without noticing.

Look at what the top-ranking journal pages cover today. Tradervue's template and ActivTrades' guide both list sensible basics: date, instrument, direction, entry, exit, size, P&L, notes. Binance Academy adds emotions and strategy tags. None of them have a column for implied volatility at entry, days to expiry, strike distance or exit reason per leg. For an option seller, those are the columns that do the explaining.

There's one more gap. Most journal advice treats every trade as a fresh decision. A systematic seller runs the same setup again and again: same structure, similar time, similar distance. Your journal should be built to compare like with like, so that after 40 trades of one setup you can see whether it pays. Free-text notes can't do that. Fixed columns can.

The 12 columns, and why each one is there

Each column below earns its place by answering a question you'll ask during a review. If a column never changes a decision, cut it. We've cut plenty over the years.

1. Date, expiry and days to expiry (DTE)

Write the trade date, the expiry date of the contracts, and the number of trading days between them. A short strangle with 0 days to expiry and the same strangle with 4 days left are different trades. Gamma risk (how fast your delta changes as spot moves) is far higher on expiry day. If you mix them in one bucket, your averages lie to you.

2. Structure

Use a short, fixed list: short straddle, short strangle, iron condor, credit spread (call or put), naked single leg, ratio. Don't invent a new label for each trade. The whole point is to filter by structure later and see which ones carry your P&L and which ones drag on it.

3. Entry time (IST)

Record it to the minute. Short-premium results often depend heavily on the clock. A strangle sold at 9:20 a.m. faces the whole day's range. The same strangle sold at 1:30 p.m. on expiry day collects less premium but faces fewer hours of movement and faster time decay. When we compared entry times on our own expiry-day setups, the time of entry mattered more than most traders expect. Your journal should let you test that on your own trades.

4. Spot at entry and strike distance

Write the index level when you sold and the strikes, then compute the distance in points. For example, spot 24,180 with a 24,400 call and a 23,950 put gives distances of 220 and 230 points. Distance is the column that tells you whether you were selling too close for the day's volatility. Raw strike numbers alone won't, because 24,400 means something different when spot is at 24,350.

5. Premium collected per leg

Write the fill price of each leg, not the combined figure. If the call filled at 42.5 and the put at 38.0, write both. Combined premium is useful for the P&L, but per-leg figures show skew: on many days one side pays noticeably more than the other at the same distance. Over 3 months you'll see whether you're being paid fairly for the side that keeps hurting you.

6. IV at entry and India VIX

Implied volatility is the market's price for expected movement. The SEC's investor site has a plain definition of implied volatility if you want the formal version. Write the at-the-money IV of the expiry you're trading, plus India VIX, both at entry. Then you can ask a sharp question in review: do my losses cluster on low-IV days, when I collected too little premium for the risk, or on high-IV days, when the market moved more than usual?

7. Stop rule, as planned

Write the stop before you place the trade, in the same words every time: "each leg SL at 2x entry premium", or "combined SL at 1.5x total premium", or "spot-based exit if NIFTY crosses 24,350". This column is boring on purpose. It's what you compare the actual exit against. If your planned stop and your actual exit don't match, you've found a discipline problem, and the journal just proved it with a number.

8. Exit time and exit reason, per leg

This is the single most useful column for finding losses. Give every leg one exit reason from a fixed list:

• SL — stop fired as planned
• TGT — target hit
• TIME — closed at your planned time exit, such as 3:15 p.m.
• ADJ — closed as part of an adjustment
• MAN — manual exit outside the plan
• EXP — held to expiry

Sort a quarter of trades by exit reason and total the points. In our experience most surprises show up here. The MAN row is often where the damage sits, because manual exits tend to come at the worst moment: closing a winner early out of nerves, or holding a loser past its stop hoping it comes back. Some traders find the opposite, that their planned stops are too tight and the TIME exits carry all the profit. Either way, you won't know until you count.

9. Slippage per leg

Slippage is the gap between the price you expected and the price you got. Investor.gov's slippage entry explains the general idea. For an option seller it matters most on stop-loss exits. Your SL trigger was 85, but in a fast market the order filled at 97. That's 12 points of slippage on one leg. Record trigger price and fill price, then compute the difference.

Stop-loss market orders and stop-limit orders behave differently here. A market order fills but at an unknown price. A limit order controls price but might not fill at all. The SEC's page on stop-loss orders covers the trade-off. Your slippage column will show you which problem you actually have.

10. Charges

Brokerage, STT, exchange transaction charges, SEBI fees, stamp duty and GST. Don't type rates from memory or from a blog; they change. Copy the actual total from your contract note or your broker's P&L report. Zerodha, for instance, explains its reports in the Console reports section of its support site, and other brokers have similar pages. Charges look small per trade. Over 200 trades a year on a four-leg structure, they're a line you need to see.

11. Worst open loss (MAE)

MAE stands for maximum adverse excursion: the worst mark-to-market loss the trade showed while it was open. A trade that closed at +15 points but sat at −60 points at 11:05 a.m. was a near miss, not a clean win. Many sellers only see the closing figure and think their setup is calm. MAE tells you how close you came to your stop, and how much capital the trade really needed. You can read the intraday low of the combined premium off your broker's chart, or get it from your algo logs if you run one.

12. Rule followed? (Y/N plus one line)

A simple yes or no: did this trade follow every rule you wrote down? If no, one line on what broke. "Entered at 10:40 instead of 9:20, chasing a move." "Skipped the stop, moved it 20 points." This column splits your results into two groups, rules followed and rules broken. That split is often the most humbling number a trader ever sees.

From these 12, compute two output columns: gross P&L in points and net P&L in ₹ (points × quantity, minus charges). Use the lot size in force on the exchange circular for your quantity. Don't hard-code it into the sheet; NSE has changed index lot sizes several times, and a stale number will quietly break every rupee figure.

Here's what two filled rows look like. Both are made-up examples, labelled as such, to show the shape.

Column	Row A (example)	Row B (example)
Date / expiry / DTE	Example: expiry day, DTE 0	Example: DTE 3
Structure	Short strangle	Iron condor
Entry time	09:20	13:30
Spot / distance	24,180 / CE +220, PE −230	24,050 / CE +300, PE −300
Premium per leg	CE 42.5, PE 38.0	CE 61.0 (buy 18.0), PE 58.5 (buy 16.5)
ATM IV / VIX	11.8% / 13.2	14.6% / 15.9
Stop rule	Each leg 2x premium	Combined 1.5x net credit
Exit / reason	CE 13:15 SL; PE 15:15 TIME	All legs 15:15 TIME
Slippage	CE trigger 85.0, fill 97.0 (12 pts)	0.5 pts average
Charges	From contract note	From contract note
MAE	−58 pts at 13:10	−21 pts at 10:45
Rule followed?	Y	N — sold 2 hours late

Notice what Row A tells you even without the P&L. The call leg's stop fired with 12 points of slippage, which is about 28% of the premium collected on that leg. One trade proves nothing. Thirty trades with the same pattern would say your stops need a different order type or a different trigger.

Logging multi-leg trades without making a mess

This is where most spreadsheet journals break. People try to cram a four-leg iron condor into one row and end up with columns called "Leg 3 exit price (if adjusted)". Six weeks later nobody can read it.

Use two levels instead.

A position ID. Every structure gets one ID, for example 2026-11-13-N-01. That's date, underlying (N for NIFTY, S for SENSEX) and a sequence number.

One row per leg. Each leg gets its own row carrying the shared position ID. Strike, side (sell or buy), fill price, exit time, exit reason and slippage live on the leg row. Structure, entry time, IV, VIX, stop rule and the rule-followed flag live once per position. In a spreadsheet you can repeat them on each leg or keep them on a separate tab joined by the ID.

With this layout, a pivot table on the position ID gives you net P&L per structure, and a filter on exit reason gives you the leg-level story. A short strangle where the call got stopped and the put expired worthless shows up as two rows: one SL, one EXP. You can then ask which side gets stopped more often, which is a question a single-row journal can't answer.

Adjustments get their own rows too. If you roll the put from 23,950 to 24,050 at 12:10, close the old leg with reason ADJ and open a new leg row under the same position ID. Don't overwrite the original strike. The roll itself is a decision you'll want to judge later: did rolling help, or did it just double your exposure into a trending day?

One small habit saves hours. Put the position ID into the order tag or remarks field if your broker or algo platform allows it. Then your tradebook export matches your journal without any guesswork.

The weekly review: three questions, ten minutes

A journal you never read is just typing practice. We'd rather you review for 10 minutes every week than for 3 hours once a quarter. Pick a fixed slot, say Saturday morning, and answer only these three.

Question 1: Which exit reason cost the most points this week?

Filter by exit reason and total the points. If SL exits dominate the losses, look at whether stops sat too close for the IV you sold at. If MAN exits dominate, you have a discipline issue, not a strategy issue. If TIME exits are losing money, your setup may be giving back gains late in the session.

Question 2: How did rule-followed trades do against rule-broken trades?

Split the week by column 12. Two totals, side by side. Do this every week for 3 months and you'll have the clearest picture you can get of what your discipline is worth in points. It's often the cheapest edge available: stop doing the trades you already promised yourself not to do.

Question 3: What share of gross premium went to slippage and charges?

Add up slippage points and charges, then divide by gross premium collected. If that share keeps creeping up, the strategy might still work on paper but not after friction. Thin-premium setups, like far out-of-the-money strangles on expiry afternoons, are the usual suspects. The fix might be fewer legs, better order types or simply wider spacing between trades.

Write one sentence at the bottom of the week: the single change you'll test next week. One. Not five.

From journal to rule: when a pattern is real enough to code

Sooner or later your journal will show you something that looks like an edge. Maybe strangles sold after 1:30 p.m. on expiry day stop out less often than the 9:20 a.m. version. Maybe trades taken when VIX is below 12 lose more often. The temptation is to make it a rule on the spot. Wait.

Here's the methodology we use before a journal pattern becomes a rule on our desk. You can copy it with a spreadsheet and some patience.

1. Sample size first. Don't judge a setup on fewer than about 30 trades of the same structure and time window. Ten trades can look brilliant or awful purely by chance.
2. Check it across regimes. Split the sample into calmer and more volatile periods, using VIX or ATM IV from column 6. A pattern that only works in one regime is a regime bet, not a rule.
3. Backtest it on data you didn't journal. Your journal only holds trades you happened to take. A backtest across 2 or 3 years of historical data tests the rule on days you skipped too. Our guide on how to backtest an option-selling strategy walks through that step.
4. Include friction. Use the slippage and charges you actually recorded in columns 9 and 10, not zero. A rule that only pays at zero slippage doesn't pay.
5. Paper trade it. Run the rule forward on paper for several weeks before it touches capital. Our piece on paper trading an option-selling algo covers what to watch during that phase.

Size deserves its own line. A journal often reveals that the losing weeks weren't caused by bad entries but by oversized positions on the wrong day. If that's your pattern, read our breakdown of position sizing versus technique before touching your entry rules.

Once a rule survives all five steps, it's precise enough for a machine to execute. That's the natural endpoint of a good journal: fewer judgement calls during market hours, more decisions made calmly on a Saturday. It's also where many traders hand execution to a system. If you'd rather a desk with its own engine run tested rules for you, our managed algo trading service page explains how that works and what it doesn't promise.

Spreadsheet, app or algo log: what to use

There's no single right tool. Each has a real trade-off.

A spreadsheet is free, flexible and fully yours. Google Sheets or Excel handles every column above, pivot tables included. The downside is manual entry. Logging a four-leg trade by hand takes 3 to 5 minutes, and that's exactly the step people skip on a bad day, which is the day that most needs recording.

A journal app imports trades from your broker and builds charts automatically. That saves time. Most apps were designed for stock and futures traders, though. Check whether the one you're considering understands multi-leg option positions, records IV and DTE, and lets you add custom fields like exit reason and rule-followed. If it can't group legs into a structure, you'll end up with a pretty dashboard that answers the wrong questions.

An algo log is what you get once execution runs through code. Every order, fill, trigger price and timestamp gets written automatically, so slippage and exit reason come for free and nothing gets skipped. That's the big win. The catch is that a log records what the system did, not why a human overrode it. Keep column 12 even then. Manual overrides are where a system's results quietly drift away from its backtest. We wrote about this and other drawbacks in our honest look at the disadvantages of algo trading.

Our suggestion for a single trader: start with a spreadsheet laid out exactly as above for 8 weeks. You'll learn which columns you actually use. Then move to an app or a log if the manual work becomes the bottleneck. The columns matter far more than the tool.

Frequently Asked Questions

For a neutral primer on how listed options and their risks work, the Options Industry Council's options education site is a good reference. For current lot sizes, contract specifications and charges, use the exchange circulars and your broker's own pages rather than any blog, this one included.