Vertical Options Spread: Complete Guide to Bull & Bear Spread Strategies in Excel

Vertical options spread strategies are among the most versatile tools in any options trader's arsenal. Whether you are mildly bullish, moderately bearish, or simply looking for a way to collect premium with defined risk, a vertical spread can be structured to match your market outlook. In this comprehensive guide, you will learn how all four vertical spread types work, see real profit-and-loss examples with specific strikes, and discover how to build and monitor every spread directly inside Excel using MarketXLS.

Vertical Options Spread Fundamentals

Before diving into individual strategies, it is important to understand what makes a vertical spread "vertical." A vertical options spread involves buying one option and selling another option of the same type (both calls or both puts), on the same underlying, with the same expiration date, but at different strike prices. Because the two strikes are stacked vertically on an option chain, the strategy earns its name.

Why Trade Vertical Spreads?

Vertical spreads offer several advantages over buying or selling naked options:

• Defined risk: Your maximum loss is known before you enter the trade. There is no margin call surprise.
• Lower capital requirement: Because you hold one option against the other, margin requirements are reduced compared to naked short options.
• Flexible directional bets: You can structure a vertical spread for bullish, bearish, or neutral outlooks.
• Volatility management: Credit spreads benefit from declining implied volatility, while debit spreads benefit from rising implied volatility — giving you a way to express a volatility view alongside a directional view.
• Probability tuning: By choosing how far apart the strikes are and how far out of the money the short strike sits, you can adjust the probability of profit to match your risk tolerance.

Debit Spreads vs. Credit Spreads

Every vertical spread falls into one of two categories:

Debit spreads occur when the option you buy costs more than the option you sell. You pay a net premium (debit) to enter the trade. Your maximum profit is the difference between the strike prices minus the debit paid. Bull call spreads and bear put spreads are debit spreads.

Credit spreads occur when the option you sell is worth more than the option you buy. You receive a net premium (credit) when entering the trade. Your maximum profit is the credit received. Bull put spreads and bear call spreads are credit spreads.

Understanding this distinction is critical because it determines when you want the underlying to move and how time decay (theta) affects your position.

Vertical Options Spread: The Four Types

There are exactly four vertical spread configurations. Each combines a long and short option at different strikes:

1. Bull Call Spread — Buy a lower-strike call, sell a higher-strike call (debit)
2. Bear Put Spread — Buy a higher-strike put, sell a lower-strike put (debit)
3. Bull Put Spread — Sell a higher-strike put, buy a lower-strike put (credit)
4. Bear Call Spread — Sell a lower-strike call, buy a higher-strike call (credit)

Let's examine each one in detail with real examples using AAPL options.

Vertical Options Spread #1: Bull Call Spread

A bull call spread is a debit spread that profits when the underlying stock rises. You buy a call at a lower strike and simultaneously sell a call at a higher strike, both with the same expiration.

How the Bull Call Spread Works

Suppose AAPL is trading near $230. You are moderately bullish and expect the stock to rise over the next few months but do not want to risk the full cost of a long call.

Trade setup (June 2026 expiration):

• Buy 1 AAPL June 19, 2026 $225 Call for $18.50
• Sell 1 AAPL June 19, 2026 $245 Call for $9.00

Key metrics:

• Net Debit Paid: $18.50 − $9.00 = $9.50 per share ($950 per contract)
• Maximum Profit: ($245 − $225) − $9.50 = $10.50 per share ($1,050 per contract)
• Maximum Loss: $9.50 per share ($950 per contract) — this occurs if AAPL closes at or below $225 at expiration
• Breakeven: $225 + $9.50 = $234.50

Bull Call Spread P&L Scenarios

Notice that once AAPL moves above $245, both options are in the money and their values increase at the same rate, so your profit is capped at $10.50 per share.

When to Use a Bull Call Spread

• You are moderately bullish — you expect the stock to rise but not dramatically.
• Implied volatility is relatively low — since you are a net buyer of premium, lower IV means cheaper entry.
• You want to reduce your cost basis versus buying a naked long call.
• You have a specific upside target in mind and are comfortable capping your gains at that level.

Building a Bull Call Spread in Excel with MarketXLS

Here is how to set up this trade in your MarketXLS spreadsheet:

Step 1: Get the current stock price.

