Options Wheel Strategy Tracker

What Makes This Different

• Annualized return on every trade — not just raw premium. A $150 premium in 7 days = 78% annualized. Same premium in 45 days = 12%. This tracker shows the difference automatically.
• Full wheel cycle P&L — tracks your CSP through assignment into CC, calculating total return across the entire wheel cycle.
• DTE optimization analysis — see which expiration ranges actually generate the highest risk-adjusted returns for your specific trading style.
• Ticker performance breakdown — compare win rates, avg premiums, and total P&L across every underlying you trade.
• Scenario modeling with compounding — project 12-month growth with best/base/worst case inputs so you can plan realistically.
• Tax-ready summary — short-term vs long-term capital gains, auto-calculated from your trade holding periods.

What's Inside (12 Sheets)

• 📊 Dashboard — 8 KPI cards, monthly premium chart, scenario projections, quick navigation to all sheets
• 📋 CSP Tracker — 20 columns with auto-calculated breakeven, ROC, annualized return, DTE countdown, status dropdowns, conditional formatting
• 📋 CC Tracker — 20 columns with cost basis tracking, max profit/loss, annualized return, performance metrics
• 📝 Assignment Log — CSP → CC bridge, full wheel cycle P&L, net cost basis, annualized return on complete cycle
• 💰 Premium Income — Monthly CSP/CC breakdown, cumulative YTD total, monthly target tracking with ✅/❌ indicators
• 📅 Trade Calendar — Color-coded expiry dates, earnings, dividend tracking, reminder system
• ⚙️ Portfolio Settings — 12 configuration parameters (position sizing, DTE preferences, delta targets), 10-stock watchlist with IV rank
• 📊 Analytics — Win rates, avg premiums, best/worst trades, ticker performance analysis, DTE optimization breakdown, Sharpe ratio, profit factor
• 🎯 Scenario Modeling — Conservative/base/aggressive projections, 12-month compounding growth model, breakeven win rate analysis
• 📋 Tax Report — Short-term vs long-term capital gains summary, individual trade log ready for tax filing
• 📖 How to Use — Step-by-step walkthrough of every sheet, every column, every formula
• 📝 Changelog — Complete version history documenting every upgrade

Who It's For

Options traders running the wheel strategy (cash secured puts + covered calls) who want to move beyond manual tracking and actually optimize their strategy with data. Whether you're collecting $500/month or $5,000/month, this workbook scales with your portfolio.

Technical Details

• Compatible with Excel, Google Sheets, LibreOffice
• XLSX format — no special software needed
• 12 integrated sheets with cross-referencing formulas
• 100+ automated calculations — just enter your trade data
• Data validation dropdowns on status, ticker, and trade type fields
• Conditional formatting for visual status tracking (green/yellow/red)
• Auto-filters and frozen panes on every data sheet
• Print-ready formatting with landscape orientation

v2.0 Changelog (April 2026)

• 5 new sheets added: Analytics, Scenario Modeling, Tax Report, How to Use, Changelog
• 3x more automated calculations — every sheet now has comprehensive formula coverage with IFERROR wrappers
• Data validation dropdowns on status, ticker, trade type fields — no more typos
• Conditional formatting — green for won trades, red for losses, yellow for open positions
• Scenario modeling — conservative/base/aggressive projections with 12-month compounding growth
• Ticker performance analysis — compare every underlying by win rate, premium, return, and total P&L
• DTE optimization — see which expiration ranges work best for your strategy
• Tax report — auto-sorted by holding period for easy tax filing
• Professional formatting — dark headers, alternating rows, frozen panes, auto-filters, print-ready

Instant digital download • Works with Excel, Google Sheets & LibreOffice • No subscription needed