Short Put Butterfly: AI-Powered Analysis Without Excel Hell
The short put butterfly is the call butterfly's mirror image—a neutral income setup that collects credit when the stock stays pinned to a target price. Three put strikes, defined risk, limited reward—and absolutely brutal to analyze in Excel. Here's how AI turns 30 minutes of spreadsheet torture into 30 seconds of conversation.
Andrew Grosser
February 16, 2026 • 12 min read
October 2023: AAPL is stuck at $180. It's been there for two weeks, bouncing between $178 and $182 with clockwork precision. Every options expiration, it closes right at $180. Dealers are pinning the stock, and you want to capitalize. Enter the short put butterfly—a three-leg credit spread that pays you to bet the stock stays exactly where it is.
The setup is simple: buy one put at $185 for $7.50, sell two puts at $180 for $5.00 each, buy one put at $175 for $3.00. Your net credit: $2.50 ($10.00 collected − $7.50 − $3.00 paid). That's $250 per contract in your pocket upfront. Your maximum profit? That same $250. Your maximum loss? $250 (the width of one wing minus the credit: $5.00 − $2.50 = $2.50). If AAPL closes at exactly $180 at expiration, you keep the full credit. If it moves too far in either direction—past $177.50 or $182.50—you hit max loss.
Or they use Sourcetable. Try it free.
What Makes Short Put Butterflies So Difficult to Analyze
A short put butterfly isn't a single trade—it's a position made of three simultaneous puts with a 1-2-1 ratio. You're buying an out-of-the-money put at the upper wing, selling two at-the-money puts at the body, and buying another out-of-the-money put at the lower wing. Each leg has its own premium, its own delta, its own gamma. The profit comes from collecting a net credit and hoping the stock stays glued to the body strike. The risk comes from the stock moving away from the body in either direction.
Let's say TSLA is at $250. You might structure a short put butterfly like this:
- Buy the $260 put for $13.50 (you pay premium for protection)
- Sell two $250 puts for $9.00 each (you collect premium × 2)
- Buy the $240 put for $5.50 (you pay premium for protection)
Your net credit is $1.00 per share ($18.00 − $13.50 − $5.50 = −$1.00, wait—this is a debit? No. Let's recalculate: $9.00 × 2 = $18.00 collected, minus $13.50 + $5.50 = $19.00 paid… that's a $1.00 net debit). Actually, this highlights the first Excel nightmare: tracking whether you have a credit or debit butterfly. If you collect more than you pay, it's a credit. If you pay more, it's a debit. Most short butterflies are entered for a credit when the stock is near the body strike and implied volatility is elevated.
Let's fix our example with higher premiums. TSLA at $250, IV at 65%:
- Buy the $260 put for $14.00
- Sell two $250 puts for $10.50 each (collect $21.00 total)
- Buy the $240 put for $6.00
Now your net credit is $1.00 per share ($21.00 − $14.00 − $6.00 = $1.00). That's your maximum profit—$100 per contract. Your maximum loss is the width of one wing minus the credit: $10.00 − $1.00 = $9.00, or $900 per contract. Your breakevens are $251.00 on the upside (body strike plus credit) and $249.00 on the downside (body strike minus credit). Profit zone: just $2 wide. That's a 0.8% margin for TSLA to stay pinned.
Now here's where Excel becomes a nightmare:
- You need to track three different put strikes with live pricing.
- You need to calculate net credit or debit dynamically as premiums change.
- You need to compute probability of staying at the body using implied volatility and standard deviations.
- You need to model P&L at expiration across a range of stock prices.
- You need to calculate pin risk and gamma exposure as expiration approaches.
- You need to generate payoff diagrams to visualize your narrow profit zone.
That's six separate analytical workflows, each requiring its own formulas and manual updates. And if you're managing five butterflies across different stocks? Multiply everything by five and pray you don't make a copy-paste error.
How Sourcetable Turns Short Put Butterfly Analysis Into a Conversation
Sourcetable doesn't eliminate the math—it eliminates the manual labor 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 put butterfly analysis the same way you'd interact with a junior analyst: by asking questions in plain English.
Instant Net Credit Calculation
In Excel, you'd build a table with three rows (one per leg), columns for strike, bid, ask, quantity (1-2-1 ratio), and position (long/short), then write a SUM formula to calculate net credit. In Sourcetable, you upload your three legs and ask: "What's my net credit?"
The AI instantly returns $1.00 per share, recognizing that you're selling $21.00 (two contracts at $10.50) and buying $14.00 + $6.00 = $20.00. No formulas. No manual updates. Change a strike price and the credit recalculates automatically.
Automatic Breakeven Identification
Breakevens for a short put butterfly are simple algebra: body strike plus credit for the upside, body strike minus credit for the downside. But when you're managing multiple butterflies with different strikes and expirations, tracking breakevens manually is error-prone. Ask Sourcetable: "Show me my breakevens."
It returns: $249 (downside) and $251 (upside). Your profit zone is $2 wide, centered exactly on the current stock price of $250. That's a 0.8% cushion in either direction—tight, but achievable if TSLA stays pinned at $250 for 30 days.
Risk Visualization Without Charts
Professional traders use payoff diagrams to understand risk profiles at a glance. In Excel, generating one requires building a data table with stock prices from $230 to $270, calculating P&L at each point using nested IF statements (since the butterfly has three legs with different payout structures), then formatting a line chart. It takes 15 minutes.
In Sourcetable, ask: "Show my risk graph." The AI generates a publication-quality payoff diagram in seconds. You see the narrow profit plateau at $250, the sloping losses on both sides capped at $900, and the current stock price marked clearly. Adjust a strike and the graph updates instantly—letting you compare narrow high-credit butterflies against wide low-credit butterflies in real-time.
Probability Analysis Using Implied Volatility
Here's where Excel truly falls apart. Calculating probability of staying at the body strike requires pulling implied volatility from the options chain, converting it to daily standard deviation, then using a normal distribution to estimate the likelihood of closing between $249 and $251. The formula involves the Black-Scholes model, natural logarithms, and probability density functions.
Ask Sourcetable: "What's my probability of profit?" It pulls current IV (say, 65% annualized), calculates the expected price range over 30 days, and returns: 28% probability of staying in range. You instantly know whether the $100 credit justifies the $900 risk—without touching a single formula. (Spoiler: 28% probability for a 1:9 risk-reward is marginal at best. You'd want 50%+ probability for this structure to make sense.)
Pin Risk and Gamma Exposure Tracking
Short put butterflies have the highest profit potential when the stock closes exactly at the body strike—but this creates pin risk. If TSLA closes at exactly $250, the two short $250 puts are at-the-money and might get assigned on one contract but not the other. This creates unintended long stock exposure over the weekend. Excel can't track this dynamically—you need real-time gamma exposure and assignment probability models.
Sourcetable calculates this automatically. Ask: "Show my pin risk." It returns: High pin risk—stock is $0.15 from body strike with 2 days remaining. Consider closing early or adjusting strikes. The AI factors in gamma exposure (which explodes as expiration approaches), current stock proximity to the body, and historical pinning behavior for TSLA. This kind of strategic guidance prevents weekend assignment surprises.
Short Put Butterfly vs. Short Call Butterfly: What's the Difference?
The short put butterfly and short call butterfly have identical payoff structures—both profit when the stock stays pinned at the body strike. The key differences are subtle but important:
Directional Bias: Short put butterflies have a slight bullish bias. If the stock drifts higher, you lose on the upside wing. Short call butterflies have a slight bearish bias. Most traders choose based on which direction they want to avoid.
Early Assignment Risk: Short put butterflies face assignment risk if the stock drops below the body strike before expiration (you're short ATM puts). Short call butterflies face assignment risk if the stock rises above the body (you're short ATM calls). Early assignment is more common on puts when stocks drop sharply.
Dividends: Short call butterflies are affected by dividend risk—if a dividend is announced, call prices shift relative to puts. Short put butterflies are less sensitive to dividend changes.
Skew: Put skew (out-of-the-money puts being more expensive than OTM calls) can make short put butterflies more attractive in terms of credit collected. The market prices downside protection higher, so you collect more premium on the short puts.
Sourcetable can compare both structures side-by-side. Ask: "Compare a short put butterfly to a short call butterfly on AAPL at $180." The AI structures both, shows net credit for each, calculates probability of profit factoring in skew, and recommends which offers better risk-reward based on current market conditions.
When Short Put Butterflies Work (and When They Don't)
Short put butterflies thrive in specific market conditions. Understanding when to deploy them—and when to avoid them—is the difference between consistent income and blown-up accounts.
Best Conditions for Short Put Butterflies
Pinned Stocks: When a stock has been trading in a tight range around a round number ($50, $100, $180) for multiple expirations, market makers are likely pinning it. This is the textbook setup for butterflies.
Post-Earnings Consolidation: After a stock reports earnings and makes a sharp move, it often consolidates at the new level for several weeks. If it's sitting at a strike with high open interest, pin risk increases—perfect for butterflies.
High Open Interest at Body Strike: If the body strike has 10x more open interest than surrounding strikes, dealers have strong incentive to pin the stock there. Use options chain data to identify pinning candidates.
Short Time to Expiration: Butterflies work best in the final 7-21 days before expiration when gamma is highest and dealers are actively managing their books. Max pin risk occurs in the final 2-3 days.
When to Avoid Short Put Butterflies
Upcoming Catalysts: Earnings, FDA decisions, Fed announcements—any binary event can gap price through your breakevens. Don't enter butterflies with less than 5 days to a major catalyst.
Trending Markets: If a stock is in a strong uptrend or downtrend, don't fight it with a neutral butterfly. Momentum beats pinning behavior.
Low Open Interest: If the body strike has minimal open interest, there's no incentive for dealers to pin the stock there. You're just betting on random consolidation—poor odds.
Wide Bid-Ask Spreads: Butterflies have three legs, meaning three separate bid-ask spreads to cross. If each leg has a $0.20 spread, you're giving up $0.60 per share just entering and exiting. For a $1.00 credit butterfly, that's 60% of your profit gone to slippage.
Sourcetable can help you identify favorable conditions. Connect live market data and ask: "Which stocks on my watchlist have the highest open interest at a single strike within 30 days of expiration?" The AI scans the list and returns candidates meeting both criteria—instant opportunity filtering without manual options chain review.
Managing Short Put Butterflies Through Expiration
Unlike iron condors or credit spreads that you can manage with rolls and adjustments, short put butterflies are largely set-and-forget positions. The narrow profit zone and balanced structure make adjustments difficult—if the stock moves away from the body, you're often better off taking the loss and moving on.
Early Exit Strategies
Professional traders rarely hold butterflies to expiration. If you've captured 50-75% of max profit with 5+ days remaining, consider closing. Sourcetable tracks this automatically. Ask: "Which of my butterflies have captured 60% of max profit?" It flags positions ready to close, freeing capital for new setups.
Say TSLA opened the butterfly at $1.00 credit when it was $250. Ten days later, TSLA is $250.05—basically pinned. The butterfly is now worth $0.35 debit to close (meaning you collect $0.35 back from the $1.00 credit if you exit now—net profit $0.65). That's 65% of max profit with 20 days of risk remaining. Close it.
Pin Risk Management in Final Days
The final 2-3 days before expiration are where butterflies shine—and where they can explode. If the stock is pinned perfectly at the body strike with 1 day left, you're sitting on near-max profit. But if it closes exactly at the body and you get assigned on only one of your two short puts, you wake up Monday with unwanted stock exposure.
Sourcetable monitors this in real-time. With 2 days remaining, ask: "Should I close my butterfly or hold for max profit?" The AI analyzes current stock price, distance from body, implied volatility, and historical pinning behavior, then recommends: "Stock is $0.08 from body with high pin risk. Close now for 92% of max profit, or accept assignment risk for final $8 per contract."
Key Takeaways
The short put butterfly is a neutral income strategy that collects credit when the stock stays pinned at the body strike. It involves three puts: buy upper wing, sell two at the body, buy lower wing.
Traditional Excel analysis requires tracking three option chains, calculating net credit, modeling probability of staying at the body, generating payoff diagrams, and monitoring pin risk—a 30-minute process that needs constant updates.
Sourcetable turns butterfly analysis into natural language questions: "What's my net credit?" → $1.00. "Show breakevens." → $249 and $251. "What's my probability of profit?" → 28%.
Short put butterflies work best when stocks are pinned at round numbers with high open interest, post-earnings consolidation, and 7-21 days to expiration. Avoid before catalysts or in trending markets.
Pin risk is the biggest threat—if the stock closes exactly at the body strike, you face assignment risk on the short puts. Close early when you've captured 50-75% of max profit to avoid this.
Frequently Asked Questions
If your question is not covered here, you can contact our team.
Contact UsWhat is a short put butterfly in options trading?
How do you calculate short put butterfly breakevens?
What is the maximum profit on a short put butterfly?
What is the maximum loss on a short put butterfly?
What is pin risk in a short put butterfly?
How is a short put butterfly different from a short call butterfly?
How does Sourcetable help with this strategy analysis?