=Last("AAPL")

This returns the live price of AAPL so you can choose your strikes relative to the current market.

Step 2: Pull the full option chain.

=QM_GetOptionChain("AAPL")

This populates your spreadsheet with every available strike and expiration, including bid, ask, volume, and open interest. Use this to identify liquid strikes for your spread.

Step 3: Build the option symbols for your chosen legs.

=OptionSymbol("AAPL", "2026-06-19", "C", 225)
=OptionSymbol("AAPL", "2026-06-19", "C", 245)

These return the standardized option symbols like @AAPL 260619C00225000 and @AAPL 260619C00245000.

Step 4: Get live prices for each leg.

=QM_Last("@AAPL 260619C00225000")
=QM_Last("@AAPL 260619C00245000")

Step 5: Calculate your spread metrics.

In adjacent cells, calculate:

• Net Debit = Long call price − Short call price
• Max Profit = (Upper strike − Lower strike) − Net Debit
• Max Loss = Net Debit
• Breakeven = Lower strike + Net Debit

Step 6: Analyze the Greeks.

=QM_GetOptionQuotesAndGreeks("AAPL")

This returns delta, gamma, theta, vega, and implied volatility for every AAPL option. Your net position Greeks are simply the difference between your long call's Greeks and your short call's Greeks. A bull call spread typically has positive net delta (bullish), negative net theta (time decay hurts), and positive net vega (benefits from rising IV).

Vertical Options Spread #2: Bear Put Spread

A bear put spread is a debit spread that profits when the underlying stock declines. You buy a put at a higher strike and simultaneously sell a put at a lower strike, both with the same expiration.

How the Bear Put Spread Works

Suppose you believe AAPL will pull back from its current level of $230 over the next few months.

Trade setup (June 2026 expiration):

• Buy 1 AAPL June 19, 2026 $235 Put for $16.00
• Sell 1 AAPL June 19, 2026 $215 Put for $8.00

Key metrics:

• Net Debit Paid: $16.00 − $8.00 = $8.00 per share ($800 per contract)
• Maximum Profit: ($235 − $215) − $8.00 = $12.00 per share ($1,200 per contract)
• Maximum Loss: $8.00 per share ($800 per contract) — this occurs if AAPL closes at or above $235 at expiration
• Breakeven: $235 − $8.00 = $227.00

Bear Put Spread P&L Scenarios

When to Use a Bear Put Spread

• You are moderately bearish — you expect a decline but not a crash.
• Implied volatility is relatively low — you are a net buyer of premium.
• You want downside exposure at a lower cost than buying a naked long put.
• You have a downside target and are willing to cap your profit at that level.

Building a Bear Put Spread in Excel with MarketXLS

The process mirrors the bull call spread setup:

=Last("AAPL")
=QM_GetOptionChain("AAPL")
=OptionSymbol("AAPL", "2026-06-19", "P", 235)
=OptionSymbol("AAPL", "2026-06-19", "P", 215)
=QM_Last("@AAPL 260619P00235000")
=QM_Last("@AAPL 260619P00215000")

Then calculate:

• Net Debit = Long put price − Short put price
• Max Profit = (Higher strike − Lower strike) − Net Debit
• Max Loss = Net Debit
• Breakeven = Higher strike − Net Debit

Use =QM_GetOptionQuotesAndGreeks("AAPL") to check the net Greeks. A bear put spread has negative net delta (bearish), negative net theta (time hurts), and typically positive net vega.

Vertical Options Spread #3: Bull Put Spread (Credit Spread)

A bull put spread is a credit spread that profits when the underlying stock stays above the short put strike. You sell a put at a higher strike and buy a put at a lower strike. Because the short put has more premium, you collect a net credit.

How the Bull Put Spread Works

You are neutral to moderately bullish on AAPL at $230 and want to collect premium.

Trade setup (June 2026 expiration):

• Sell 1 AAPL June 19, 2026 $220 Put for $10.50
• Buy 1 AAPL June 19, 2026 $200 Put for $4.00

Key metrics:

• Net Credit Received: $10.50 − $4.00 = $6.50 per share ($650 per contract)
• Maximum Profit: $6.50 per share ($650 per contract) — occurs if AAPL closes at or above $220 at expiration
• Maximum Loss: ($220 − $200) − $6.50 = $13.50 per share ($1,350 per contract)
• Breakeven: $220 − $6.50 = $213.50

