Options Wheel Strategy Excel: Automate the Cash-Secured Put to Covered Call Cycle

Options Wheel Strategy Excel is the combination that turns a popular options income strategy into a repeatable, trackable system. The wheel strategy — cycling between selling cash-secured puts and covered calls — is one of the most reliable ways to generate consistent premium income from the options market. But running it manually, tracking cost basis in your head, and eyeballing option chains for the next trade is a recipe for mistakes. Excel changes that. With the right formulas and structure, you can screen stocks, evaluate premiums, track every position, and calculate your true return on capital — all in one workbook.

This guide walks through every aspect of the options wheel strategy: how it works mechanically, the math behind each phase, how to select the right stocks, and exactly how to build a wheel strategy tracker in Excel using real-time data. Whether you are running one wheel or managing five simultaneously, this is the framework that keeps everything organized.

What Is the Options Wheel Strategy?

The wheel strategy is a three-phase options income cycle. You sell options premium repeatedly on stocks you are willing to own, rotating between puts and calls depending on whether you hold shares. Each phase feeds into the next, creating a continuous loop — hence the name "wheel."

Phase 1: Sell a Cash-Secured Put

You start by selling an out-of-the-money put option on a stock you would be happy owning at a lower price. "Cash-secured" means you have enough cash in your account to buy 100 shares at the strike price if the option is exercised.

When you sell the put, you collect premium upfront. Two outcomes are possible:

• Stock stays above the strike at expiration. The put expires worthless. You keep the entire premium as profit and sell another put to start the cycle again.
• Stock drops below the strike at expiration. You are assigned 100 shares at the strike price. But your effective cost basis is lower than the strike because you already collected the put premium. Move to Phase 2.

This is the entry point of the wheel. You are getting paid to wait for a stock to come to you at a price you already wanted. For a deeper look at put selling mechanics, see our guide on put credit spreads.

Phase 2: Own the Stock at a Reduced Cost Basis

If you are assigned on the cash-secured put, you now own 100 shares. Your cost basis is not the strike price — it is the strike price minus the premium you collected from selling the put. This built-in discount is one of the key advantages of the wheel.

For example, if you sold a $220 put and collected $4.50 in premium, your effective cost basis on the shares is $215.50 per share — not $220. You bought the stock at a 2% discount before even selling your first covered call.

Now you move to Phase 3.

Phase 3: Sell a Covered Call

With 100 shares in hand, you sell an out-of-the-money covered call — typically above your cost basis so that if the shares are called away, you lock in a profit on the stock itself, plus you keep the call premium.

Again, two outcomes:

• Stock stays below the call strike at expiration. The call expires worthless. You keep the premium and sell another covered call. Repeat until the stock is eventually called away.
• Stock rises above the call strike at expiration. Your shares are called away (sold) at the strike price. You collect the call premium plus any capital gain between your cost basis and the call strike. You now have cash again — go back to Phase 1 and sell another put.

For detailed covered call mechanics, check out our covered call strategy explained guide and the covered call calculator.

The Wheel Cycle Visualized

┌─────────────────────────────────────┐
│                                     │
│   PHASE 1: Sell Cash-Secured Put    │
│   Collect premium. Wait.            │
│                                     │
│   Not assigned? ──→ Repeat Phase 1  │
│   Assigned? ──→ Go to Phase 2       │
│                                     │
├─────────────────────────────────────┤
│                                     │
│   PHASE 2: Own Shares               │
│   Cost basis = Strike - Put Premium │
│                                     │
│   Move to Phase 3 ──→              │
│                                     │
├─────────────────────────────────────┤
│                                     │
│   PHASE 3: Sell Covered Call        │
│   Collect more premium.             │
│                                     │
│   Not called? ──→ Repeat Phase 3   │
│   Called away? ──→ Back to Phase 1  │
│                                     │
└─────────────────────────────────────┘

The beauty of the wheel is that you are always collecting premium. In Phase 1, you earn premium from puts. In Phase 3, you earn premium from calls. The only phase where you are not actively selling premium is the brief transition in Phase 2 — and even that can happen on the same day you get assigned.

Why the Wheel Strategy Works

