Why Keep an Options Trading Journal? (Benefits and What to Track)

A useful journal typically separates:

• Underlying stock or ETF positions
• Short and long option legs (including spreads)
• Cash reserved for assignment (collateral)
• Premium in and out, including rolls and fees
• Notes on why you opened, adjusted, or closed

Seven common spreadsheet failures for options sellers:

1. Collateral is tracked manually and drifts from broker requirements
2. Rolls appear as new rows without linking to the original trade
3. Weekly premium totals hide drawdowns on assigned stock
4. Stock and option P&L get mixed, blurring strategy review
5. Expiration clusters are invisible until the Thursday before
6. No standard fields, so each month the format changes
7. Hard to filter by strategy (puts vs. covered calls vs. spreads)

Seven fields worth logging every time:

1. Underlying symbol and strategy tag (e.g. cash-secured put, covered call) — Tags let you filter reviews by bucket. Without them, a great month on puts hides a bleeding covered-call book. One consistent tag per line beats clever folder names in a spreadsheet.
2. Strike, expiration, contracts, and open/close dates — These are the contract identity. They drive DTE, pin risk, and which week owns your attention. Log them at open so rolls do not become mystery rows later.
3. Premium collected or paid (per contract and total) — Premium is cash flow at open, not final profit. Record gross credit, debits on rolls, and fees so you can reconcile to your broker statement without guessing.
4. Collateral or margin reserved at open — The cash or buying power your broker holds against the position. For cash-secured puts, this is strike × 100 × contracts. Tracking collateral separately from premium prevents the most common seller mistake: discovering you have pledged 80% of your account to puts expiring the same week.
5. Assignment status and stock basis if assigned — Assignment changes your book from options to stock. Log date, strike, shares, and adjusted basis (including premiums collected). That is how you know whether a “winning” put month still produced a stock bag you did not want.
6. Roll history (old leg closed, new leg opened) — A roll is two events, not one. Link the closed line to the new line with net credit or debit and the new expiry. Reviews should show whether you reduced risk or only kicked the can.
7. Rule check: was the trade allowed under your written plan? — A yes/no (or short note) against your rules turns the journal into a coach. It is the fastest way to spot drift—oversizing, earnings violations, or trading tickers you banned after the last loss.

Five practical benefits:

1. See total collateral by week—avoid overloading one expiration date — Summing collateral by expiry week shows concentration before assignment Thursday. Premium alone will not warn you that half your account is tied to one Friday.
2. Separate luck from process when premium was high but risk was too — A fat credit on a oversized line is still a process error. Journals that store collateral and rules let you flag “good outcome, bad decision” instead of repeating it.
3. Improve roll decisions with a written before/after on each adjustment — Note delta, DTE, and credit before and after the roll. Over time you see which rolls actually de-risk versus which ones only delay loss.
4. Build strategy-specific stats (win rate on puts vs. calls) — Aggregates by strategy tag reveal where your edge lives. Many sellers discover covered calls underperform their CSP book only after tagged data exists.
5. Reduce emotional trading after you read your own rules in black and white — Pre-written rules remove debate in the moment. The journal proves whether you followed them—especially on revenge trades after a red day.

Questions your journal should answer before the next trade:

• How much cash is already pledged if puts are assigned?
• What percentage of buying power is deployed through month-end?
• Which underlyings are correlated if the market gaps down?
• Did last month's rolls reduce risk or just delay it?

Five steps to launch:

1. Write one-page rules: strategies allowed, max collateral, banned behaviors — Keep it short enough to read in two minutes. Include max percent of account per expiry week and whether earnings trades are allowed. Your future self will not remember verbal rules after a volatile open.
2. Pick fields from the list above—do not add more until month two — Resist custom columns for sentiment, VIX guesses, or macro notes until the core seven are automatic. Consistency beats completeness in the first 30 days.
3. Log the next ten trades the same day they open — Same-day logging preserves accurate collateral and the reason you entered. Waiting until Sunday night is how rolls and partial fills get lost.
4. Weekly: sum collateral by expiration and premium by strategy — Fifteen minutes once a week beats a quarterly deep dive. You are looking for clusters: too many puts in one week, one ticker dominating collateral, or premium concentrated in a single strategy.
5. Monthly: one paragraph—what worked, what broke, one rule to change — Narrative review catches what tables miss: recurring excuses, rule violations you normalized, or a strategy that only works in one volatility regime. Change one rule per month, not ten.

Key takeaways:

• Separate options from stock; tag strategy on every line
• Track collateral, not only premium collected
• Use the same seven fields so monthly reviews are comparable
• Pair journaling with capital discipline on short puts