A put ratio spread is a neutral-to-bearish options strategy: buy one put at a higher strike (A) and sell two puts at a lower strike (B), all with the same expiration. It profits most, (A − B) minus the net debit, when the stock closes exactly at the short strike at expiration. It can be entered for a small debit or a credit, but below the lower breakeven the extra short put loses about $1 per share for each $1 the stock falls, so the loss is large (up to 2B − A plus the net debit per share if the stock went to zero). This guide covers setup, a worked P&L example, the Greeks, risk management, and building the spread in Excel with MarketXLS.
How the Put Ratio Spread Works
The put ratio spread (also called a put front spread or put ratio vertical spread) uses an unequal number of long and short puts to create a position that profits from a controlled, moderate decline in the underlying stock.
Standard 1:2 Put Ratio Spread Setup
| Leg | Action | Strike | Quantity | Premium |
|---|---|---|---|---|
| Leg 1 | Buy 1 put | Higher strike (A) | 1 | Debit (pay premium) |
| Leg 2 | Sell 2 puts | Lower strike (B) | 2 | Credit (receive premium) |
Net cost: The premium received from selling two puts may partially or fully offset the cost of buying one put. This can result in a net debit (you pay), net credit (you receive), or even zero cost.
Entry Calculation
Net Debit = Premium Paid for Long Put − (2 × Premium Received for Each Short Put)
If the result is negative, you have a net credit entry.
MarketXLS Functions for Setup
Use MarketXLS to pull option chain data for constructing the spread (end-of-day on the Standard plan, real-time on Advanced and Business):
=QM_GetOptionChain("AAPL")
Formula documentation: QM_GetOptionChain
This returns the full option chain with all available strikes and expirations. From there, select your target strikes.
To get a specific option's price, first build the option symbol:
=OptionSymbol("AAPL", "2026-03-20", "P", 220)
Formula documentation: OptionSymbol
This returns the QuoteMedia option symbol (@AAPL 260320P00220000, with the ticker padded to 6 characters). Then get the current price by referencing it:
=QM_Last(OptionSymbol("AAPL", "2026-03-20", "P", 220))
Formula documentation: QM_Last, OptionSymbol
For full Greeks and quotes on the entire chain:
=QM_GetOptionQuotesAndGreeks("AAPL")
Formula documentation: QM_GetOptionQuotesAndGreeks
Payoff Diagram and P&L Analysis
The put ratio spread has a distinctive payoff profile with three distinct zones.
P&L Zones
| Stock Price at Expiration | Outcome | P&L |
|---|---|---|
| Above Strike A (higher strike) | All puts expire worthless | Loss = net debit paid (or profit = net credit received) |
| At Strike A | Long put is at-the-money, shorts are OTM | Small loss/gain depending on entry cost |
| Between Strike A and Strike B | Long put is ITM, short puts are OTM | Increasing profit as price moves toward B |
| At Strike B (lower strike) | Maximum profit: long put has full value, short puts expire worthless | Max Profit = (A − B) × 100 − Net Debit |
| Below Strike B | All puts are ITM; short puts create increasing losses | Loss increases dollar-for-dollar below breakeven |
| Far below Strike B | Large loss: two short puts overwhelm one long put | Loss = (2 × short put loss) − long put gain − net credit |
Maximum Profit Calculation
Max Profit = (Strike A − Strike B) × 100 − Net Debit Paid
If you entered for a net credit:
Max Profit = (Strike A − Strike B) × 100 + Net Credit Received
Maximum profit occurs when the stock closes exactly at Strike B at expiration.
Maximum Loss
The put ratio spread has large but limited downside risk. Below the breakeven point, losses grow about $1 per share for every $1 the stock falls, until the stock reaches zero:
Max Loss per Share = (2 × Strike B) − Strike A + Net Debit (or − Net Credit)
In the example below, that is $400 − $220 + $2 = $182 per share, or $18,200 per spread, if the stock went to zero. The breakeven is:
Breakeven = Strike B − Max Profit per Share
Or equivalently:
Breakeven = Strike B − (Strike A − Strike B) + Net Debit per Share
Detailed P&L Example
Setup: Stock trading at $225. Buy 1 AAPL 220 put for $8.00. Sell 2 AAPL 200 puts for $3.00 each.
- Net debit: $8.00 − (2 × $3.00) = $2.00 per share ($200 total)
- Max profit: ($220 − $200) × 100 − $200 = $1,800
- Breakeven: $200 − $18 = $182
| Stock Price | Long 220 Put Value | 2x Short 200 Put Value | Net P&L |
|---|---|---|---|
| $230 | $0 | $0 | -$200 |
| $220 | $0 | $0 | -$200 |
| $210 | $1,000 | $0 | +$800 |
| $200 | $2,000 | $0 | +$1,800 |
| $190 | $3,000 | -$2,000 | +$800 |
| $182 | $3,800 | -$3,600 | $0 (breakeven) |
| $170 | $5,000 | -$6,000 | -$1,200 |
| $150 | $7,000 | -$10,000 | -$3,200 |
| $0 | $22,000 | -$40,000 | -$18,200 (max loss) |
Greeks Analysis for the Put Ratio Spread
Understanding the Greeks helps you manage the position throughout its life, not just at expiration.
Delta
The put ratio spread starts with a slightly negative to neutral Delta (depending on strike selection). As the stock approaches Strike B, Delta becomes increasingly negative — meaning the position gains value as the stock drops. Below Strike B, the position's effective Delta reverses to positive (losses accelerate as the stock drops further because the two short puts overwhelm the one long put).
Theta (Time Decay)
Theta generally works in your favor with a put ratio spread because you are net short options (2 sold vs. 1 bought). Time decay erodes the value of the short puts faster than the long put, assuming the stock is near or between the strikes.
However, if the stock drops well below Strike B, Theta becomes less helpful as the short puts gain significant intrinsic value.
Vega (Volatility Sensitivity)
The put ratio spread has a negative Vega position. Rising implied volatility hurts the position (because you are net short options), while falling implied volatility helps it.
Implication: This strategy works best in high-volatility environments where you expect volatility to decline — or at least not increase dramatically.
Gamma
Near expiration, Gamma becomes a significant risk. If the stock is near Strike B, small price changes can dramatically swing the P&L. This is especially dangerous in the last week before expiration.
Greeks Summary Table
| Greek | Direction | Best Scenario | Worst Scenario |
|---|---|---|---|
| Delta | Slightly negative initially | Stock drops to Strike B | Stock crashes far below B |
| Theta | Positive (net short options) | Time passes near Strike B | Deep ITM short puts |
| Vega | Negative | IV decreasing | IV spiking |
| Gamma | Variable | Stock stable near B | Stock at B near expiration |
Setting Up the Put Ratio Spread in Excel
Step 1: Pull the Option Chain
=QM_GetOptionChain("AAPL")
Formula documentation: QM_GetOptionChain
Review available strikes and expirations. Select an expiration 30-60 days out for optimal theta decay.
Step 2: Select Your Strikes
Choose the higher strike (A) at-the-money or slightly out-of-the-money, and the lower strike (B) at your expected support level or target decline zone.
=OptionSymbol("AAPL", "2026-03-20", "P", 220) ' Long put
=OptionSymbol("AAPL", "2026-03-20", "P", 200) ' Short puts
Formula documentation: OptionSymbol
Step 3: Get Current Prices and Greeks
=QM_Last("@AAPL 260320P00220000") ' Long put price
=QM_Last("@AAPL 260320P00200000") ' Short put price
Formula documentation: QM_Last
For comprehensive Greeks on all options:
=QM_GetOptionQuotesAndGreeks("AAPL")
Formula documentation: QM_GetOptionQuotesAndGreeks
Step 4: Build the P&L Table
Create a column of stock prices at expiration (from well below Strike B to above Strike A) and calculate the P&L for each scenario:
=MAX(0, StrikeA - StockPrice) - 2*MAX(0, StrikeB - StockPrice) - NetDebit
Multiply by 100 for dollar P&L per contract.
Step 5: Monitor Position Greeks
Recalculate position Greeks daily by pulling updated option prices and Greeks from the option chain. Track Delta, Theta, and Vega to determine when adjustments are needed.
Risk Management Strategies
The put ratio spread's large downside risk makes risk management critical. Three common approaches:
Strategy 1: Stop-Loss on the Underlying
Set a stop-loss exit trigger at or near the breakeven price. If the stock drops to your calculated breakeven, close the entire position.
Example: With a breakeven at $182, set a mental or automated alert at $185 (just above breakeven) to close the position before losses accelerate.
Strategy 2: Buy a Protective Put (Convert to Butterfly)
If the stock approaches the lower strike and you are concerned about continued decline, buy an additional put at a strike below B to cap the downside:
Before adjustment: Buy 1 × 220P, Sell 2 × 200P (put ratio spread, large downside risk)
After adjustment: Buy 1 × 220P, Sell 2 × 200P, Buy 1 × 180P (put butterfly — capped risk)
The additional put costs premium but converts the position into a defined-risk butterfly with a much smaller maximum loss.
Strategy 3: Roll the Short Puts Down
If the stock drops below Strike B, roll the two short puts to a lower strike by buying them back and selling two new puts at a lower price. This pushes the breakeven lower and gives the trade more room.
Strategy 4: Time-Based Exit
Set a maximum holding period (e.g., close the position with 7-10 days until expiration regardless of where the stock is). This avoids the dangerous Gamma acceleration that occurs in the final days before expiration.
Strategy 5: Partial Position Closure
If you reach a significant portion of maximum profit (e.g., 50-75%), close the position early rather than waiting for the stock to land exactly at Strike B at expiration.
When to Use the Put Ratio Spread
| Market Outlook | Suitability | Why |
|---|---|---|
| Moderately bearish | ✅ Ideal | Maximum profit at the short strike — moderate decline |
| Strongly bearish | ❌ Avoid | Large losses below breakeven |
| Neutral to slightly bearish | ✅ Good | Low cost or credit entry, profits from modest decline |
| Bullish | ❌ Avoid | Both legs lose value; limited loss but still a loss |
| High IV, expecting decline | ✅ Excellent | Negative Vega benefits from IV contraction |
| Low IV, expecting volatility increase | ❌ Avoid | Rising IV hurts the net-short position |
Comparison: Put Ratio Spread vs. Similar Strategies
| Strategy | Risk | Reward | Cost | Best For |
|---|---|---|---|---|
| Put Ratio Spread (1:2) | Large (up to stock at zero) | Limited (at short strike) | Low / credit | Moderate decline + IV contraction |
| Bear Put Spread | Limited (defined) | Limited | Net debit | Confident bearish view with defined risk |
| Long Put | Limited (premium paid) | Substantial (to zero) | Full premium | Strong bearish conviction |
| Put Butterfly | Limited (defined) | Limited (at middle strike) | Low | Precise target price expectation |
| Put Ratio Backspread (2:1) | Limited | Large downside profit (up to stock at zero) | Net credit/small debit | Expecting large downward move |
| Short Straddle | Unlimited above, large below | Limited (premium) | Credit | Expecting very low volatility |
Variations of the Put Ratio Spread
1:3 Put Ratio Spread
Buy 1 put at Strike A, sell 3 puts at Strike B. This increases the initial credit (or reduces the debit) but increases the downside risk further. Use this only when you are highly confident the stock will not crash.
Skip-Strike Put Ratio Spread
Instead of consecutive strikes, use strikes with a wider gap. For example, buy the 220 put and sell two 190 puts. This widens the profit zone but moves the maximum profit point further from the current price.
Calendar Put Ratio Spread
Buy a longer-dated put at Strike A and sell two shorter-dated puts at Strike B. This adds a time dimension — the short puts decay faster, potentially allowing you to roll into a new short position after the first expiration.
Pricing and Options Analysis Tools
MarketXLS provides comprehensive options analysis functions as part of its Excel add-in. To access =QM_GetOptionChain(), =OptionSymbol(), =QM_Last(), =QM_GetOptionQuotesAndGreeks(), and the full library of 1000+ functions, visit the MarketXLS pricing page to choose the plan that fits your options trading needs.
Frequently Asked Questions
What is the maximum profit on a put ratio spread?
Maximum profit occurs when the stock price equals the short strike at expiration. The formula is: Max Profit = (Long Strike − Short Strike) × 100 − Net Debit Paid. If you entered for a net credit, add the credit to the intrinsic value spread.
Is the put ratio spread a good strategy for beginners?
The put ratio spread is generally not recommended for beginners because of its large downside risk. It requires active monitoring and the ability to implement risk management adjustments. Beginners should consider defined-risk alternatives like bear put spreads or put butterflies before attempting ratio spreads.
How do I choose the right strikes for a put ratio spread?
Select the long put (Strike A) at-the-money or slightly out-of-the-money. Select the short put (Strike B) at a price level you believe will act as support — a level you expect the stock to reach but not fall below significantly. Technical analysis levels, moving averages, and Fibonacci retracement levels can help identify appropriate short strikes.
What happens if the stock drops far below the short strike?
If the stock drops well below the short strike, the two short puts generate losses that overwhelm the gains from the single long put. Losses increase approximately dollar-for-dollar below the breakeven price, limited only by the stock's fall to zero. This is why risk management (stop-losses, converting to a butterfly, or rolling) is essential.
How does implied volatility affect the put ratio spread?
Since the put ratio spread is net short options, it has negative Vega. Rising implied volatility increases the value of the short puts more than the long put, hurting the position. Conversely, declining implied volatility benefits the position. This strategy works best when you expect volatility to stay flat or decrease.
Can I adjust a put ratio spread if the trade goes against me?
Yes. Common adjustments include: (1) buying an additional put below Strike B to convert to a butterfly and cap downside risk, (2) rolling the short puts to lower strikes to widen the profit zone, (3) closing the entire position at a predetermined loss level, or (4) closing the short puts and keeping the long put if you become strongly bearish.
Conclusion
The put ratio spread suits traders with a moderately bearish outlook who expect the stock to fall to a specific level but not far below it. By buying one put at a higher strike and selling two puts at a lower strike, the strategy can be entered at low cost or even a credit, with maximum profit achieved when the stock declines to the short strike at expiration.
The trade-off is large downside risk if the stock falls well below the short strike, which makes active risk management essential. Using MarketXLS options functions (=QM_GetOptionChain() to scan available options, =OptionSymbol() to build option symbols, =QM_Last() to price each leg, and =QM_GetOptionQuotesAndGreeks() to monitor Greeks), you can set up, analyze, and manage put ratio spreads entirely within Excel.
The strategy is best suited for experienced options traders who can monitor positions daily, have a clear thesis on the expected price range, and are prepared to implement adjustments when necessary.
Ready to analyze options strategies in Excel? Get started with MarketXLS and access option chains, Greeks, and the 1000+ function library for options analysis.
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. Options involve risk and are not suitable for all investors. The article is written for educational purposes only. Past performance does not guarantee future results.