The wheel is not a get-rich-quick strategy. It is a grind — a steady, repeatable process that compounds small wins over time. Here is why it appeals to income-focused traders:

Consistent Premium Income

Every cycle of the wheel generates premium. Whether the put expires worthless or you get assigned and start selling calls, money flows in. In sideways markets where stock prices chop around without trending strongly, the wheel thrives because options premium is collected regardless of direction.

Built-In Cost Basis Reduction

Each premium you collect reduces your effective cost basis on the stock. After several rounds of puts and calls, your break-even price can be significantly below where the stock is trading. This gives you a cushion against downside moves.

You Only Buy Stocks You Want to Own

The wheel forces discipline. You should only sell puts on stocks you would be comfortable holding for months or even years. This eliminates the temptation to chase high premiums on speculative names you would never want in your portfolio.

Works in Sideways and Slightly Bullish Markets

The wheel does not need the stock to go up dramatically. Flat or slowly rising prices are ideal — the stock stays in a range, puts expire worthless, and when you do get assigned, you sell calls at slightly higher strikes. Mild bullishness is the sweet spot.

Defined Risk at Every Stage

Unlike naked options strategies, the wheel always has defined risk. When selling a cash-secured put, your maximum risk is owning the stock at the strike price (which you already wanted). When selling a covered call, your maximum "risk" is having your shares called away at a profit. There are no margin blowups here.

Wheel Strategy Math: The Key Calculations

Understanding the numbers behind each phase is critical. Here are the formulas you need:

Cash Required for a Cash-Secured Put

To sell one cash-secured put, you need enough cash to buy 100 shares at the strike price:

Cash Required = Strike Price × 100

If you sell an AAPL $220 put, you need $22,000 in cash (or buying power, depending on your broker).

Cost Basis After Assignment

If you are assigned on the put, your effective purchase price is reduced by the premium you collected:

Cost Basis = Strike Price - Put Premium Received

Sold the $220 put for $4.50? Your cost basis is $215.50 per share.

Covered Call Adjusted Cost Basis

Each covered call you sell further reduces your cost basis:

Adjusted Cost Basis = Previous Cost Basis - Call Premium Received

If you then sell a covered call for $3.00, your adjusted cost basis drops to $212.50 per share.

Total Return on a Complete Wheel Cycle

When your shares are eventually called away, your total return includes every premium collected plus any capital gain:

Total Return = Put Premium + Call Premium(s) + (Call Strike - Put Strike) × 100

If you received $4.50 from the put, $3.00 from one covered call, and your shares were called away at $230 (versus your $220 put strike):

Total Return = ($4.50 + $3.00) × 100 + ($230 - $220) × 100
             = $750 + $1,000
             = $1,750

On $22,000 of capital deployed, that is a 7.95% return for one complete cycle.

Annualized Yield

To compare wheel returns across different time periods, annualize them:

Annualized Yield = (Total Return / Capital Deployed) × (365 / Days in Cycle) × 100

If the cycle above took 60 days:

Annualized Yield = ($1,750 / $22,000) × (365 / 60) × 100 = 48.4%

This is a theoretical maximum — real-world results depend on how often you are assigned, how long each phase takes, and market conditions. But it illustrates why the wheel is attractive for income traders.

Selecting the Right Stocks for the Wheel

Stock selection makes or breaks the wheel strategy. The wrong stock turns a steady income machine into a value trap that bleeds your account. Here is what to look for:

Stocks You Would Be Happy Owning Long-Term

This is the most important rule. If you would not want to hold the stock for 6-12 months regardless of the wheel, do not sell puts on it. The wheel works because you are indifferent to assignment — you actually want to own these companies.

Good Liquidity and Tight Option Spreads

Illiquid options have wide bid-ask spreads that eat into your premium. Stick to stocks with high options volume. You can check this directly in Excel:

=TopOptionsByVolume("AAPL")

This returns the most actively traded options for a given ticker, helping you identify contracts with tight spreads and easy fills.

Moderate Implied Volatility

You want enough IV to generate meaningful premium, but not so much that the stock is likely to gap 20% on earnings. Moderate IV — typically 25% to 50% annually — hits the sweet spot. Check it with:

