Ratio Put Spread Strategy: AI-Powered Analysis Without Excel Torture
The ratio put spread is options trading's asymmetric bet: limited risk above, maximum profit in the sweet spot, unlimited risk below. Three legs, two breakevens, one dangerous zone—and absolutely brutal to model in Excel. Here's how AI turns hours of Greek calculations into seconds of conversation.
Andrew Grosser
February 16, 2026 • 13 min read
November 2023: Tesla is trading at $245, down 8% from its highs but holding support around $240. You're moderately bearish—not expecting a crash, but you think gravity pulls it toward $230 over the next month. Buying puts outright costs $6.50 for the at-the-money strike. That's $650 per contract with unlimited upside but also $650 at risk if you're wrong. There's a smarter play: the ratio put spread.
Here's the setup: buy one $245 put for $6.50, sell two $235 puts at $3.00 each. Your net cost is $0.50 ($650 - $600 = $50 per spread). If Tesla drops to exactly $235 at expiration, your long put is worth $10 ($1,000) while your two short puts expire worthless. Net profit: $950 on a $50 investment—a 1,900% return. That's the sweet spot. The catch? Below $230, those two short puts start bleeding. Below $225, you're losing money faster than your long put gains. Below $220, you're underwater.
Or you use Sourcetable and analyze it in 30 seconds. Try it free.
Why Ratio Put Spreads Are Excel Nightmares
A ratio put spread has three legs with asymmetric ratios: one long put, two (or more) short puts at a lower strike. You're not just calculating net premium—you're modeling a position where profit accelerates in one direction, flattens out, then reverses catastrophically in another direction. The payoff diagram isn't linear. It's not even symmetric. It's a curve with a sharp inflection point that represents your maximum profit, followed by a downward slope that never stops.
Let's break down what you need to calculate in Excel:
- Net debit or credit – Are you paying to enter this trade or collecting premium?
- Maximum profit price – The exact strike where profit peaks (hint: it's the short strike)
- Maximum profit amount – The difference between strikes times 100, minus net debit
- Upper breakeven – Where the position breaks even on the upside
- Lower breakeven – Where unlimited losses begin (this is the critical number)
- P&L at every price point – Required for payoff diagrams
- Greeks for each leg – Delta, gamma, theta, vega—then aggregate them
- Probability of profit – Using implied volatility and standard deviations
That's eight separate calculations, each requiring different formulas. The P&L calculation alone requires a nested IF statement: =IF(S>K1, -NetDebit, IF(S>K2, (K1-S)*100-NetDebit, (K1-S)*100-2*(K2-S)*100-NetDebit)). Now multiply that across 50 price points for a payoff diagram. Then recalculate when you change the ratio from 1:2 to 1:3. Then adjust when option prices update mid-day.
And here's the kicker: ratio spreads have unlimited downside risk. You're naked short those extra puts below the lower breakeven. If Tesla gaps down to $200 overnight on earnings, you don't lose $500—you lose thousands. Calculating that max loss scenario, understanding your margin requirements, modeling worst-case stress tests—this is where Excel becomes genuinely dangerous. One mistake in your formulas and you're risking real capital based on bad math.
How Sourcetable Makes Ratio Put Spreads Simple
Sourcetable doesn't change the math—it changes who does the math. Upload your options chain (manually or via API), define your position, and let the AI handle every calculation. You interact with your ratio spread analysis the way you'd explain it to a colleague: by asking questions in plain English.
Instant Sweet Spot Identification
The "sweet spot" is where your ratio spread achieves maximum profit—always at the short strike price. But understanding what that maximum profit is requires accounting for the net debit, the spread width, and the ratio. Ask Sourcetable: "What's my maximum profit on this TSLA ratio spread?"
It returns: $950 at $235. The AI recognizes your 1:2 ratio, calculates that your long $245 put is worth $1,000 at $235, your two short $235 puts are worthless, and subtracts your $50 net debit. Change the ratio to 1:3 and ask again—instant recalculation showing $1,900 max profit (but also wider unlimited loss zone).
Automatic Danger Zone Calculation
The lower breakeven is your red line. Cross it and losses accelerate. In our Tesla example, you need to solve for where your long put gains equal your short put losses plus the original debit. That's algebra: (245-S) - 2*(235-S) = 0.50, which gives you $225.50. Below that price, you're losing money.
Ask Sourcetable: "Where does this position go negative?" It returns: $225.50 (lower breakeven). More importantly, ask: "What's my loss if TSLA drops to $220?" The AI instantly calculates: -$500 per spread. Ask: "What about $200?" → -$2,500 per spread. These stress scenarios are critical for position sizing, and Sourcetable runs them in real-time without building separate Excel tabs.
Risk Visualization With One Question
Professional traders need payoff diagrams to understand risk at a glance. Building one in Excel means creating a data table from $200-$270, writing that nested IF formula, copying it down 70 rows, then formatting a chart. It's 20 minutes of work.
In Sourcetable, ask: "Show my risk profile." The AI generates a publication-quality diagram in seconds: flat zone above $245 showing your $50 loss, profit curve rising to $950 at $235, then a red danger zone sloping downward infinitely below $225.50. Your current position (TSLA at $245) is marked clearly. Adjust your strikes or ratio and the graph updates instantly—letting you compare 1:2 versus 1:3 strategies side-by-side.
Greeks Aggregation Across Asymmetric Legs
Here's where Excel truly collapses. Your long put has delta -0.50. Each short put has delta -0.45. But you have two short puts, so your net delta is: -0.50 + 2*(0.45) = +0.40. You're actually long delta despite being in a bearish trade. This is counterintuitive and critical for risk management—if Tesla rallies, you make money on delta even though your theta decays.
Ask Sourcetable: "What's my net delta?" → +0.40 (slightly bullish exposure). Ask: "What's my theta?" → -$12 per day (you're paying for time decay). The AI aggregates Greeks across all legs automatically, accounting for the asymmetric ratio. Change from 1:2 to 1:3 and watch delta flip to +0.85—now you're very long delta, which means you actually want the stock to rally slightly even though you're betting on downside.
Probability Analysis Using Live IV
The most important question: What's the probability Tesla stays above my lower breakeven? Calculating this requires pulling implied volatility from your options chain, converting it to daily standard deviation, then using a lognormal distribution to estimate the probability of Tesla staying above $225.50 in 30 days. That's Black-Scholes territory.
Ask Sourcetable: "What's my probability of staying profitable?" It pulls current IV (say, 52% annualized for TSLA), runs the distribution, and returns: 78% probability of staying above $225.50. You instantly know your odds—without touching a single formula. Now you can size your position appropriately: 78% win rate with $950 max profit versus 22% risk of unlimited losses.
When to Use Ratio Put Spreads (and When to Run)
Ratio put spreads are not neutral income strategies like iron condors. They're directional bets with a specific price target. Use them when you have conviction about moderate downside but strong confidence that catastrophic drops won't happen. Here's when they work—and when they blow up.
Perfect Setups for Ratio Put Spreads
Moderate Bearish Outlook: You expect a 5-10% decline, not a 30% crash. You have a specific price target where you think the stock will land.
Strong Support Below: There's a technical or fundamental floor you believe won't break. If Tesla has support at $230 and you're selling $235 puts, you're betting that support holds.
High Implied Volatility: When IV is elevated, put premiums are fat. Selling two puts for $6.00 total while buying one for $6.50 creates a nearly free trade with massive upside if you're right.
After Overextended Rallies: A stock runs up 20% in two weeks, sits above all moving averages, shows exhaustion. You expect pullback to the mean, not collapse through the mean.
When Ratio Put Spreads Kill Accounts
Before Earnings: Binary events create gap risk. Tesla reports weak delivery numbers and opens at $210. Your $950 max profit turns into a $2,000 loss instantly.
During Market Panics: Ratio spreads get obliterated in flash crashes. March 2020, SPY dropped 12% in one day. Ratio spreads with "safe" downside breakevens got run over by tanks.
On Weak Stocks: Never use ratio spreads on stocks with deteriorating fundamentals. If the company actually is going to zero, your "unlimited loss zone" becomes unlimited actual losses.
Without Monitoring: Ratio spreads aren't set-and-forget. If price approaches your lower breakeven, you need to adjust or close. Going on vacation with ratio spreads is financial Russian roulette.
Sourcetable can help you avoid disasters. Set alerts: "Notify me if TSLA drops within $3 of my lower breakeven." The AI monitors continuously and warns you when risk escalates. Ask: "What's my max loss if TSLA gaps down 20% overnight?" The AI runs the stress test instantly, showing you exactly how much capital you could lose. This kind of risk awareness prevents the account-destroying mistakes that ratio spreads are famous for.
Managing Ratio Put Spreads: The Decision Tree
Opening a ratio spread is the easy part. Managing it as price moves is where amateurs lose money and professionals make money. Here's how to navigate the three scenarios you'll face.
Scenario 1: Stock Drops Into Your Sweet Spot
Tesla drops from $245 to $237 over two weeks. You're now close to maximum profit. Ask Sourcetable: "What's my current P&L?" It returns: +$680 unrealized with 15 days remaining. You've captured 72% of the $950 max profit. Now the question: hold for the last $270 or close and lock gains?
Ask: "What's my risk-reward if I hold?" The AI analyzes: "Potential gain: $270. Potential loss if TSLA drops below $225.50: unlimited. Probability of drop below $225.50 in 15 days: 18%. Recommendation: Close now—you're risking significant downside for minimal upside." This kind of probabilistic decision support prevents the classic mistake of holding for max profit and watching the position blow up.
Scenario 2: Stock Doesn't Move
Tesla trades sideways at $243 for three weeks. Your ratio spread is bleeding theta—you're paying $12/day for time decay because you bought one put and sold two. Ask Sourcetable: "Should I close this position?"
The AI calculates: "Current loss: -$180. Maximum profit requires $8 move down with 7 days remaining. Implied volatility has dropped 8 points since entry, reducing probability of reaching $235 to 32%. Recommendation: Close and redeploy capital—this trade isn't working." Taking small losses on ratio spreads that aren't working is critical. The unlimited downside risk means you can't afford to "hope" it works out.
Scenario 3: Stock Drops Through Your Breakeven
This is the nightmare. Tesla reports bad news and gaps to $222. You're now below your $225.50 lower breakeven. Every dollar Tesla drops costs you $100 per spread. Ask Sourcetable: "What's my loss and what are my options?"
The AI responds: "Current loss: -$300 per spread. Options: 1) Close immediately—lock in $300 loss and eliminate further risk. 2) Buy back one short $235 put for $1,300—converts to 1:1 put spread, caps max loss at $700 total. 3) Roll short puts down to $230—collects $400 credit, lowers breakeven to $221.50 but increases risk if TSLA continues falling."
This instant decision tree, with exact costs and risk implications, is what separates traders who survive ratio spreads from traders who blow up accounts. Sourcetable delivers it in seconds. Excel requires building an entire adjustment calculator—and by the time you finish, the opportunity to adjust has passed.
Portfolio Risk Management: The Ratio Spread Killer
Running one ratio put spread is manageable. Running five across different stocks is when risk compounds in non-obvious ways. The danger: correlated risk. If you have ratio spreads on TSLA, NVDA, AAPL, AMZN, and MSFT, you don't have five independent bets—you have five correlated bets on tech not crashing.
When tech sells off hard—say, a Fed surprise or regulatory news—all five positions hit their lower breakevens simultaneously. What looked like $4,750 in max profit ($950 × 5) becomes $10,000+ in losses overnight. This is how ratio spreads destroy portfolios.
Portfolio-Level Risk Aggregation in Sourcetable
Upload all your positions and ask: "What's my total exposure if tech drops 15%?" Sourcetable aggregates risk across all ratio spreads, recognizing correlation. It returns: -$12,500 aggregate loss if QQQ drops 15%. Now you know your real risk—not the $1,500 you thought from looking at individual positions.
Ask: "Which sector am I most exposed to?" The AI analyzes and responds: "82% of your ratio spread risk is in technology. One sector-wide selloff could trigger all positions simultaneously." This kind of correlation analysis requires Excel macros, correlation matrices, and sector mapping. Sourcetable delivers it conversationally.
Set portfolio-level alerts: "Warn me if aggregate ratio spread risk exceeds $5,000." As you add positions throughout the week, the AI tracks cumulative risk and alerts you when you're overexposed. This prevents the silent portfolio risk creep that kills accounts—where each individual trade looks fine but the portfolio is a ticking time bomb.
Real-World Use Case: Earnings Volatility Collapse
Netflix is trading at $485, reporting earnings in 5 days. Implied volatility is 110%—absolutely juiced. You believe earnings will be fine but not spectacular, and NFLX will drift down to around $470 as IV collapses. You want to profit from both the directional move and the volatility crush.
Standard play: buy puts. But at 110% IV, the $485 put costs $18—you need NFLX to drop below $467 just to break even. Instead, you ask Sourcetable: "Design a ratio put spread on NFLX targeting $470 with max profit from IV crush."
The AI scans the options chain and recommends: Buy one $485 put for $18, sell two $470 puts at $10.50 each. Net credit: $3. Maximum profit: $1,800 at $470. Lower breakeven: $461.50. The AI explains: "This spread collects $300 upfront and profits from both the expected drift to $470 and IV normalization. If NFLX hits $470 and IV drops to 45%, your profit is $1,800—capturing both directional and vega gains."
NFLX reports decent numbers, opens at $478, and drifts to $472 over the next two days. IV collapses to 48%. You ask: "What's my P&L?" Sourcetable returns: +$1,380 (77% of max profit). The AI suggests: "Close now—you've captured most gains and eliminated tail risk of NFLX continuing to fall below $461.50."
You close for a $1,380 profit on a $300 credit spread—a 460% return in one week. The key: Sourcetable handled the complex IV modeling, position optimization, and exit timing that would require hours of Excel work and deep options expertise.
Key Takeaways
The ratio put spread is an asymmetric bearish strategy: buy one put, sell two or more puts at a lower strike. You profit maximally when price lands at the short strike, but face unlimited losses below the lower breakeven.
Traditional Excel analysis requires modeling non-linear P&L, calculating two breakevens, aggregating Greeks across asymmetric legs, and stress-testing worst-case scenarios—a multi-hour process that needs constant updates.
Sourcetable turns ratio spread analysis into natural language questions: "What's my max profit?" → $950 at $235. "Where do losses begin?" → $225.50. "What if TSLA drops to $210?" → -$2,500 loss.
Ratio spreads work best with moderate bearish outlooks, high IV, and strong support below your short strikes. They get destroyed by earnings surprises, market panics, and correlation risk across multiple positions.
Professional management requires instant stress testing, real-time breakeven monitoring, and portfolio-level correlation analysis—all delivered conversationally in Sourcetable.
Frequently Asked Questions
If your question is not covered here, you can contact our team.
Contact UsWhat is a ratio put spread in options trading?
What is the maximum profit on a ratio put spread?
What is the risk in a ratio put spread?
How do you calculate breakevens for a ratio put spread?
When should you use a ratio put spread?
How do you manage a ratio put spread that's losing money?
How does Sourcetable help with this strategy analysis?
