Bull Put Spread Trading Strategy Analysis
Analyze bull put spreads with Sourcetable AI. Calculate max profit, break-even points, and risk scenarios automatically—no complex formulas required.
Andrew Grosser
February 16, 2026 • 14 min read
January 2024: AAPL trades at $185.50 after strong earnings (24% EPS beat, 18% revenue growth), technical support at $175 confirmed by 50-day moving average. You believe AAPL won't drop below $175 over the next 30 days. Instead of buying shares ($18,550 for 100), you sell a bull put spread: sell the $175 put for $2.45, buy the $170 put for $0.70, collect $1.75 net credit ($175 per contract). Max profit: $175 (the credit), max loss: $325 (the $5 spread width minus $1.75 credit), breakeven: $173.25 ($175 strike minus $1.75 credit). By February expiration, AAPL closes at $188.40—both puts expire worthless, you keep the full $175 credit. That's 53.8% return on $325 capital at risk in 30 days (641% annualized). This is bull put spread trading: collect premium upfront by selling out-of-the-money puts, profit when the stock stays above your short strike.
Excel breaks when analyzing credit spreads: calculate net credit (short put premium minus long put premium), max profit (net credit collected), max loss (strike width minus net credit), breakeven (short strike minus net credit), risk-reward ratio (max loss / max profit), return on capital (net credit / max loss), probability of profit using short put delta as proxy, then annualized return ((net credit/max loss) × (365/days)). Now compare this across 24 different strike combinations ($175/$170, $172.50/$167.50, $180/$175...) and 4 different expirations (21 days, 30 days, 45 days, 60 days). That's 96 separate spread models, each with 8+ calculated fields. Change one parameter—say, target 0.25 delta instead of 0.30 delta on short puts—and you're rebuilding strike selection logic across your entire spreadsheet. Sourcetable eliminates this nightmare. Upload AAPL option chain, ask "Compare all $5-wide bull put spreads expiring in 28-32 days with 0.20-0.30 delta on short put." Get instant table: $175/$170 collects $1.75 (53.8% ROC, 75% probability, 1.86:1 risk-reward), $172.50/$167.50 collects $1.35 (40.9% ROC, 82% probability, 2.44:1 risk-reward). Request "Show payoff diagram and filter to ROC above 50%" and see visual risk profile with only high-return spreads displayed. sign up free.
Why Bull Put Spread Analysis Requires Precision
Bull put spreads aren't conceptually hard—sell higher strike put, buy lower strike put, collect net credit, profit if stock stays above short strike—but evaluating which strikes to sell, which expiration to target, and whether the risk-reward justifies the trade requires comparing dozens of permutations with precise risk metrics.
- Credit collection vs risk exposure tradeoff: Selling 0.30 delta puts collects $1.75 credit with 70% win rate but risks $3.25 loss (1.86:1 risk-reward), selling 0.20 delta collects $1.10 with 80% win rate but risks $3.90 (3.55:1 risk-reward)—finding optimal balance is trial-and-error in Excel
- Strike width impact on capital efficiency: $5-wide spreads risk $325 to make $175 (53.8% ROC), $10-wide spreads risk $825 to make $175 (21.2% ROC)—wider spreads collect same credit but tie up more capital
- Breakeven calculation relative to support levels: $175/$170 spread has $173.25 breakeven, needs to compare against technical support at $175, 20-day low at $171.80, ATR-based stop at $172.40—requires manual reference lookups
- Time decay optimization: 21-day spreads collect $1.40 (high theta, tight timeline), 60-day spreads collect $2.20 (lower theta, more cushion)—annualized ROC calculations needed to compare fairly
How Sourcetable Handles Bull Put Spread Analysis
Sourcetable turns credit spread analysis into conversation. Upload option chain CSV (from broker or live API), ask questions in plain English, get instant calculations across all strike combinations and expirations without building formulas.
- Instant strike comparison: Ask "Show all $5-wide put spreads" → table with net credit, max profit, max loss, ROC, risk-reward, breakeven for every combination ($175/$170, $172.50/$167.50, etc.)
- Delta-based filtering: Request "Filter to short puts with 0.20-0.30 delta" → only spreads with 70-80% probability of profit shown, eliminating low-probability trades
- Risk-reward optimization: Say "Rank by risk-reward ratio under 2:1" → spreads where you risk $2 or less to make $1, sorted best to worst
- Capital efficiency comparison: Ask "Compare ROC for $5-wide vs $10-wide spreads" → see that $5-wide offers 53.8% ROC while $10-wide only 21.2% despite same credit collected
Key Bull Put Spread Analysis Capabilities
Delta-Based Strike Selection for Target Probability
When targeting 75% probability of profit, you need to sell puts with 0.25 delta (25% chance of finishing in-the-money = 75% chance of expiring worthless). But option chains have dozens of strikes—which exact strike has 0.25 delta? And how does credit collected vary across the 0.20-0.30 delta range?
Ask Sourcetable "Show bull put spreads with short puts between 0.20-0.30 delta." The AI filters all strikes, identifies those with deltas in target range, calculates spreads for each. Results: $175 put has 0.26 delta (74% win probability), collects $1.75 credit on $5-wide spread, 53.8% ROC. $177.50 put has 0.31 delta (69% win probability), collects $2.15 credit, 62.3% ROC—higher credit but lower probability. Request "Which offers best expected value?" and the AI calculates: $175 spread EV = 0.74 × $175 - 0.26 × $325 = $45.00, $177.50 spread EV = 0.69 × $215 - 0.31 × $285 = $60.00—despite lower probability, the $177.50 spread has higher EV due to better credit.
Multi-Expiration Comparison with Annualized Returns
Comparing 21-day spreads vs 60-day spreads requires annualizing returns for fair comparison. A 21-day spread earning 40% return is equivalent to 695% annualized (40% × 365/21), while a 60-day spread earning 55% return is only 335% annualized (55% × 365/60). Raw ROC numbers mislead—time-adjusted returns reveal truth.
Upload AAPL options with multiple expirations. Ask "Compare $175/$170 spread across all available expirations." The AI shows: 21-day spread collects $1.20 credit ($320 risk, 37.5% ROC, 653% annualized), 30-day collects $1.75 ($325 risk, 53.8% ROC, 641% annualized), 45-day collects $2.30 ($270 risk, 85.2% ROC, 691% annualized), 60-day collects $2.85 ($215 risk, 132.6% ROC, 806% annualized). Request "Which has best risk-adjusted return?" and discover the 60-day spread offers highest annualized ROC (806%) despite longest hold time—more time means better credit relative to risk. Say "Show theta decay profiles" and see 21-day spread loses value fastest (good for seller) but has tightest margin for error, while 60-day spread has slower theta but more cushion if stock drops.
Breakeven Analysis vs Technical Levels
Your $175/$170 AAPL spread has $173.25 breakeven. But does that align with technical support levels? If AAPL has support at $175 (50-day MA), $172 (recent swing low), and $168 (200-day MA), your breakeven sits between first and second support—reasonable cushion. If breakeven is $178 (above current support at $175), you're taking unnecessary risk.
Upload AAPL price history along with options data. Ask "Show $175/$170 spread breakeven vs recent support levels." The AI calculates breakeven at $173.25, then identifies: 50-day MA at $175.30 (2.05 points above breakeven, 1.11% cushion), 20-day low at $171.80 (1.45 points below breakeven), ATR-based volatility stop at $172.40 (0.85 points below breakeven). Request "What's probability price drops below $173.25 in 30 days?" and the AI uses historical volatility (28% annualized) to calculate 26% probability of breaching breakeven—matches the short put's 0.26 delta, confirming consistency. Say "Compare against higher strike $177.50/$172.50 spread" and see that spread's $175.75 breakeven sits only 0.25 points below support—tighter margin, higher risk despite collecting more credit.
Bull Put Spread Trading Workflows
Income Generation on Strong Stocks
MSFT trades at $420 after beating earnings (27% cloud growth, Azure revenue up 31%). Stock has strong uptrend, RSI 58 (not overbought), upside momentum intact. You're neutral-to-bullish, want to generate monthly income without owning shares.
- Upload MSFT options, ask "Find optimal 30-day bull put spread with 0.25 delta short put": AI identifies $400/$395 spread (short put 0.24 delta), collects $1.90 credit, max risk $3.10, ROC 61.3%
- Request "What's breakeven vs support?" → Breakeven $398.10, nearest support at $405 (20-day MA), 50-day MA at $395—breakeven is 1.90 points below nearest support, solid cushion
- Enter trade: Sell 10 contracts $400/$395 for $1.90 credit ($1,900 premium collected, $3,100 risk)
- Track theta decay: Ask "Show value after 7 days if MSFT at $418" → Spread worth $0.85 (theta decay captured $1.05 per spread, $1,050 unrealized gain)
- Early close decision: Say "Should I close at 50% max profit?" → AI: "You've captured $950 of $1,900 max profit in 7 days (50% in 23% of time). Annualized ROC if you close and re-enter: 1,150%. Recommendation: close and roll to next month."
You close at $0.95, locking in $950 profit (30.6% return) on $3,100 risk in 7 days. Immediately sell next month's $405/$400 spread for $2.10, continuing the income cycle. By taking profits at 50% max gain, you reduce assignment risk and can redeploy capital 4x per month instead of 1x.
Earnings Premium Collection
NFLX reports earnings in 3 days, stock at $545. Implied volatility elevated to 68% (normally 45%), inflating option premiums. Analyst consensus: EPS $4.82, subscriber adds 8.5M. You're neutral-to-bullish, believe stock won't drop below $520 even on mild disappointment.
- Upload NFLX options, ask "Compare 7-day spreads using elevated IV": $520/$515 spread collects $2.85 credit (68% IV premium), max risk $2.15, ROC 132.6%, short put 0.22 delta (78% probability)
- Request "Show post-earnings IV crush impact": AI models: if IV drops from 68% to 48% post-earnings (typical 20-point crush), spread value drops from $2.85 to $1.20 instantly—$1.65 profit from Vega alone even if stock stays flat
- Enter trade: Sell 5 contracts $520/$515 for $2.85 ($1,425 credit, $1,075 risk)—collecting outsized premium due to pre-earnings IV spike
- Earnings result: NFLX beats (EPS $5.10, subscriber adds 9.2M), stock gaps to $568. Both puts expire worthless instantly, you keep full $1,425 credit (132.6% return in 3 days)
The elevated IV environment let you collect $2.85 credit on a $5-wide spread (57% of spread width), whereas normal IV would yield only $1.60 credit (32% of width). By timing the trade around earnings IV expansion, you doubled your return while maintaining same risk profile.
Correction-Resistant Portfolio Income
SPY trades at $475 during market consolidation (VIX 16, calm conditions). You expect SPY to hold $460 support (50-day MA) over next 45 days but want income without predicting direction. Rather than single-stock risk, you diversify across 5 positions.
- Upload SPY, QQQ, IWM, DIA, EEM options, ask "Find $10-wide spreads with 0.25 delta shorts, 45-day expiration": SPY $460/$450 collects $3.80 (ROC 61.3%), QQQ $380/$370 collects $3.60 (56.3%), IWM $195/$185 collects $3.20 (47.1%), DIA $385/$375 collects $3.50 (53.8%), EEM $42/$41 collects $0.34 (51.5%)
- Request "Allocate $10K across these 5 spreads proportional to ROC": AI allocates based on capital efficiency—higher ROC gets more capital. SPY gets $2,200 (35 contracts), QQQ $2,000 (33 contracts), etc.
- Portfolio risk: Ask "What's aggregate breakeven and max loss?" → Total credit $1,844, total risk $3,156, portfolio breakeven requires all 5 indexes to stay above their respective breakevens (low correlation = diversified risk)
- 30 days later: Market dips 3% (SPY to $461, QQQ to $388, IWM to $201). Say "Should I close winners early?" → AI: "SPY, QQQ, IWM spreads worth $0.80 each (captured 79% of max profit), DIA worth $1.20 (66%), EEM worth $0.12 (65%). Recommendation: close all and capture $1,406 profit (78% of max) with 15 days remaining, reducing tail risk."
You close all 5 positions early, profit $1,406 on $3,156 risk (44.5% return) in 30 days (540% annualized). The diversification meant only 1 of 5 positions would need to hit max loss to wipe out gains from the other 4—by closing early at 78% max profit, you lock in gains and redeploy capital into next month's cycle.
Frequently Asked Questions
If your question is not covered here, you can contact our team.
Contact UsHow do you calculate max profit and max loss on a bull put spread?
What delta should I target on the short put for bull put spreads?
How wide should I make my put spreads?
When should I close bull put spreads early vs holding to expiration?
How do I adjust or roll a losing bull put spread?
What's the difference between bull put spread and cash-secured put?
How do I calculate annualized return for short-term bull put spreads?
