How to Track the Options Wheel Strategy (Cost Basis, Premiums, Returns)
Updated October 12, 2026 · Educational content, not financial advice.
The options "wheel" is a cycle many self-directed investors use: sell a cash-secured put, possibly get assigned shares, then sell covered calls against those shares until they are called away, and start again. The mechanics are simple. Keeping accurate records is not. After a few months you may have dozens of puts, a handful of assignments, rolled calls and partial fills, and your brokerage screen will happily show you a cost basis that ignores most of the premium you collected.
This guide explains what to record, how to calculate the numbers that actually matter — net premium, adjusted cost basis, annualized return and win rate — and the mistakes that make wheel records misleading. It does not tell you what to trade; it is about measuring what you already did.
1. Understand the three phases you are tracking
Every wheel cycle on a ticker moves through up to three phases, and your log should make it obvious which phase you are in:
- Cash-secured put (CSP) phase. You sell a put and set aside cash equal to strike × 100 × contracts. Outcomes: the put expires worthless, you buy it back (close), or you are assigned shares.
- Stock phase. If assigned, you now own 100 shares per contract at the strike price. This is where the real risk sits: the shares can keep falling.
- Covered call (CC) phase. You sell calls against the shares. Outcomes: expire, close, or the shares are called away at the call strike, ending the cycle.
A tracker that treats each option as an isolated row without tying assignments back to shares will overstate or understate your results. The fix is to give every row a status and to compute share movements from those statuses.
2. The minimum fields to log for every trade
Log one row per option you sell (or one row per fill if you scale in at different prices). At minimum:
| Field | Why it matters |
|---|---|
| Open date | Start of the holding period for annualized return. |
| Ticker | Groups trades into a per-ticker cycle. |
| Type (CSP / CC) | Determines whether assignment adds or removes shares. |
| Strike | Drives collateral, assignment cost and call-away proceeds. |
| Expiry | End of the holding period if the option runs to expiration. |
| Premium per share | What you received (e.g., 1.25 = $125 per contract). |
| Contracts | Multiplier; one standard contract usually covers 100 shares. |
| Fees | Commissions and regulatory fees reduce every result. |
| Status | Open, Expired, Assigned, Called Away or Closed. |
| Close price & close date | Needed when you buy back early; the close date shortens the holding period. |
Everything else should be calculated from these fields. If you find yourself typing a result by hand, that is a number that will eventually be wrong.
3. Calculate net premium correctly
Gross premium is what headlines quote. Net premium is what you keep:
Net premium = (premium − close price) × 100 × contracts − fees
If an option expired or was assigned, the close price is zero. If you bought it back, subtract the buyback price. A hypothetical example: you sell 2 puts at $0.85 and buy them back at $0.20 with $1.30 in total fees. Net premium is (0.85 − 0.20) × 100 × 2 − 1.30 = $128.70. If you buy back for more than you received, net premium is negative — record it honestly; a loss on a buyback is still part of the cycle.
4. Adjusted cost basis: the number your broker doesn't show
When a put is assigned, your broker typically records the shares at the strike price (some brokers fold that specific put's premium in; many investors track it separately). For wheel tracking, the more useful figure is the premium-adjusted cost basis:
Adjusted cost basis = assignment cost − all net premiums collected on that ticker
"All premiums" includes the puts that expired before assignment, the put that got assigned, and every covered call sold afterward. Hypothetical example: you collect $209 on a put that expires, then $239 on a second put that is assigned at $180 (assignment cost $18,000), then $179 on a covered call that expires. Total net premium is about $628, so the adjusted basis is roughly $17,372, or about $173.72 per share.
Why it matters: the adjusted basis tells you the price at which the whole cycle, not just the stock, breaks even. It helps you see whether a covered-call strike below your raw purchase price would actually lock in a loss for the cycle. It is a management figure, though, not your tax basis — tax treatment of option premiums follows specific rules, so rely on your Form 1099-B and a tax professional.
5. Annualized return per trade
A $200 premium on $18,000 of collateral over 25 days is a very different trade from $200 over 90 days. To compare them, annualize:
Annualized return = net premium ÷ collateral × 365 ÷ days held
Collateral for a CSP is strike × 100 × contracts. For covered calls, using the strike as the collateral figure keeps the math consistent (some traders use the share cost instead; pick one method and stick with it). Days held runs from the open date to the close date, or to expiry if the option ran its course; use a minimum of one day to avoid dividing by zero.
Be careful how you read annualized numbers. They describe one trade scaled to a year; they are not a forecast. Short trades can produce eye-catching annualized figures from small dollar amounts, and a single assignment followed by a falling stock can erase many months of premium. Always look at annualized return alongside dollar P/L and total capital at risk.
6. Win rate — and why it can mislead
Win rate is the share of finished trades with positive net premium:
Win rate = finished trades with net premium > 0 ÷ all finished trades
Exclude open trades. Note the trap: in the wheel, an assigned put still counts as a "win" on premium even if the shares are now worth much less. A high win rate with a large unrealized stock loss is common. That is why your tracker should report stock P/L and shares held separately from option premium, rather than rolling everything into one flattering percentage.
7. Realized vs. unrealized results
Keep three buckets distinct:
- Realized premium — net premium on trades that are expired, assigned, called away or closed.
- Unrealized premium — premium on open options. You received the cash, but you may still have to buy the option back.
- Stock P/L — when shares are called away, proceeds (call strike × 100 × contracts) minus the cost of those shares. Unrealized stock gains or losses on shares you still hold belong outside your "income" figures entirely.
8. Monthly income tracking
Summing net premium by month answers a common question: how steady is the cash flow? Assign each trade to the month it finished (close date, or expiry if it ran to expiration). Expect lumpy months — a buyback at a loss or a slow month with fewer trades is normal. A month-by-month table also makes it easy to spot whether fees are eating a meaningful share of your premium.
9. Common tracking mistakes
- Ignoring fees. Per-contract fees look small but add up across many trades.
- Forgetting rolls. A roll is two trades: buying back the old option (record as Closed with a close price) and selling a new one (a new row).
- Counting assignment as the end. Assignment starts the stock phase; the cycle isn't over until the shares are sold or called away.
- Mixing tickers. Keep ticker spelling consistent (e.g., always "KO", never "Coke") so per-ticker formulas match.
- Treating adjusted basis as tax basis. They are different; your broker's tax forms govern reporting.
- Hard-coding results. Typed-in totals drift from reality. Use formulas.
10. Putting it together in a spreadsheet
A practical setup has four parts: a trade log with the fields above and calculated columns for net premium, collateral, days held and annualized return; a positions view that uses SUMIFS on ticker and status to compute shares held, assignment cost, premiums and adjusted basis; a dashboard with totals, win rate and a monthly table; and a settings area for things like the report year and shares per contract. Data-validation dropdowns for type and status prevent the typos that silently break formulas.
You can build this yourself with the formulas in this guide. If you'd rather start from a ready-made, tested template, the Theta Wheel Book Options Tracker implements exactly this structure for Excel and Google Sheets, with example rows you delete before entering your own trades.
Rolling a put? The bookkeeping has its own traps. See How to Roll a Cash-Secured Put for net-credit math and a worked example.
Key takeaways
- Log every option sale with status, fees and close details; calculate everything else.
- Adjusted cost basis = assignment cost minus all net premiums on the ticker.
- Annualize to compare trades, but never read annualized return as a prediction.
- Report stock P/L separately so a high win rate doesn't hide losses on shares.
This article is for general education only and is not investment, tax or legal advice. All examples are hypothetical. Options trading involves substantial risk and is not suitable for every investor.