Bull Put Spread P&L Scenarios

When to Use a Bull Put Spread

• You are neutral to moderately bullish — you believe the stock will stay above a certain level.
• Implied volatility is high — you want to sell expensive premium and benefit from IV contraction.
• You want time decay (theta) working in your favor.
• You prefer a high probability of profit (the stock just needs to stay above your short strike).

Building a Bull Put Spread in Excel with MarketXLS

=Last("AAPL")
=QM_GetOptionChain("AAPL")
=OptionSymbol("AAPL", "2026-06-19", "P", 220)
=OptionSymbol("AAPL", "2026-06-19", "P", 200)
=QM_Last("@AAPL 260619P00220000")
=QM_Last("@AAPL 260619P00200000")

Calculate:

• Net Credit = Short put price − Long put price
• Max Profit = Net Credit
• Max Loss = (Short strike − Long strike) − Net Credit
• Breakeven = Short strike − Net Credit

A bull put spread has positive net delta (bullish), positive net theta (time decay helps), and negative net vega (benefits from falling IV). Use =QM_GetOptionQuotesAndGreeks("AAPL") to confirm the Greeks on each leg.

Vertical Options Spread #4: Bear Call Spread (Credit Spread)

A bear call spread is a credit spread that profits when the underlying stock stays below the short call strike. You sell a call at a lower strike and buy a call at a higher strike.

How the Bear Call Spread Works

You are neutral to moderately bearish on AAPL at $230 and want to collect premium.

Trade setup (June 2026 expiration):

• Sell 1 AAPL June 19, 2026 $240 Call for $8.00
• Buy 1 AAPL June 19, 2026 $260 Call for $2.50

Key metrics:

• Net Credit Received: $8.00 − $2.50 = $5.50 per share ($550 per contract)
• Maximum Profit: $5.50 per share ($550 per contract) — occurs if AAPL closes at or below $240 at expiration
• Maximum Loss: ($260 − $240) − $5.50 = $14.50 per share ($1,450 per contract)
• Breakeven: $240 + $5.50 = $245.50

Bear Call Spread P&L Scenarios

When to Use a Bear Call Spread

• You are neutral to moderately bearish — you believe the stock will not rise above a certain level.
• Implied volatility is high — you want to sell expensive premium.
• You want time decay (theta) working in your favor.
• You want a bearish position with defined risk and lower margin than a naked short call.

Building a Bear Call Spread in Excel with MarketXLS

=Last("AAPL")
=QM_GetOptionChain("AAPL")
=OptionSymbol("AAPL", "2026-06-19", "C", 240)
=OptionSymbol("AAPL", "2026-06-19", "C", 260)
=QM_Last("@AAPL 260619C00240000")
=QM_Last("@AAPL 260619C00260000")

Calculate:

• Net Credit = Short call price − Long call price
• Max Profit = Net Credit
• Max Loss = (Long strike − Short strike) − Net Credit
• Breakeven = Short strike + Net Credit

A bear call spread has negative net delta (bearish), positive net theta (time helps), and negative net vega (falling IV helps). Check these with =QM_GetOptionQuotesAndGreeks("AAPL").

Vertical Options Spread Comparison: All Four Types at a Glance

Here is a side-by-side comparison of the four vertical spread strategies:

Vertical Options Spread: Greeks Analysis

Understanding how the Greeks affect your vertical spread is essential for managing the position after entry. Here is how each Greek behaves differently for debit and credit spreads.

Delta

Delta measures directional exposure. A bull call spread and bull put spread both have positive net delta — they benefit when the stock rises. A bear put spread and bear call spread both have negative net delta — they benefit when the stock declines. As the stock moves deeper in the money, delta approaches its maximum; as it moves out of the money, delta approaches zero.

Gamma

Gamma measures the rate of change in delta. Vertical spreads have lower net gamma than single-leg positions because the short option's negative gamma partially offsets the long option's positive gamma. This makes vertical spreads more predictable but slower to accelerate in profit.

Theta

Theta measures time decay. This is where credit and debit spreads differ most:

• Credit spreads (bull put, bear call): Positive theta — time passing increases your profit.
• Debit spreads (bull call, bear put): Negative theta — time passing decreases your position value.