=ImpliedVolatility("AAPL")

Meme stocks with 150% IV might offer huge premiums, but assignment risk is extreme and the stock could collapse. On the other end, utility stocks with 15% IV barely generate enough premium to be worth the capital commitment.

No Upcoming Binary Events

Avoid selling puts right before earnings announcements, FDA decisions, or other binary catalysts. These events cause unpredictable gaps that can blow through your strike price overnight. Run the wheel during "boring" periods when the stock trades within a predictable range.

Check the Fundamentals

Before committing $20,000+ of capital to a wheel position, verify the company is financially sound:

=PERatio("AAPL")
=DividendYield("AAPL")
=MarketCapitalization("AAPL")
=Revenue("AAPL")

You want profitable companies with reasonable valuations. A stock with a P/E of 200 and no revenue growth is not a good wheel candidate — even if the premiums look juicy. The wheel demands stocks that have fundamental support in case you end up holding shares through a drawdown.

Building a Wheel Strategy Tracker in Excel

This is where MarketXLS transforms the wheel from a manual process into a systematic operation. Here is how to build a complete wheel strategy workbook with five tabs, each serving a specific function.

Tab 1: Stock Analysis Dashboard

Before entering any wheel trade, you need a quick snapshot of the stock's fundamentals and technicals. Set up columns for each candidate ticker and pull in the following:

=Last("AAPL")                    // Current stock price
=PERatio("AAPL")                 // Price-to-earnings ratio
=DividendYield("AAPL")           // Annual dividend yield
=Revenue("AAPL")                 // Total revenue
=MarketCapitalization("AAPL")    // Market cap
=RSI("AAPL")                     // Relative Strength Index
=SimpleMovingAverage("AAPL", 50) // 50-day moving average
=ImpliedVolatility("AAPL")       // Current implied volatility

This tab tells you at a glance whether a stock is worth wheeling. You want stocks trading near or below the 50-day moving average (better put entry), with RSI not in overbought territory, reasonable P/E ratios, and enough IV to generate decent premiums.

List 8-10 candidate stocks across the top and let the formulas populate automatically. Update the ticker symbols and the entire dashboard refreshes with live data.

Tab 2: Put Screening

Once you identify a stock worth wheeling, you need to find the right put to sell. This tab pulls the entire out-of-the-money option chain:

=QM_GetOptionChainOutOfTheMoney("AAPL")

This returns all OTM puts with their strikes, expirations, bid/ask prices, volume, open interest, and implied volatility. You are looking for puts that are:

• 5-10% out of the money (gives you a cushion before assignment)
• 20-45 days to expiration (optimal theta decay zone)
• High volume and open interest (liquidity for clean fills)

To drill into specific expirations and strikes:

=Expirations("AAPL")
=Strikes("AAPL")

These functions list all available expiration dates and strike prices, so you can zero in on exactly the contract you want.

Once you pick a contract, build the option symbol:

=OptionSymbol("AAPL", "2026-03-21", "P", 220)

This generates the standardized option symbol (like @AAPL 260321P00220000) that you can use to pull live quotes for that specific contract.

To verify liquidity on your chosen contract:

=TopOptionsByVolume("AAPL")

If your target contract shows up in the high-volume list, you know you will get a fair fill.

Tab 3: Position Tracking

This is the operational heart of the workbook. Every open wheel position gets a row with these columns:

The =Stream_Last() function gives you streaming real-time stock prices, while =QM_Last() pulls the latest option quote. Together, they let you monitor every open position without leaving your spreadsheet.

For each position, calculate the cost basis dynamically:

// If in CSP phase (not yet assigned):
Cost Basis = Strike - Premium Collected

// If in CC phase (already assigned, selling calls):
Cost Basis = Original Cost Basis - Sum of All Call Premiums Collected

Track cumulative premiums in a running total column. After several rounds of selling covered calls, you will see your cost basis steadily declining — that is the wheel working exactly as intended.

Tab 4: Call Screening

When you get assigned on a put and own 100 shares, switch to this tab to find covered calls to sell. The process mirrors the Put Screening tab:

=QM_GetOptionChainOutOfTheMoney("AAPL")

