The short iron butterfly is the sniper's approach to options income—tighter profit zone, higher credit, maximum profit when the stock doesn't move an inch. Four legs centered at-the-money. Brutal to calculate in Excel. Here's how AI turns 45 minutes of formula hell into 30 seconds of conversation.
Andrew Grosser
February 17, 2026 • 14 min read
November 2023: AAPL is trading at $185.00. Earnings passed three weeks ago with no surprises. The next catalyst? Not for another 60 days. The stock has been glued to $185—closing within $2 of this price for fourteen straight sessions. Volume is declining, implied volatility sits at 32%, and every technical indicator screams consolidation. This is the textbook setup for a short iron butterfly—the precision income play that collects maximum premium when price refuses to budge from center strike.
The short iron butterfly is like an iron condor's aggressive cousin. Instead of selling strikes away from the current price (out-of-the-money on both sides), you sell strikes at the current price—selling an at-the-money straddle—and protect it with wings. You're betting the stock stays frozen. Your profit zone is narrower, your credit is fatter, and your breakevens are tighter. Maximum profit happens at exactly one price: your center strike. Move $0.50 off center and you start bleeding profit.
Or you use Sourcetable. Try it free.
A short iron butterfly isn't one trade—it's four trades executed simultaneously. You're selling an at-the-money call and an at-the-money put (this forms a short straddle—the core of your position), then buying an out-of-the-money call and an out-of-the-money put as protection (these are your wings). Each leg has its own premium, its own delta, its own gamma exposure. The profit comes from collecting massive premium on expensive ATM options while paying small premiums for distant protective strikes.
Let's say AAPL is at $185. You structure a short iron butterfly like this:
Your net credit is $9.20 per share ($650 + $620 − $180 − $170 = $920 per contract). That's your maximum profit—but only if AAPL closes exactly at $185 at expiration. Your maximum loss is the wing width minus the credit: $10.00 − $9.20 = $0.80, or $80 per contract. Your breakevens are $175.80 on the downside (center strike minus credit) and $194.20 on the upside (center strike plus credit).
Compare this to an iron condor on the same underlying: same $10 wing width, but strikes at $175 put, $180 call, $190 call, $195 put might collect only $4.20 in credit with breakevens at $170.80 and $199.20. The short iron butterfly collects $9.20 versus $4.20—more than double the premium—but your profit zone is $18.40 wide versus $28.40 wide. You're trading probability for premium. High risk, high reward—if you believe the stock stays glued to $185.
Now here's where Excel becomes absolute torture:
That's six analytical workflows, each requiring formulas that break when you adjust strikes or expiration dates. And if you're comparing a short iron butterfly to an iron condor across five different tickers to decide which strategy fits current market conditions? Good luck maintaining formula integrity across 40 interconnected cells per position without a single copy-paste error.
Sourcetable doesn't eliminate the math—it eliminates the manual tedium of doing the math. Upload your options chain data (either manually or via API), and the AI handles everything else. You interact with your short iron butterfly analysis the same way you'd brief a junior analyst: ask questions in plain English and get instant, accurate answers with full context.
In Excel, you'd build a table with four rows (one per leg), columns for strike, type (call/put), bid, ask, position (long/short), then write a SUM formula accounting for debits (what you pay) and credits (what you collect). Change one strike and you need to manually update references. In Sourcetable, you upload your four legs and ask: "What's my net credit?"
The AI instantly returns $9.20 per share, recognizing that you're selling $6.50 + $6.20 and buying $1.80 + $1.70. No formulas. No manual updates. Change a wing strike from $195 to $200 and the credit recalculates automatically—now $10.40 because the protective call costs $0.80 instead of $1.80, adding $1.00 more net credit (but also increasing max loss).
Breakevens are algebraically simple: center strike minus credit for downside ($185 − $9.20 = $175.80), center strike plus credit for upside ($185 + $9.20 = $194.20). But when you're managing seven butterflies with different wing widths, expirations, and underlyings, tracking breakevens manually across multiple spreadsheets invites catastrophic errors. Ask Sourcetable: "Show me my breakevens and max profit."
It returns: Breakevens: $175.80 (down) and $194.20 (up). Max profit: $920 at exactly $185.00. Your profit zone is $18.40 wide—a 9.9% cushion in either direction. But here's the brutal reality: you only achieve maximum profit if AAPL closes precisely at $185. At $183 or $187, you make less—maybe $600 of the $920 max. At $180 or $190, you're still profitable but capturing maybe $400. At $176 or $194, you're near breakeven. This precision requirement is why the AI's instant scenario modeling matters—you need to see the full P&L curve, not just max profit.
Professional traders use payoff diagrams to visualize risk profiles at a glance. For a short iron butterfly, the diagram shows a sharp, dramatic peak at the center strike—maximum profit at $185—then sloping losses in both directions until you hit max loss at the wings ($175 and $195). In Excel, generating this requires building a data table with stock prices from $170 to $200 in $0.50 increments, calculating P&L at each point using nested IF statements (if price < $175, max loss; if price between $175 and $185, calculate slope; etc.), then formatting a scatter plot with proper axis labels and formatting. It takes 25 minutes if you know what you're doing.
In Sourcetable, ask: "Show my risk graph." The AI generates a publication-quality payoff diagram in seconds. You see the sharp peak at $185, the linear slopes down to breakevens at $175.80 and $194.20, and the flat max losses of $80 beyond the wings at $175 and $195. Adjust a wing width from $10 to $15 and the graph updates instantly—compare narrow $10 wings (high credit, tight profit zone) against wide $15 wings (lower credit, wider profit zone but higher max loss) to see how premium and risk change together in real-time.
Here's the harsh truth about short iron butterflies: the stock almost never closes exactly at your center strike. If AAPL is at $185 with 30 days to expiration and 32% implied volatility, the probability of closing within $0.50 of $185 (so $184.50-$185.50) is only about 5%. The probability of staying between your breakevens ($175.80-$194.20) might be 62%, but you won't collect max profit—you'll collect partial profit, typically 40-70% of max depending on where price lands.
Ask Sourcetable: "What's my probability of max profit versus any profit?" It pulls current IV from your options chain, calculates the expected distribution using lognormal probability models, and returns: Probability of max profit (exactly $185): 5%. Probability of staying in profit zone ($175.80-$194.20): 62%. Expected profit: $540. That last number is crucial—your expected profit accounting for probability distribution is $540, not the $920 max. This expected value calculation requires integral calculus and probability density functions in Excel. Sourcetable does it conversationally, giving you the real risk-adjusted return.
Short iron butterflies are positive theta positions—you profit from time decay every single day. As expiration approaches, the ATM options you sold decay faster than the OTM wings you bought, putting money in your pocket daily. But they're also negative gamma positions—as the stock moves away from $185, your losses accelerate exponentially. This creates tension: you want time to pass (theta working for you), but you don't want the stock to move (gamma working against you).
Ask Sourcetable: "Show my daily theta and gamma risk." It returns: Position theta: +$38 per day. Position gamma: -0.24. With 30 days to expiration, you're collecting $38 of time decay daily if AAPL stays at $185—that's $1,140 over 30 days, more than your $920 max profit (the extra comes from being able to close early at 80-90% profit and avoiding gamma risk near expiration). But that -0.24 gamma means if AAPL moves $1 to $186, your delta changes by 0.24, accelerating losses. Near expiration, gamma explodes—at 3 days to expiration, gamma might be -0.75, making even $0.50 moves devastating to your P&L.
Sourcetable tracks this dynamically. Ask: "Alert me if gamma risk exceeds -0.50." The AI monitors your position continuously and flags when you enter gamma danger zone, suggesting: "Gamma risk now -0.54. Consider closing—you've captured $710 of $920 max profit with 4 days remaining. Further time decay ($152) isn't worth the gamma explosion risk. Close now and redeploy capital into new butterflies with 30 DTE." This kind of contextual guidance separates systematic traders from those who blow up accounts holding into expiration week.
Both strategies profit from range-bound markets, but they have dramatically different risk-reward profiles and optimal conditions. Understanding when to deploy which strategy separates consistent traders who compound returns from those who constantly second-guess their entries and exit too early or too late.
Implied Volatility Is Elevated: When IV is in the 70th-90th percentile for the underlying, ATM premiums are fat and juicy. You collect $9-10 per contract on a $10 butterfly versus $3-4 on an iron condor with the same wing width. High IV means higher credit, making the tighter profit zone worthwhile—you're getting paid enough to accept precision requirements.
Stock Is Pinned at a Technical Level: When price is magnetically stuck at a round number ($100, $150, $200, $250), major moving average (50-day, 200-day), or key support/resistance that's held for weeks. Market makers cluster massive orders at these levels, creating price gravity that makes breakouts difficult.
Post-Earnings Consolidation: After earnings, stocks often trade in tight ranges for 2-4 weeks while the market digests results and recalibrates expectations. Volatility stays elevated (IV doesn't collapse immediately) but price action is muted—the perfect combination for butterflies.
You're Managing Actively: Butterflies require daily monitoring and tighter risk management. If you can check positions at open, mid-day, and close, and you're comfortable adjusting quickly when price threatens breakevens, the higher premium justifies the narrower profit zone and gamma risk.
You Want Wider Breakevens: Iron condors give you breathing room—typically 15-25% cushion versus 8-12% for butterflies. If you believe the stock stays range-bound but aren't confident about the exact price level, condors let you collect decent premium with wider profit zones and lower stress.
Volatility Is Normal: When IV is in the 40th-60th percentile, ATM premiums aren't attractive enough to justify butterfly tightness and gamma risk. Condors still collect reasonable credit (40-45% of width) with better probability of profit and less active management required.
You're Managing Multiple Positions: Condors are more forgiving and require less babysitting. You can deploy 12 iron condors across different underlyings and check them 2-3 times per week. Butterflies demand daily attention, especially in the final 10 days before expiration when gamma risk accelerates.
You're Building an Income Portfolio: For consistent monthly income strategies with minimal drawdowns, condors offer better risk-adjusted returns over time because they win more often (65-75% win rate vs 55-65% for butterflies), even though individual wins are smaller in dollar terms.
Sourcetable makes this decision quantitative instead of emotional. Ask: "Compare short iron butterfly versus iron condor on AAPL. Show credit, breakevens, probability of profit, expected return, and required monitoring level." The AI calculates both strategies side-by-side using current market data and might show: "Butterfly: $9.20 credit, 62% win rate, $540 expected profit, daily monitoring required. Condor: $4.20 credit, 72% win rate, $300 expected profit, 2-3x weekly monitoring sufficient. Butterfly offers 80% higher expected return but requires 3x more monitoring time. Recommend butterfly if you can monitor daily and IV rank is above 70; condor if weekly monitoring or IV rank is 50-70."
Short iron butterflies aren't set-and-forget positions. The tight profit zone, massive gamma risk near expiration, and precision requirements mean you need disciplined adjustment and closing rules. Professional traders follow systematic management protocols to capture consistent profits without letting small adverse moves turn into max losses or blown-up accounts.
Most professional traders close butterflies when they've captured 60-80% of maximum profit. If you collected $9.20 and the position is now worth -$1.84 (meaning you'd pay $1.84 to close all four legs), you've captured $7.36 of credit, or 80% of max profit. This is the sweet spot for closing—you've extracted most of the juice, and the remaining 20% takes exponentially more time and exposes you to exponentially more gamma risk than it's worth. Why not hold for 100%? Because that last $1.84 might require holding through the final 5 days when gamma is explosive.
Sourcetable tracks this automatically across all positions. Ask: "Which of my butterflies have captured 70% of max profit?" The AI scans all active positions and flags: "AAPL butterfly has captured 72% ($662 of $920 max) with 11 days remaining. Current price: $186.20. Position delta: -28. Recommendation: Close now. You're $1.20 off center with gamma risk increasing exponentially as expiration approaches. Lock in $662 and redeploy capital into fresh butterflies with 30-35 DTE."
Say AAPL rallies from $185 to $189—halfway between your center strike ($185) and upper breakeven ($194.20). You're still profitable on paper, but your profit is declining and gamma risk is building. Ask Sourcetable: "Should I close, hold, or adjust?" The AI calculates several scenarios with full context:
Close now: Lock in $380 profit (41% of max). Eliminate all risk. Free $8,000 in buying power for new positions. Win rate: 100% (guaranteed by closing).
Hold: If AAPL returns to $185, recover to full $920 profit potential. If it continues to $194+, face max loss of $80. Theta: +$32/day working for you. Gamma: -0.28 working against you. Risk/reward: asymmetric—more downside risk than upside potential from current price level.
Adjust: Roll the untested put side down (convert $175 put to $179 put), collecting extra credit ($1.80 net) and reducing max loss while widening lower breakeven. Costs transaction fees but improves risk profile if you believe upward bias continues.
The AI might recommend: "Close now. At $189, you're 79% of the way to upper breakeven with 7 days remaining. Gamma risk (-0.28 and rising) outweighs remaining theta benefit (+$32/day = $224 total). The probability of AAPL returning to $185 for max profit is 12%. Lock in $380 profit (41% return on $920 risk in 23 days = 652% annualized) and redeploy capital into a new MSFT butterfly with 32 DTE and better risk/reward." This kind of contextual, probability-weighted guidance—factoring in time remaining, Greeks, alternatives, and opportunity cost—is what separates AI analysis from static Excel formulas that just show you math without strategic recommendations.
At 7-10 days to expiration, gamma risk escalates dramatically and non-linearly. A $1 move that would've cost you $60 in losses at 30 days might cost you $180 at 5 days—3x worse for the same price move. This is why most professionals close butterflies with 7-10 days remaining, even if they haven't captured full profit. Holding into expiration week chasing the last $150 of premium can easily turn into a $920 wipeout (going from max profit to max loss) from a single $3 gap move on unexpected news.
Sourcetable alerts you proactively before gamma becomes a problem. Set a rule once: "Alert me when any butterfly reaches 10 days to expiration or gamma exceeds -0.45." The AI monitors all positions continuously and sends targeted alerts: "AAPL butterfly expires in 9 days. Current profit: $640 (70% of max). Gamma: -0.42 and rising toward danger zone. Price: $184.10 (just $0.90 from center). Recommend closing by end of week. If you hold through next week, gamma will exceed -0.70, making even $1 moves potentially devastating. Close now and capture 70%, or set stop loss at $400 profit if you prefer to hold one more theta cycle." No more forgetting positions and discovering max losses at 9:31am on expiration Friday.
A single short iron butterfly is a trade—one isolated bet on one stock staying pinned. Five to eight butterflies per month across different underlyings with staggered expirations is a system—a repeatable, scalable process. The goal: generate $2,000-$4,000 monthly in premium income by systematically cycling through high-probability setups with disciplined entry, management, and exit rules. Here's how professionals structure it.
IV Rank Above 65: Only sell butterflies when implied volatility is elevated relative to historical norms. IV rank measures where current IV sits in its 52-week range (not absolute level). Above 65 means premiums are attractive relative to typical pricing for that specific underlying. This filters out low-premium environments automatically.
Liquid Underlyings Only: Stick to SPY, QQQ, IWM, and highly liquid mega-cap stocks (AAPL, MSFT, TSLA, NVDA, AMZN, GOOGL, META). You need tight bid-ask spreads—slippage on four legs adds up fast. A $0.10 slippage per leg = $0.40 total = $40 per contract = 4.3% of your $920 credit gone to friction.
Price Consolidation Pattern: Look for stocks trading in tight 3-5% ranges for at least 2 weeks with declining volume. Use Bollinger Bands (look for band squeeze), ATR (look for ATR compression below 20th percentile), or simple range analysis. When volatility indicators contract while IV stays elevated, you have the perfect storm for butterflies.
30-45 Days to Expiration: This is the Goldilocks zone for butterflies. Enough time to collect substantial theta without suffering from early gamma risk (<20 DTE). The theta/gamma ratio is optimal in this window—you're collecting meaningful daily decay while gamma is still manageable.
Sourcetable automates this entire scanning process. Connect your watchlist (or use a broad index) and ask: "Which stocks have IV rank above 65, are trading in a 3% range over 2 weeks with declining volume, and have liquid options expiring in 30-45 days?" The AI scans 100+ tickers against all four criteria and returns: "7 candidates meet all criteria: AAPL (IV rank 72, range 2.6%, avg volume down 18%), MSFT (IV rank 68, range 3.1%, avg volume down 12%), GOOGL (IV rank 71, range 2.8%, avg volume down 22%), META (IV rank 74, range 2.9%, avg volume down 15%), NVDA (IV rank 79, range 3.2%, avg volume down 25%), JPM (IV rank 67, range 2.7%, avg volume down 19%), XOM (IV rank 66, range 2.4%, avg volume down 14%)." Instant opportunity filtering without spending 90 minutes doing manual chart review and volatility analysis.
Risk no more than 2-3% of your portfolio on any single butterfly. A $50,000 account should risk $1,000-$1,500 per position maximum. If your max loss is $80 per contract (using our AAPL example with $10 wings and $9.20 credit), you can trade 12-18 contracts per position. But don't forget: butterflies rarely hit max loss unless you completely mismanage them—your real risk is giving back 50-70% of credit if you hold too long and price moves against you. Spread risk across 6-10 different underlyings so no single position dominates your P&L or ties up all your buying power.
Sourcetable calculates position sizing automatically with full context. Tell it: "I have $50,000 total capital and want 2.5% risk per butterfly. How many contracts can I trade on AAPL with $10 wings?" The AI calculates: "Max risk per position: $1,250 (2.5% of $50,000). AAPL butterfly max loss: $80 per contract ($10 width - $9.20 credit). You can trade up to 15 contracts (max risk $1,200). Recommend 12-13 contracts to leave buffer for slippage ($0.05-0.10 per leg common) and early exit scenarios. Margin requirement: approximately $8,000 (varies by broker). You have sufficient buying power."
Professional butterfly traders follow a systematic rhythm that becomes mechanical over time. At the start of each monthly options cycle (first week of the month for standard monthlies), scan for 6-10 new butterflies across different underlyings meeting your criteria with 30-45 DTE. As positions approach 60-80% of max profit or 7-10 days to expiration (whichever comes first), close them and immediately redeploy freed capital into new butterflies for the next cycle. This creates a perpetual income machine with defined risk, consistent returns, and no directional bias.
Sourcetable orchestrates this entire cycle automatically. Ask: "Show me my butterfly pipeline: current positions with profit %, close criteria status, freed buying power from closing, and top candidates for new entries." The AI generates a comprehensive dashboard: "Active: 8 butterflies, average 16 days to expiration, 5 ready to close (hit 65%+ profit target). Total profit ready to capture: $3,680. Buying power after closing: $18,200. New candidates: 9 stocks meeting all criteria with 32-38 DTE. Recommend closing AAPL ($640 profit, 70%), MSFT ($580 profit, 68%), GOOGL ($710 profit, 75%), META ($620 profit, 72%), NVDA ($690 profit, 73%) this week. Opening new butterflies on JPM, XOM, CVX, BAC, and WFC next Monday after weekend theta decay. Expected monthly income from full cycle: $3,200-$3,800 based on 65% average profit capture rate."
The short iron butterfly is a precision neutral strategy that collects maximum premium when the stock stays pinned at the center strike. It involves four legs: selling an ATM call and ATM put (short straddle), then buying an OTM call and OTM put (wings) as protection.
Compared to iron condors, butterflies collect 2x+ the premium ($9.20 vs $4.20 in our example) but have tighter profit zones (9.9% vs 15.3% cushion). Use butterflies when IV is elevated (rank 65+) and the stock is pinned at a key technical level; use condors when you want wider breakevens and less active daily management.
Traditional Excel analysis requires tracking four option chains, calculating net credit, modeling probability of exact center-strike closes (5% chance), monitoring explosive gamma risk near expiration, and generating sharp-peaked payoff diagrams—a 45-minute process that needs constant manual updates whenever market conditions change.
Sourcetable turns short iron butterfly analysis into natural language questions: "What's my net credit?" → $9.20. "Show breakevens." → $175.80 and $194.20. "What's my probability of max profit versus any profit?" → 5% max, 62% any profit, $540 expected value. "Alert me when gamma exceeds -0.45." → Automatic monitoring with contextual recommendations.
Professional traders close butterflies at 60-80% of max profit or 7-10 days to expiration (whichever comes first) to avoid gamma risk explosions near expiration. A systematic approach with strict position selection criteria (IV rank 65+, liquid underlyings, 30-45 DTE, tight consolidation patterns) and disciplined management generates $2,000-$4,000 monthly income from 6-10 concurrent positions with defined risk and high win rates (60-70%).
If your question is not covered here, you can contact our team.
Contact Us