Calendar Put Spread: AI-Powered Time Decay Analysis Without Excel Hell
Calendar put spreads exploit time decay differentials between two expirations—identical mechanics to call calendars but positioned for downside support. Two puts, same strike, different months, and theta calculations so complex that Excel becomes a full-time job. Here's how AI turns 45 minutes of Greeks torture into 45 seconds of plain English.
Andrew Grosser
February 16, 2026 • 13 min read
November 2023: NVDA at $128.50. Third time testing this level in eight trading days. Every dip to $126 gets bought immediately. Every bounce to $132 meets sellers. The stock isn't trending—it's consolidating right on top of support that's held for three months. This is the textbook setup for a calendar put spread: you want to harvest time decay right at support, profiting if the stock stays flat, while keeping exposure if support eventually cracks.
Here's the strategy: sell a March 14 $128 put (7 days out) for $3.20, buy an April 18 $128 put (42 days out) for $5.80. Net debit: $2.60 per share. Your edge comes from theta decay differential—the front-month option loses time value at $0.46 per day while your back-month loses only $0.14 per day. That $0.32 daily advantage is your profit engine. If NVDA closes at $128 on March 14, your short put expires worthless and your long put retains $6.10 in time value—a $3.50 gain on your $2.60 investment. That's 135% return in 7 days from pure time decay.
Or they use Sourcetable. Try it free.
Why Calendar Put Spreads Break Excel
A calendar put spread isn't a vertical spread where both legs expire the same day. It's a time spread where profit comes from the differential decay rates between two expirations. You're not primarily betting on direction—you're betting on time decay working asymmetrically in your favor. This makes the analysis fundamentally more complex than standard spreads.
Let's break down the NVDA position with actual numbers:
- Short March 14 $128 put: $3.20 premium collected (7 days to expiration)
- Long April 18 $128 put: $5.80 premium paid (42 days to expiration)
- Net debit: $2.60 per share ($260 per contract)
- Maximum risk: $2.60 (your debit—occurs if both puts expire worthless)
- Maximum profit: ~$3.50 (occurs if NVDA closes exactly at $128 on March 14)
That maximum profit scenario deserves explanation. On March 14, if NVDA is at $128, your short put expires worthless (you keep the $3.20), and your April put—now with 28 days of time value remaining—is worth approximately $6.10. Your position value: $6.10 (long put) minus $0 (short put expired) = $6.10. Subtract your original $2.60 debit, and you've made $3.50, or 135% return.
Now here's where Excel becomes a second job:
- You need to model theta decay rates for two different expirations using Black-Scholes—the March put loses $0.46/day while the April put loses $0.14/day.
- You need to calculate time value remaining as March expiration approaches, accounting for accelerating gamma when you get within 5 days to expiration.
- You need to track implied volatility skew between expirations—if front-month IV is 42% and back-month is 38%, that differential dramatically impacts pricing and vega exposure.
- You need to model P&L at various stock prices at March expiration—your profit zone is narrow (typically $125 to $131), with losses expanding beyond that range.
- You need to calculate break-even points, which aren't static—they shift as time passes and volatility changes.
- You need to project optimal exit timing—most calendars should be closed 2-3 days before front-month expiration when theta advantage peaks but gamma risk remains low.
That's six analytical workflows, each requiring advanced options pricing formulas and real-time data. Running three calendar put spreads across NVDA, AAPL, and TSLA? Multiply everything by three and accept that your spreadsheet will be obsolete before you finish building it.
How Sourcetable Turns Calendar Put Analysis Into Conversation
Sourcetable doesn't eliminate the math—it eliminates the torture of doing the math. Upload your options chain data (CSV, API, or manual entry), describe your position, and the AI handles everything else. You interact with calendar spread analysis the way you'd interact with a derivatives desk analyst: by asking questions in plain English.
Instant Theta Decay Differential Calculation
In Excel, calculating net theta requires pulling Greeks for both options, applying Black-Scholes to each expiration separately, then summing results with proper signs (short theta is positive for you, long theta is negative). In Sourcetable, you describe your NVDA position and ask: "What's my daily time decay advantage?"
The AI instantly returns: +$32 per day. Your short March put decays at $46/day, your long April put decays at $14/day, net benefit $32/day. No formulas. No manual Greeks lookups. The stock stays near $128 for seven days? You collect $224 in pure time decay profit. Change the expiration or strike and the decay differential recalculates automatically.
Automatic Maximum Profit Identification
Maximum profit on calendar spreads occurs at a specific price (your strike) on a specific date (front-month expiration). Calculating this requires modeling the long put's remaining time value assuming the short put expires worthless. Ask Sourcetable: "Show my max profit scenario."
It returns: Max profit: $3.50 per share (135% return) if NVDA = $128 on March 14. At that price, your short put expires worthless (you keep the $3.20 premium), and your April $128 put is worth approximately $6.10 (still has 28 days of time value plus intrinsic value if NVDA is below $128). Your net position value: $6.10 minus $0 = $6.10. Subtract your original $2.60 debit and you've made $3.50.
Risk Visualization Across Time and Price
Calendar spreads have three-dimensional risk profiles: profit varies by stock price, time remaining, and implied volatility. In Excel, building a 3D profit surface requires nested data tables with hundreds of cells calculating option values at every combination of inputs. It takes an hour if you know what you're doing—two hours if you don't.
In Sourcetable, ask: "Show my profit diagram at expiration." The AI generates a chart in seconds showing the characteristic tent shape—maximum profit at $128, declining profit as the stock moves to $125 or $131, break-even around $123 and $133, and maximum loss ($2.60) at extreme prices like $115 or $140. Ask "Compare profit today versus in 3 days versus at expiration" and it overlays three curves, showing how your profit zone expands and sharpens as March expiration approaches.
Volatility Impact Analysis
Calendar spreads have positive vega—they benefit when implied volatility increases. This happens because longer-dated options (your long April put) have higher vega than near-term options (your short March put). If the market gets nervous and IV spikes, your long put gains more value than your short put loses. This is why calendars work beautifully before expected volatility events like earnings—you're positioned to profit from both time decay and vol expansion.
Ask Sourcetable: "What happens if volatility jumps 8%?" It pulls current IV (say, March = 42%, April = 38%), recalculates both puts with IV increased to 50% and 46% respectively, and returns: Your position gains $1.15 in value. Your April put gains $1.85 from increased IV; your March put gains $0.70. Net benefit: $1.15. This positive vega is your buffer against market scares.
Rolling Strategy Optimization
Professional traders don't hold calendar spreads to expiration—they close or roll them 2-3 days early when theta advantage peaks but gamma risk remains manageable. When your March put approaches expiration, you have options: close the position and take profit, roll the short put to April (converting to an April/May calendar), or let it expire and sell a new near-term put.
Sourcetable analyzes rolling opportunities automatically. Say it's March 11 (3 days to expiration), NVDA is at $127.50, and you've captured $180 of unrealized profit. Ask: "Should I roll to April?"
The AI calculates: buying back your March $128 put costs $1.20 (now slightly in-the-money), selling the April 18 $128 put generates $4.30 credit, resulting in a net $3.10 credit. Combined with your existing April 18 long put, you've now created an April/May calendar spread, and you've reduced your basis from $2.60 to negative $0.50—you're getting paid to hold the position. It then suggests: "Rolling is optimal. You lock in $180 profit from the original spread, establish a new calendar with better theta dynamics, and eliminate gamma risk from the expiring short put."
Calendar Puts vs. Calendar Calls: Same Math, Different Psychology
Calendar put spreads and calendar call spreads are mathematically identical—just mirror images. Both exploit time decay differentials. Both profit when the stock stays near your strike. Both have positive vega. The only difference is psychological positioning: calls for stocks at resistance, puts for stocks at support.
Here's when to use puts instead of calls:
Stock at Support: NVDA holding $128 support? Use a $128 put calendar. You profit from time decay if support holds, but if support breaks you're already long a put that gains value on the downside. Psychologically, it feels safer than a naked call calendar.
Downside Bias: If you're neutral to slightly bearish, put calendars let you express that view. If the stock drifts lower slowly, you profit from both time decay and directional delta.
Dividend Capture: For stocks with upcoming dividends, put calendars avoid early assignment risk that plagues call calendars. Short puts are rarely assigned early; short calls often are if they're in-the-money before ex-dividend dates.
Volatility Skew: Put options often have higher implied volatility than calls (volatility skew). If the skew is pronounced, put calendars can be more profitable because you're selling higher-IV front-month puts while buying relatively cheaper back-month puts.
Sourcetable analyzes both setups simultaneously. Upload options chains for both calls and puts, then ask: "Which is better—a $128 put calendar or a $132 call calendar?" The AI compares theta differentials, vega exposure, probability of profit zones, and maximum profit scenarios, then recommends the superior structure based on current market conditions, volatility skew, and your directional bias.
Portfolio-Level Calendar Put Management
Income-focused traders don't run one calendar spread—they run five to ten simultaneously across different underlyings, strikes, and expirations. This creates a diversified theta portfolio generating daily income from time decay. Managing this in Excel is chaos: ten separate workbooks, manual Greeks consolidation, no portfolio-level risk metrics, no way to see which positions need attention.
Sourcetable centralizes everything. Upload all your calendar spreads and ask portfolio-level questions:
- "What's my total daily theta across all positions?" → $287 per day across 8 calendars.
- "Which spreads are within $2 of maximum profit?" → 3 positions flagged: NVDA, MSFT, GOOGL—consider closing early.
- "What's my net vega exposure?" → +$1,240 per 1% IV increase—you profit from volatility expansion.
- "How much capital is at risk if all positions go to max loss?" → $3,180 total risk across portfolio (sum of all debits).
This kind of aggregated analysis would require VBA macros and hours of debugging in Excel. In Sourcetable, it's a single question. The AI understands that "total theta" means summing positive theta from all short options and negative theta from all long options across every active calendar spread, weighted by contracts and position size.
When Calendar Put Spreads Work (and When They Don't)
Calendar spreads are not set-and-forget income machines. They thrive in specific market conditions and fail miserably in others. Understanding when to deploy them is the difference between consistent 30-50% monthly returns and blown-up positions that wipe out weeks of gains.
Best Conditions for Calendar Put Spreads
Stock at Strong Support: When a stock has tested and bounced from the same price level multiple times over weeks or months, calendar puts at that support level are ideal. You profit if support holds, and you're protected if it breaks. NVDA bouncing off $128 three times in eight days? Perfect setup.
Low Realized Volatility: When the stock has been range-bound with small daily moves (realized vol below 20%), calendar spreads thrive. Time decay dominates price movement, and your profit zone is wide enough to accommodate small fluctuations. Think: boring sideways action.
High Implied Volatility: When IV is elevated but actual movement is subdued, calendar spreads print money. You're selling expensive front-month options while buying cheaper (on a per-day basis) back-month options. The IV-RV differential is your edge.
Front-Month 7-21 Days Out: Theta acceleration kicks in around 21 days, peaks at 7-10 days, then becomes dangerous below 5 days as gamma explodes. Target calendars with front-month expirations in the 10-14 day range for optimal theta capture with manageable gamma risk.
When to Avoid Calendar Put Spreads
Earnings or Major Catalysts: If earnings or Fed announcements occur before your front-month expiration, avoid calendar spreads. A binary event can gap the stock through your profit zone overnight, and calendar spreads have limited profit away from the strike. That $3.50 max profit disappears fast when the stock gaps $10.
Strong Trends: If the stock is breaking out or breaking down with momentum, calendar spreads get destroyed. They're neutral strategies designed for range-bound markets. Trending markets create directional losses that overwhelm your theta profit. Don't fight the trend for $32/day in time decay.
Volatility Collapse Expected: Calendar spreads have positive vega. If you anticipate IV will drop (post-earnings, after a market scare resolves), avoid them. Your long put will lose more value from vol collapse than your short put, creating losses even if the stock stays exactly at your strike.
Illiquid Options: Wide bid-ask spreads kill calendar spread profitability. If you're paying $0.30 in slippage to enter and another $0.30 to exit, you've given up $0.60 on a $2.60 debit—23% of your risk evaporated to transaction costs before you even had a chance to profit.
Sourcetable can help you identify favorable setups. Connect live market data and ask: "Which stocks on my watchlist are near support levels with IV above 30% and earnings more than 30 days away?" The AI scans your list, checks support/resistance zones from historical price action, filters for high IV, validates no near-term catalysts, and returns candidates meeting all criteria—instant opportunity filtering without manual chart review or earnings calendar cross-checking.
Building a Calendar Put Income Portfolio
A single calendar put spread is a trade. Eight calendar spreads across different underlyings and expirations is a system. The goal: generate $300-$600 per month in theta income with defined, manageable risk. Here's how professionals structure it without losing their minds.
Diversification Rules
Multiple Underlyings: Don't stack all your calendars on tech stocks. Spread across sectors: NVDA (tech), JPM (finance), XLE (energy), XLU (utilities). When tech trends violently, energy might stay rangebound. When one sector breaks your calendar, others keep paying you theta.
Staggered Expirations: Structure your portfolio so 2-3 front-month expirations occur each week. This creates steady income flow and avoids having all positions expire simultaneously during a trending week that wipes out your entire month.
Position Sizing: Risk no more than 3-5% of your portfolio on any single calendar spread. A $10,000 account should risk $300-$500 per position maximum. Calendar spreads have limited loss (your debit), but you don't want one bad position destroying your month's gains.
The Weekly Cycle
Professional calendar traders follow a weekly rhythm that becomes automatic. Every Monday, scan for new opportunities: stocks at support or resistance, IV elevated, no near-term earnings, front-month expiration 10-14 days out. Open 1-2 new positions. On Thursday or Friday each week, manage expiring positions: close winners at 50-75% of max profit, roll positions where you want to extend exposure, let losers expire if they're near worthless. This creates a perpetual income machine where you're always collecting time decay and recycling capital into new opportunities.
Sourcetable tracks this cycle automatically. On Thursday morning, ask: "Which calendars are expiring tomorrow and have captured 60%+ of max profit?" It flags positions ready to close. Ask: "Show me new opportunities for 14-day calendars with IV > 35%." It scans your watchlist and returns candidates meeting your criteria, complete with projected theta, vega, max profit, and breakeven zones for each potential setup. You go from idea to execution in minutes instead of hours.
Key Takeaways
Calendar put spreads work identically to calendar call spreads—just positioned for support levels instead of resistance. Sell near-term puts, buy longer-dated puts, same strike, and profit from accelerated time decay on the short option. Maximum profit occurs when the stock closes at your strike on front-month expiration.
Traditional Excel analysis requires separate Black-Scholes models for each expiration, theta decay calculations across different time horizons, implied volatility skew tracking between months, 3D profit surface modeling, and breakeven calculations that shift daily—a 45-minute process per position that breaks the moment markets move.
Sourcetable turns calendar put analysis into natural language questions: "What's my daily theta advantage?" → +$32/day. "Show max profit scenario." → $3.50 profit (135% return) if stock = $128 at expiration. "Should I roll or close?" → AI compares both outcomes with full Greeks analysis and strategic recommendations.
Calendar spreads thrive when stocks are consolidating at support with low realized volatility and elevated IV, front-month expiration 10-14 days out, and no near-term catalysts like earnings. They fail catastrophically during strong trends, binary events, and vol collapse scenarios—know when to stay away.
Professional income traders run 6-10 calendar spreads simultaneously with staggered expirations across different sectors, generating $300-$600 monthly in theta income with 3-5% position sizing, systematic weekly management, and disciplined early exits at 50-75% of max profit.
Frequently Asked Questions
If your question is not covered here, you can contact our team.
Contact UsWhat's the difference between calendar put spreads and calendar call spreads?
How do you calculate maximum profit on a calendar put spread?
When should I close a calendar put spread early?
What is the theta decay advantage in calendar put spreads?
How does implied volatility affect calendar put spreads?
What's the best expiration timeframe for calendar put spreads?
How does Sourcetable help with this strategy analysis?