This time you are looking at OTM calls above your cost basis. The critical rule: never sell a covered call below your cost basis unless you are intentionally taking a loss to exit the position. If your cost basis is $215.50, look at calls with strikes of $217.50, $220, $225, or higher.

Use the same expiration and strike tools:

=Expirations("AAPL")
=Strikes("AAPL")
=OptionSymbol("AAPL", "2026-04-17", "C", 225)

Then pull the live quote on your chosen call:

=QM_Last("@AAPL 260417C00225000")

For managing existing covered call positions, our covered call management and tracking in Excel guide goes deeper into roll strategies and adjustment techniques.

Tab 5: P&L Summary

This tab aggregates everything into a portfolio-level view:

• Total Premiums Collected (all puts + all calls across all tickers)
• Total Capital Deployed (sum of cash secured for puts + cost of shares held)
• Current Portfolio Value (live stock prices × shares held + cash)
• Realized P&L (closed positions — shares called away or puts expired)
• Unrealized P&L (open positions — current market value vs. cost basis)
• Annualized Return — calculated using the formula from the math section above

Link this tab to the Position Tracking tab so numbers update automatically. A simple summary might look like:

Total Capital Deployed:     $88,000  (4 wheel positions)
Total Premiums Collected:   $6,240   (YTD)
Realized Gains:             $3,800
Unrealized P&L:             -$1,200
Net Return:                 $8,840   (10.05% YTD)
Annualized:                 ~26.8%

You can also use the options profit calculator to model different scenarios before entering trades.

Worked Example: A Complete Wheel Cycle on AAPL

Let us walk through all three phases of the wheel on Apple stock with concrete numbers. This example is for educational purposes only — it is not a trade recommendation.

Phase 1: Sell the Cash-Secured Put

You check your Stock Analysis tab and see AAPL trading at $232. The RSI is neutral, IV is moderate, and the stock is near its 50-day moving average. Good wheel candidate.

You pull up the put chain:

=QM_GetOptionChainOutOfTheMoney("AAPL")

You find the $220 put expiring in 30 days with a bid of $4.50. That is about 5% out of the money — a reasonable buffer.

Build the symbol and verify the quote:

=OptionSymbol("AAPL", "2026-03-21", "P", 220)
// Returns: @AAPL 260321P00220000

=QM_Last("@AAPL 260321P00220000")
// Returns: $4.50

You sell 1 contract and collect $450 (= $4.50 × 100 shares).

Capital required: $22,000 ($220 strike × 100) Premium collected: $450 Return if put expires worthless: 2.05% in 30 days (24.9% annualized)

Scenario A: Put Expires Worthless

AAPL stays above $220 at expiration. The put expires worthless, you keep the $450, and your capital is freed up. Go back to Phase 1 and sell another put. Rinse and repeat.

If you do this successfully 8-10 times a year, the premiums alone can generate a double-digit annual return without ever owning a single share.

Scenario B: You Get Assigned

AAPL drops to $216 at expiration. The $220 put is in the money, and you are assigned 100 shares at $220 per share.

But remember — you collected $4.50 in premium. Your effective cost basis is:

Cost Basis = $220.00 - $4.50 = $215.50

AAPL is at $216, and your cost basis is $215.50. You are already slightly in the green on an unrealized basis. Move to Phase 2.

Phase 2: You Own 100 Shares

You now hold 100 shares of AAPL at a cost basis of $215.50. Update your Position Tracking tab to reflect the new phase and monitor the stock with:

=Stream_Last("AAPL")

You are not panicking about the stock being below the original $220 strike because your actual entry price is $215.50, and you were happy to own AAPL at this level. Move immediately to Phase 3.

Phase 3: Sell the Covered Call

Check the call chain for strikes above your $215.50 cost basis:

=QM_GetOptionChainOutOfTheMoney("AAPL")
=OptionSymbol("AAPL", "2026-04-17", "C", 225)
// Returns: @AAPL 260417C00225000

The $225 call expiring in 30 days has a bid of $3.20. You sell 1 contract and collect $320.

Your adjusted cost basis is now:

Adjusted Cost Basis = $215.50 - $3.20 = $212.30