This is why credit spreads are popular among income-oriented traders: you profit simply from the passage of time, as long as the stock cooperates.

Vega

Vega measures sensitivity to implied volatility changes:

• Debit spreads: Positive vega — you benefit from rising implied volatility.
• Credit spreads: Negative vega — you benefit from declining implied volatility.

This is why timing your entry relative to implied volatility levels matters. Enter debit spreads when IV is low and credit spreads when IV is high.

Monitoring Greeks in MarketXLS

Use the following formula to pull Greeks for all AAPL options:

=QM_GetOptionQuotesAndGreeks("AAPL")

This returns delta, gamma, theta, vega, rho, and implied volatility for each strike and expiration. To find your spread's net Greeks, simply subtract the short leg's Greeks from the long leg's Greeks. For example:

• Net Delta = Long option delta − Short option delta
• Net Theta = Long option theta − Short option theta
• Net Vega = Long option vega − Short option vega

Vertical Options Spread: Strike Selection Strategies

Choosing the right strikes is arguably the most important decision when constructing a vertical spread. Here are several approaches.

ATM vs. OTM Spread Placement

At-the-money (ATM) debit spreads have the highest absolute delta and the greatest dollar risk but also the largest potential payout. They are appropriate when you have a strong directional conviction.

Out-of-the-money (OTM) credit spreads have a higher probability of profit because the stock needs to move against you significantly before you lose money. However, the reward-to-risk ratio is less favorable.

Width of the Spread

The distance between your two strikes (the "width") affects both your maximum profit and maximum loss:

• Narrow spreads (e.g., $5 wide): Lower max profit, lower max loss, lower capital requirement. Good for frequent, small trades.
• Wide spreads (e.g., $20 wide): Higher max profit, higher max loss, more capital tied up. Better when you have strong conviction and want larger payouts.

Delta-Based Strike Selection

Many professional traders choose their short strike based on a target delta:

• 0.30 delta short strike: Approximately 70% probability of expiring out of the money. A good balance between premium collected and probability of success.
• 0.16 delta short strike: Approximately one standard deviation out of the money, roughly 84% probability of expiring OTM. Lower premium but higher win rate.
• 0.10 delta short strike: Very high probability of success but minimal premium collected. Usually requires wider spreads or more contracts to generate meaningful income.

You can find the delta for each strike using:

=QM_GetOptionQuotesAndGreeks("AAPL")

Scan the delta column to locate the strike closest to your target delta, then set your long option a fixed width away.

Vertical Options Spread: Managing and Adjusting Trades

No trade plan survives contact with the market perfectly. Here are strategies for managing vertical spreads after entry.

Taking Profits Early

Many traders close their credit spreads when they have captured 50% to 75% of the maximum profit. For example, if you received a $5.50 credit on a bear call spread, consider closing the position when you can buy it back for $1.38 to $2.75 (capturing 50-75% of the premium). This reduces your exposure to a sudden adverse move near expiration.

For debit spreads, consider closing when the spread has reached 50% to 75% of the maximum value. Holding to expiration introduces pin risk and gamma risk that can erode profits rapidly.

Rolling the Spread

If the underlying moves against you but your thesis remains intact, you can "roll" the spread:

• Roll out in time: Close the current spread and open a new one at the same strikes but a later expiration. This gives the trade more time to work.
• Roll up or down: Adjust the strikes to reflect a new support or resistance level. This effectively resets the trade with new strikes.

Rolling involves closing one spread and opening another, so there will be transaction costs. Make sure the new spread offers a favorable risk/reward before rolling.

Stop-Loss Rules

A common stop-loss rule for credit spreads is to close the position if the loss reaches 1x to 2x the credit received. For example, if you received $5.50 on a bear call spread, close the position if the spread value rises to $11.00 to $16.50 (representing a loss of $5.50 to $11.00). This prevents a small loss from turning into the maximum loss.

For debit spreads, consider closing if the spread has lost 50% of its value and your thesis is no longer valid.

Vertical Options Spread: Advanced Concepts

Combining Verticals into Iron Condors

An iron condor combines a bull put spread and a bear call spread on the same underlying and expiration. This creates a range-bound strategy that profits when the stock stays between the two short strikes. Iron condors are essentially two vertical credit spreads working together.

