You cannot improve what you do not measure. Most wheel traders track their trades poorly — or not at all. A simple spreadsheet changes everything.

What to Track: The Essential Fields

Every wheel trade should record these data points:

For Put Selling Phase

| Field | Example | Why Track It | Date opened2025-11-15Track timing patterns UnderlyingAAPLKnow which stocks perform best Strike price$190Calculate cost basis if assigned Expiration2025-12-20Track DTE preferences Premium received$3.20 ($320)Income tracking Delta at entry0.22Refine delta selection over time IV rank at entry42Correlate IV with outcomes OutcomeExpired / AssignedWin rate calculation Date closed2025-12-20Duration tracking

For Covered Call Phase (if assigned)

FieldExampleWhy Track It Assignment date2025-12-20Track holding periods Cost basis$186.80Net of premium received Call strike$195Calculate max profit Call premium$2.50 ($250)Additional income Dividends received$0.25 ($25)Total income calculation OutcomeCalled away / RolledTrack call effectiveness | Final P/L | $1,070 | Bottom line per trade |

Key Metrics to Calculate

Beyond individual trade tracking, calculate these portfolio-level metrics monthly:

Win Rate: Percentage of put cycles that expired worthless or were closed for profit. Target: 70%+.

Average Premium Yield: Total premium collected divided by average capital deployed. This is your return on capital.

Assignment Rate: How often your puts get assigned. Compare this to your target delta — if you sell 0.25 delta puts but get assigned 40% of the time, something is off.

Time in Stock: What percentage of the time is your capital tied up in shares versus collecting put premium? Lower is generally better for the wheel.

Recovery Time: When assigned in a losing position, how many covered call cycles does it take to break even? Track this per stock.

Building the Spreadsheet

Tab 1: Trade Log

One row per transaction. Every put sold, every call sold, every assignment, every expiration. This is your raw data.

Tab 2: Position Summary

Group trades by stock. Show total premium collected, total P/L, number of cycles, and return on capital for each underlying. This tells you which stocks are actually making you money.

Tab 3: Monthly Dashboard

Aggregate monthly income, expenses (buy-backs), and net P/L. Include a running total of account value. Chart this over time.

Tab 4: Metrics

Calculate win rate, assignment rate, average premium yield, and Sharpe ratio. Update monthly.

Why Most Traders Stop Tracking

Maintaining a spreadsheet is tedious. After a few months, most traders stop updating it. This is why tools like OptionsPilot exist — they automatically track your wheel positions and calculate these metrics for you.

If you prefer spreadsheets, set a weekly 10-minute session every Sunday to update your log. Do not let it pile up.

What the Data Will Tell You

After 6-12 months of consistent tracking, patterns emerge:

  • Which stocks consistently generate the best premium relative to risk
  • Whether your delta selection is appropriate
  • How market conditions affect your returns
  • Your true annualized return, accounting for all costs and holding periods

    • This information is what turns a casual wheel trader into a systematic one. The spreadsheet might be boring, but the edge it creates is real.