Scenario A: Call Expires Worthless

AAPL stays below $225. You keep the $320 premium, and your cost basis drops further. Sell another covered call and repeat. Each round pushes your break-even lower.

After three rounds of covered calls at roughly $3.00 each, your cost basis would be approximately $206.50. AAPL would need to drop 11% from your original put strike before you have an actual loss.

Scenario B: Shares Are Called Away

AAPL rallies to $228, and your $225 call is exercised. You sell your 100 shares at $225.

Let us calculate the total return for this complete wheel cycle:

Put premium collected:    $4.50 × 100 = $450
Call premium collected:   $3.20 × 100 = $320
Capital gain on shares:   ($225 - $220) × 100 = $500
──────────────────────────────────────────────
Total profit:             $1,270
Capital deployed:         $22,000
Return:                   5.77%
Duration:                 ~60 days
Annualized:               35.1%

You now have $22,500 in cash (proceeds from the sale) plus $770 in premiums. Go back to Phase 1 and start another wheel cycle.

When the Wheel Goes Wrong: Risk Management

The wheel is not risk-free. Understanding what can go wrong — and how to respond — is essential.

The Stock Drops Significantly

This is the biggest risk. If you sell a $220 put and the stock drops to $180, you own shares at an effective cost basis of $215.50 that are now worth $180. That is a $3,550 unrealized loss per contract.

How to manage it: Do not panic-sell. If the company's fundamentals are intact (which they should be, because you screened for quality), continue selling covered calls to reduce your cost basis. Sell calls at strikes above your cost basis, even if the premiums are smaller. Over time, the premium income chips away at the loss.

If the stock has suffered a fundamental deterioration — the reason you chose it no longer holds — it may be better to take the loss and redeploy capital elsewhere. The wheel does not obligate you to hold forever.

The Stock Rockets Higher (Opportunity Cost)

If you sell a $225 covered call and AAPL shoots to $260, your shares are called away at $225. You made money — but you "missed" $35 per share of upside.

How to manage it: This is an opportunity cost, not an actual loss. You still profited on the trade. The wheel is an income strategy, not a growth strategy. If you want full upside exposure, the wheel is not the right approach for that particular stock.

To reduce this risk, sell calls further out of the money (e.g., $240 or $250 instead of $225). You collect less premium, but you have more room for the stock to appreciate before your shares are called away.

Low IV Environments

When implied volatility drops across the market, premiums shrink. A put that would normally pay $4.50 might only pay $1.50 in a low-IV environment. At that point, the return on capital may not justify tying up $22,000.

How to manage it: Either widen your strike selection (go slightly closer to at-the-money for higher premiums), extend duration (sell 45-day options instead of 30), or simply pause the wheel and wait for volatility to return. There is no rule that says you must always be in a trade.

Rolling Options: The Adjustment Tool

When a position moves against you, rolling is your primary adjustment mechanism:

• Roll a put down and out: If the stock is dropping toward your put strike, buy back the current put and sell a new one at a lower strike with a later expiration. You collect additional premium and give yourself a lower effective entry price.
• Roll a call up and out: If the stock is rallying through your call strike, buy back the current call and sell a new one at a higher strike with a later expiration. You keep your shares and potentially participate in more upside.

The key with rolling: always collect a net credit. If you cannot roll for a credit, it may be better to let the option expire and accept the assignment or exercise.

The Wheel on Different Underlyings

Not every underlying works for the wheel. Here is how the major categories break down:

SPX (S&P 500 Index Options)

Cannot wheel SPX. SPX options are cash-settled — when a put is exercised, you receive cash, not shares. Since the wheel requires you to own shares in Phase 2, cash-settled index options do not work.

SPY (S&P 500 ETF)

SPY works well for the wheel. SPY options are physically settled, meaning you actually receive (or deliver) 100 shares of the ETF. SPY has enormous options liquidity, tight spreads, and it tracks the broad market. The downside: SPY's IV is typically lower than individual stocks, so premiums are smaller relative to the capital required (roughly $55,000+ per wheel position at current levels).

Individual Stocks