For example, combining our bull put spread ($200/$220) and bear call spread ($240/$260) on AAPL creates an iron condor that profits as long as AAPL stays between $213.50 and $245.50 at expiration.

Vertical Spreads vs. Iron Condors

Synthetic Relationships

A bull call spread and a bull put spread at the same strikes produce nearly identical risk profiles (assuming the same strikes and expiration). The difference is that one is a debit spread and the other is a credit spread. This is a consequence of put-call parity. In practice, traders choose between them based on which offers better liquidity, tighter bid-ask spreads, and more favorable margin treatment.

Assignment Risk

For American-style options, the short leg of your vertical spread can be assigned at any time before expiration. This is most likely to happen when:

• The short option is deep in the money.
• The ex-dividend date is approaching (for short calls).
• The option is near expiration with little time value remaining.

If assigned on your short leg, you still hold the long leg as protection. For call spreads, assignment means you are short 100 shares (covered by your long call). For put spreads, assignment means you are long 100 shares (covered by your long put). While inconvenient, the risk is still defined.

Vertical Options Spread: Complete Workflow in MarketXLS

Here is a step-by-step workflow for analyzing and entering any vertical spread using MarketXLS in Excel.

Step 1: Check the Underlying Price

=Last("AAPL")

Note the current price to determine where to place your strikes.

Step 2: Pull the Option Chain

=QM_GetOptionChain("AAPL")

This gives you all available strikes, expirations, and pricing data. Identify the expiration cycle that matches your time horizon (typically 30 to 60 days for credit spreads, 60 to 90 days for debit spreads).

Step 3: Analyze Greeks and Implied Volatility

=QM_GetOptionQuotesAndGreeks("AAPL")

Look at the implied volatility percentile for the underlying. If IV is elevated (above the 50th percentile), credit spreads are favored. If IV is low, debit spreads are favored.

Step 4: Select Your Strikes

Based on your directional outlook and delta targets, choose the strikes for your spread. Use the delta column from the Greeks data to find the appropriate short strike.

Step 5: Build Option Symbols and Get Live Prices

=OptionSymbol("AAPL", "2026-06-19", "C", 240)
=OptionSymbol("AAPL", "2026-06-19", "C", 260)
=QM_Last("@AAPL 260619C00240000")
=QM_Last("@AAPL 260619C00260000")

Step 6: Calculate Spread Metrics

Build formulas for net debit/credit, max profit, max loss, breakeven, and risk/reward ratio. Create a simple P&L table at various stock prices at expiration.

Step 7: Monitor the Position

After entering the trade, use =QM_Last() to track each leg's price in real time. Recalculate your net P&L and compare it to your profit target and stop-loss levels. Update Greeks using =QM_GetOptionQuotesAndGreeks("AAPL") to monitor how delta, theta, and vega shift as the underlying moves and time passes.

Vertical Options Spread: Common Mistakes to Avoid

Even experienced traders make mistakes with vertical spreads. Here are the most common pitfalls:

1. Ignoring Liquidity

Always check bid-ask spreads before entering a vertical spread. Wide bid-ask spreads can eat into your profit and make it difficult to exit at a fair price. Stick to highly liquid underlyings like AAPL, SPY, QQQ, and MSFT. Use =QM_GetOptionChain("AAPL") to check volume and open interest.

2. Choosing the Wrong Expiration

Too-short expirations amplify gamma risk. Too-long expirations tie up capital without significantly improving your probability of profit. For credit spreads, 30 to 45 days to expiration is typically the sweet spot where theta decay accelerates. For debit spreads, 45 to 90 days gives the trade enough time to work without excessive time decay.

3. Making the Spread Too Wide or Too Narrow

An overly narrow spread (e.g., $2.50 wide) may not generate enough premium on a credit spread to justify the commission costs and effort. An overly wide spread concentrates too much capital in a single trade. Aim for a spread width that produces a risk/reward ratio you are comfortable with — typically 1:2 to 1:3 for credit spreads.

4. Neglecting Position Sizing

No single vertical spread should represent more than 2% to 5% of your total portfolio risk. Because the maximum loss is known, position sizing is straightforward: divide your maximum acceptable dollar loss by the maximum loss per spread to determine how many contracts to trade.

