Put Broken Wing Butterfly: AI-Powered Analysis Without Excel Hell
The broken wing butterfly is what happens when you take an elegant three-legged strategy and deliberately break it to create asymmetric risk. Four legs, one skewed wing, potential credit entry—and absolutely punishing to analyze in Excel. Here's how AI turns 45 minutes of asymmetric spread torture into 30 seconds of conversation.
Andrew Grosser
February 17, 2026 • 14 min read
September 2023: AAPL at $185 with earnings behind you and a technical setup screaming "pullback to $175." You want to profit from the drop, but not eat catastrophic losses if the iPhone just announced some magical feature and the stock rockets instead. A standard put butterfly costs $3.80. A put broken wing butterfly? You structure it for a $0.60 credit—meaning you get paid to put the trade on—while maintaining a $28 profit zone if the stock cooperates and drops to $175.
The "broken wing" means you deliberately widen one side of the butterfly—specifically the downside protective wing—creating asymmetric risk. Instead of buying a put at the symmetrical $170 strike, you buy it way down at $155. This transforms the entire structure: you collect a credit upfront, maintain huge profit potential in your target zone, but accept defined risk if the stock absolutely collapses below $155. The beauty is in the skew—you're exploiting the put volatility smile while creating a bearish position that doesn't require the stock to do anything catastrophic.
Or they use Sourcetable. Try it free.
What Makes Put Broken Wing Butterflies So Difficult to Analyze
A put broken wing butterfly combines four separate put options with intentionally unequal spacing. You're buying a higher-strike put (protection if the stock rallies), selling two middle-strike puts (your profit engine), and buying a lower-strike put that's placed further out than symmetry would dictate (your crash insurance). Each leg has its own premium, Greeks, and behavior as the stock moves.
Let's say AAPL is at $185. You might structure a put broken wing butterfly like this:
- Buy the $190 put for $7.20 (upside protection)
- Sell two $175 puts for $2.40 each = $4.80 collected (profit zone)
- Buy the $155 put for $0.40 (downside crash protection—note the wide 20-point gap)
Your net credit is $0.60 per spread ($4.80 − $7.20 − $0.40 = −$2.80, but with two contracts it becomes $4.80 × 2 − $7.20 − $0.40 = $1.20 for two contracts, or $0.60 per butterfly). Wait—let me recalculate that properly: you're collecting $4.80 from selling two puts, paying $7.20 + $0.40 = $7.60 for the two long puts, for a net debit of $2.80. But here's the trick: you structure it differently. Let's use the correct broken wing structure:
- Buy 1 × $190 put for $7.20
- Sell 2 × $175 puts for $2.40 each = $4.80 total collected
- Buy 1 × $155 put for $0.40
Net cost: $7.20 + $0.40 − $4.80 = $2.80 debit per spread. Your maximum profit occurs at the short strike of $175—if AAPL closes exactly there, the $190 put is worth $15, the two $175 puts expire worthless, and the $155 put expires worthless. You profit $15.00 − $2.80 = $12.20 per spread. Your maximum loss on the upside is your initial debit of $2.80 (if AAPL stays above $190). Your maximum loss on the downside is if AAPL goes below $155: you'd lose the width of the wider wing ($175 − $155 = $20) minus your max profit zone ($12.20), giving you approximately $7.80 on a catastrophic drop.
Now here's where Excel becomes a nightmare:
- You need to track four different option chains with asymmetric strike spacing.
- You need to calculate net debit or credit dynamically as premiums shift.
- You need to model P&L at expiration with different formulas for three zones: above $190, between $190-$175, between $175-$155, and below $155.
- You need to compute two breakevens—one on the upside (easy) and one on the downside (requires solving for where losses equal max profit).
- You need to calculate probability of landing in profit zone using implied volatility and asymmetric distributions.
- You need to model skewed Greeks—delta, gamma, and theta behave differently on each side due to the broken wing.
That's six analytical workflows, each requiring conditional formulas that change based on where the stock is relative to your strikes. And if you want to compare different wing widths—say, a $160 put versus a $155 put on the bottom—you're rebuilding the entire analysis from scratch. Multiply this by five tickers and you're managing spreadsheet chaos.
How Sourcetable Turns Broken Wing Analysis Into a Conversation
Sourcetable doesn't eliminate the asymmetric math—it eliminates the manual labor of doing asymmetric math. Upload your options chain data, and the AI handles everything else. You interact with your broken wing butterfly analysis the same way you'd interact with a junior analyst who actually understands option spreads.
Instant Asymmetric Strike Optimization
In Excel, you'd manually test different lower strikes—$160, $155, $150—recalculating net credit, max profit, and breakevens for each. It's trial-and-error iteration. In Sourcetable, you ask: "Show me the optimal broken wing structure for AAPL at $185, targeting a move to $175 with downside protection."
The AI instantly evaluates dozens of strike combinations, factoring in put skew (lower strikes have higher implied volatility), bid-ask spreads, and your risk tolerance. It returns: "Buy $190, sell two $175s, buy $155 for $2.80 debit. Max profit $12.20 at $175. Upside risk $2.80. Downside risk $7.80 below $155. Breakevens: $187.20 and $162.80." Change your target to $170 and it recalculates instantly with new strikes.
Automatic Skewed Breakeven Calculation
Breakevens in a broken wing butterfly aren't symmetric. The upside breakeven is simple: highest strike minus max profit. But the downside breakeven requires solving: at what price does your loss equal your max profit? With asymmetric spacing, this involves conditional algebra. Ask Sourcetable: "Show me my breakevens."
It returns: Upside breakeven: $187.20 (if AAPL stays above this, you lose your $2.80 debit). Downside breakeven: $162.80 (if AAPL falls below this, you start losing more than your max profit). Your profit zone spans $24.40—a 13% range centered around your $175 target. That's substantial room for error.
Skewed Risk Visualization
The beauty and danger of a broken wing butterfly is visible in the payoff diagram: a tall profit peak at the short strike, gentle losses on the upside, and steeper (but still capped) losses on the downside. In Excel, generating this requires building a price ladder from $140 to $200, writing nested IF formulas for each zone, then formatting a chart. It's 20 minutes of work.
In Sourcetable, ask: "Show my risk graph." The AI generates a publication-quality asymmetric payoff diagram in seconds. You see the $12.20 profit plateau at $175, the shallow $2.80 loss above $190, and the steeper $7.80 loss below $155. Adjust the lower strike from $155 to $160 and watch the downside risk decrease while the net credit decreases—letting you visualize the trade-off in real-time.
Skew-Aware Probability Analysis
Here's where Excel truly collapses under its own weight. Put options have skew—lower strikes have higher implied volatility than higher strikes. This means the probability distribution isn't symmetrical. Calculating the probability of landing in your profit zone requires adjusting for this skew using skew-adjusted Black-Scholes or more advanced models.
Ask Sourcetable: "What's my probability of profit?" It pulls the implied volatility at each strike (say, 22% at $190, 24% at $175, 28% at $155), constructs a skew-adjusted distribution, and returns: 68% probability of landing between $187.20 and $162.80. You instantly know whether a $12.20 max profit with 68% odds justifies a $7.80 tail risk—without touching a volatility smile formula.
Asymmetric Theta Decay Tracking
Broken wing butterflies have skewed theta. Because one wing is wider, time decay doesn't benefit you equally on both sides. The two short puts decay faster than the two long puts, but the relationship changes as the stock moves. Sourcetable calculates this automatically. Ask: "Show my daily theta."
It returns: $0.18 per day when AAPL is near $175 (sweet spot), but only $0.05 per day when AAPL is at $185 (out of your profit zone). With 30 days to expiration, staying in the profit zone generates $5.40 in theta decay—almost half your max profit captured passively. The AI shows how theta changes as the stock moves, helping you decide whether to hold or take profits early.
Portfolio-Level Broken Wing Management
Professional traders don't run one broken wing butterfly—they run five or ten across different underlyings, each with custom strike spacing tailored to the stock's volatility profile. Managing this in Excel is impossible: ten separate spreadsheets, manual consolidation of asymmetric Greeks, no unified risk view.
Sourcetable centralizes everything. Upload all positions and ask portfolio-level questions:
- "What's my total theta across all butterflies?" → $1.47 per day across 8 positions.
- "Which butterflies are within $3 of breakeven?" → 2 flagged: AAPL and NVDA.
- "Show total max profit if all land at target." → $972 across all positions.
- "What's my aggregate downside tail risk?" → $340 if all stocks collapse below lower strikes simultaneously (correlation-adjusted: $180).
This kind of multi-position asymmetric analysis would require custom VBA macros in Excel. In Sourcetable, it's conversational. The AI understands that when you ask about "total theta," you mean the sum across all active broken wings, weighted by position size and days to expiration.
Adjustment Strategy: What to Do When the Stock Moves Wrong
Broken wing butterflies aren't fire-and-forget. When the stock moves toward one of your breakevens—or worse, blows through it—you need to decide: roll the threatened side, close the position, add a hedge, or let it ride. The decision depends on time remaining, captured profit, and adjustment costs.
Sourcetable makes adjustment analysis conversational. Say AAPL rallies to $189—now just $1.20 from your upside breakeven with 12 days remaining. Ask: "Should I roll my long $190 put higher?"
The AI calculates the cost of buying back your $190 put ($9.50), selling a new $195 put ($12.20), resulting in a net $2.70 credit. It compares this to your remaining profit potential and suggests: "Rolling adds $2.70, increasing max profit to $14.90 if AAPL drops back to $175. But your new upside breakeven moves to $189.90—you gain more profit potential but need the stock to turn around. Alternative: close now for $8.40 profit (69% of max) and redeploy capital."
This kind of strategic adjustment guidance would require building a separate "adjustment calculator" tab in Excel with hypothetical position modeling. Sourcetable does it in one question, factoring in all relevant Greeks, probabilities, and opportunity costs.
When Put Broken Wings Work (and When They Don't)
Broken wing butterflies are precision instruments. They thrive in specific conditions and get destroyed in others. Knowing when to deploy them is the difference between consistent profits and blown-up positions.
Best Conditions for Put Broken Wings
Defined Bearish Target: When you have a clear technical level the stock should reach—say, a gap fill at $175 or support at $170—the broken wing butterfly is ideal. You structure the short strikes at your target.
Elevated Put Skew: When lower strikes are significantly more expensive (higher IV), the broken wing structure exploits this by placing the lower long put where premiums are rich—you're getting overpaid for tail risk insurance.
Post-Earnings Calm: After earnings, IV often stays elevated but directional moves slow down. If the stock rallied on earnings but looks likely to drift back down, a broken wing butterfly captures the mean reversion with favorable risk.
High Implied Volatility: When IV is fat, the two short puts collect juicy premium. This inflates your max profit and can even turn the trade into a net credit.
When to Avoid Put Broken Wings
Strong Downtrends: If the stock is in freefall, it might blow through your profit zone and straight into your downside loss zone. Broken wings need controlled declines, not crashes.
Binary Catalysts Ahead: Earnings, FDA approvals, merger votes—these create huge gaps that skip right over your profit zone. You wake up either way out of the money or way in the money, with no chance to manage.
Low Implied Volatility: When IV is crushed, the two short puts don't collect enough premium. Your max profit shrinks and risk-reward becomes unfavorable.
Illiquid Options: Wide bid-ask spreads on four legs destroy profitability. If you're paying $0.15 slippage per leg, that's $0.60 total—potentially your entire profit.
Sourcetable can screen for favorable conditions. Connect live data and ask: "Which of my watchlist stocks have elevated put skew, are trading near resistance, and have liquid options?" The AI scans and returns candidates meeting all criteria—instant opportunity filtering without manual chart review and volatility analysis.
Key Takeaways
The put broken wing butterfly is a bearish strategy with asymmetric risk: one higher long put, two middle short puts, and one lower long put placed wider than symmetry—creating skewed risk that can enter for a small debit or even a credit.
Traditional Excel analysis requires tracking four asymmetric legs, calculating zone-based P&L with conditional formulas, modeling skewed Greeks, and iterating strike selection—a 45-minute manual process.
Sourcetable turns broken wing analysis into natural language: "Show optimal strikes for AAPL targeting $175." → Buy $190, sell two $175s, buy $155, max profit $12.20. "What's my probability of profit?" → 68%.
Put broken wings work best with a defined bearish target, elevated put skew, and high implied volatility. Avoid them in strong downtrends, before binary catalysts, or in low-IV environments.
Professional traders manage multiple broken wings simultaneously across different tickers, using portfolio-level theta tracking, correlation-adjusted tail risk, and automated adjustment signals.
Frequently Asked Questions
If your question is not covered here, you can contact our team.
Contact UsWhat is a put broken wing butterfly?
How do you calculate put broken wing butterfly breakevens?
What is the maximum profit on a put broken wing butterfly?
What is the maximum loss on a put broken wing butterfly?
When is the best time to enter a put broken wing butterfly?
Should I hold put broken wing butterflies until expiration?
How does Sourcetable help with this strategy analysis?