Individual stocks are the best wheel candidates for most traders. They offer higher IV (and therefore higher premiums) than ETFs, and you can pick companies you genuinely want to own. The tradeoff is higher individual stock risk compared to a diversified ETF.

The ideal wheel stock has:

• A share price between $20 and $250 (manageable capital requirements)
• Options volume of at least 1,000 contracts per day
• IV between 25% and 50%
• Strong fundamentals and a business you understand

Frequently Asked Questions

What is the minimum account size for the wheel strategy?

The minimum depends on the stock price. To sell one cash-secured put on a $50 stock, you need $5,000. For a $200 stock, you need $20,000. Most brokers also require options approval for selling puts (Level 2 or higher). A practical minimum for running the wheel on quality stocks is $10,000-$25,000, which gives you enough capital for one or two positions on mid-priced stocks.

How do I choose the right strike price for cash-secured puts?

Look for strikes 5-10% below the current stock price. This gives the stock room to decline before you are assigned. The delta of the put is a useful guide — a delta of -0.20 to -0.30 means there is roughly a 20-30% chance of assignment, which is a reasonable balance between premium income and assignment risk. Use =QM_GetOptionChainOutOfTheMoney("AAPL") to compare premiums across different strikes.

What if the stock drops 30% — do I keep selling covered calls?

It depends on why the stock dropped. If the company's fundamentals are intact and the drop is driven by broad market conditions, continue selling covered calls above your cost basis to reduce it further. The premiums will likely be higher due to elevated IV, which accelerates cost basis reduction.

If the company has suffered a fundamental breakdown (accounting scandal, competitive disruption, regulatory action), it may be better to exit the position and accept the loss. The wheel is not a reason to hold a broken company.

Can I run the wheel on multiple stocks at once?

Absolutely — and most experienced wheel traders do. Diversifying across 3-5 uncorrelated stocks reduces the risk that one bad position sinks your overall return. Use the P&L Summary tab in your Excel workbook to track all positions in one place. Just make sure you have enough capital to fully secure every position. Running five wheels on $200 stocks requires $100,000 in capital.

How does the wheel compare to just buying and holding?

In strong bull markets, buy and hold will usually outperform the wheel because the covered call caps your upside. In sideways, choppy, or mildly bearish markets, the wheel often outperforms because you are collecting premium that buy-and-hold investors are not.

The wheel is best viewed as a complement to buy and hold, not a replacement. Use it on a portion of your portfolio for income generation while maintaining core long-term positions without options overlays.

Is the wheel strategy suitable for retirement accounts (IRA/401k)?

Yes — the wheel works well in IRAs, and many traders prefer running it there for tax advantages. Cash-secured puts and covered calls are both permitted in most IRA accounts (check with your broker). The tax benefit is significant: in a taxable account, the frequent short-term premium income is taxed at your ordinary income rate. In a Roth IRA, that income grows tax-free.

The one limitation is that IRAs do not allow margin, so every put must be fully cash-secured. This is actually not a limitation for the wheel — fully cash-secured is how the strategy is designed to work.

The Bottom Line

The options wheel strategy is a disciplined, repeatable income system. Sell puts on stocks you want to own, collect premium, accept assignment when it comes, sell calls against your shares, collect more premium, and repeat. Every phase of the cycle generates income, and the math compounds over time as your cost basis declines.

Excel turns this from a strategy you run in your head into a system you can track, analyze, and optimize. With MarketXLS functions pulling live stock prices, option chains, fundamentals, and technical indicators directly into your spreadsheet, you have everything you need to screen candidates, evaluate trades, monitor positions, and calculate real returns — all without leaving Excel.

The workbook structure outlined in this guide — Stock Analysis, Put Screening, Position Tracking, Call Screening, and P&L Summary — gives you a complete operational framework. Build it once, and it becomes your wheel strategy command center.

Ready to build your own wheel strategy tracker? Explore MarketXLS plans and see what MarketXLS can do for your options trading workflow to get real-time option chains, streaming quotes, and 1,100+ Excel functions that make systematic options trading possible.

This content is for educational purposes only and does not constitute investment advice. Options trading involves risk and is not suitable for all investors. Past performance does not guarantee future results.