5. Holding to Expiration

Holding credit spreads to expiration to squeeze out the last few cents of premium exposes you to pin risk and potential assignment. Close the trade early when you have captured 50% or more of the maximum profit.

Vertical Options Spread vs. Other Strategies

Vertical Spread vs. Naked Long Option

A naked long call or put has unlimited profit potential but costs more and decays faster. A vertical spread reduces your cost and your risk but caps your profit. For most traders, the defined risk of a vertical spread is worth the trade-off.

Vertical Spread vs. Covered Call

A covered call requires owning 100 shares of stock (significant capital). A bull call spread achieves a similar bullish outlook with far less capital. However, covered calls generate dividends and have different tax treatment.

Vertical Spread vs. Iron Butterfly

An iron butterfly uses ATM short options with OTM long wings. It collects more premium than a vertical spread but exposes you to two-sided risk. Use vertical spreads when you have a directional opinion and iron butterflies when you are strongly neutral.

Vertical Options Spread: Frequently Asked Questions

What is a vertical options spread?

A vertical options spread is a two-leg options strategy where you buy one option and sell another option of the same type (both calls or both puts) with the same expiration date but different strike prices. The name comes from the vertical alignment of different strikes on an option chain. Vertical spreads can be structured as debit spreads (you pay to enter) or credit spreads (you receive premium to enter).

Which vertical spread is best for beginners?

The bull put spread (credit spread) is often recommended for beginners because time decay works in your favor, the probability of profit is typically above 60% to 70% when using OTM strikes, and the mechanics are intuitive: you profit as long as the stock stays above your short strike. However, all four types are straightforward once you understand the basic construction.

How much capital do I need to trade vertical spreads?

The capital required is the maximum loss of the spread. For a $20-wide credit spread with $6.50 net credit, your maximum loss is $13.50 per share, or $1,350 per contract. Most brokers require you to hold this amount (minus the credit received) as margin. Debit spreads simply require the net debit paid. Vertical spreads are accessible with accounts as small as $2,000 to $5,000.

Can I lose more than my maximum loss on a vertical spread?

No. The defining feature of a vertical spread is that both your maximum profit and maximum loss are known before you enter the trade. The long option protects you against losses beyond the spread width. The only exception is early assignment risk on the short leg, which can temporarily create a larger position, but your long option still provides the hedge.

Should I trade debit spreads or credit spreads?

This depends on your market outlook and the implied volatility environment. When IV is high, credit spreads are favored because you sell expensive premium and benefit from IV contraction. When IV is low, debit spreads are favored because you buy cheap premium with room for IV expansion. Your directional outlook then determines whether you choose a bull or bear variant.

How do I close a vertical spread before expiration?

To close a vertical spread, you reverse both legs simultaneously. If you bought a bull call spread (long lower call, short higher call), you sell the lower call and buy back the higher call. Most brokers allow you to close multi-leg positions as a single order, which helps you avoid leg risk. Use MarketXLS to monitor the current value of each leg with =QM_Last() and determine the optimal exit point.

Vertical Options Spread: Getting Started with MarketXLS

MarketXLS brings institutional-grade options data directly into Excel, making it the ideal platform for analyzing vertical spreads. With live option chain data, real-time Greeks, and the ability to build any option symbol programmatically, you can:

• Screen hundreds of potential spreads across multiple underlyings in seconds
• Calculate exact max profit, max loss, and breakeven for every spread configuration
• Monitor your open positions with live pricing and dynamic P&L tracking
• Analyze how changing implied volatility and time decay affect your positions

Whether you are constructing a simple bull call spread, selling a bull put credit spread, or building a multi-leg iron condor, MarketXLS gives you the data and flexibility to make informed decisions.

Ready to analyze vertical spreads in Excel? Visit MarketXLS to explore plans, or go directly to the pricing page to get started.

Disclaimer

None of the content published on marketxls.com constitutes a recommendation that any particular security, portfolio of securities, transaction, or investment strategy is suitable for any specific person. The author is not offering any professional advice of any kind. The reader should consult a professional financial advisor to determine their suitability for any strategies discussed herein. The article is written to help users collect the required information from various sources deemed to be an authority in their content. The trademarks, if any, are the property of their owners, and no representations are made.