The long straddle is the volatility trader's pure play—bet on big moves without picking direction. Two legs, two breakevens, unlimited profit potential—and absolutely miserable to analyze in Excel. Here's how AI turns hours of scenario modeling into seconds of conversation.
Andrew Grosser
February 16, 2026 • 11 min read
October 2023: CRM reports earnings tomorrow. The stock has been dead flat at $250 for six weeks—no momentum, no conviction, just consolidation. But earnings have historically moved CRM 12-15% in either direction. You don't know if they'll beat or miss. You don't care. You just know something big is about to happen. This is when experienced traders deploy the long straddle: buy the $250 call for $11.50 and buy the $250 put for $10.80. Total cost: $22.30 per share ($2,230 per straddle). Your profit if CRM gaps to $280? $7,700 (call worth $30, put worthless, minus $22.30 cost). Your profit if it drops to $220? $7,700 (put worth $30, call worthless, same math).
The long straddle is pure volatility speculation. You buy a call and a put at the same strike with the same expiration. You're not making a directional bet—you're betting that the stock makes a significant move in either direction. If it explodes higher or crashes lower, you profit. If it stays flat, time decay kills you and you lose your entire premium. Maximum loss is limited to the total cost. Maximum profit is unlimited in both directions (less your initial cost) sign up free.
Or you use Sourcetable. Try it free.
A long straddle isn't complicated structurally—you're buying two options. The complexity comes from evaluating whether the move you expect is large enough to justify the cost. Straddles are expensive because you're buying premium on both sides. That cost creates high breakeven hurdles. You need precision in your analysis or you're setting money on fire.
Let's break down the CRM straddle at $250:
Your upper breakeven is $250 + $22.30 = $272.30. Above this, every dollar the stock rises is pure profit. Your lower breakeven is $250 − $22.30 = $227.70. Below this, every dollar it falls is profit. Between $227.70 and $272.30, you lose money. At exactly $250 at expiration, both options expire worthless and you lose the entire $22.30.
Now here's where Excel becomes a nightmare:
That's seven distinct analytical workflows, each requiring precise calculations and real-time data. Want to evaluate straddles on five different stocks before earnings season? You're building five separate spreadsheet models. Change one assumption and you're manually recalculating everything.
Sourcetable doesn't eliminate the math—it eliminates the modeling labor of doing the math. Upload your option chain data, and the AI handles everything else. You interact with your straddle analysis the same way you'd interact with a volatility trading desk: by asking questions in plain English.
In Excel, calculating breakevens requires adding and subtracting total premium from strike price, then modeling P&L at various prices. In Sourcetable, upload your CRM option chain and ask: "What are my breakevens on a $250 straddle?"
The AI instantly returns: Upper breakeven $272.30, lower breakeven $227.70. The stock needs to move 9% in either direction to profit. It also shows: "Historical average earnings move for CRM is 11.8%. Your breakevens are within typical range. Probability of profit: 52% based on current IV of 55%."
Ask a follow-up: "Show me profit at every $5 from $200 to $300." The AI generates a complete table: at $220, put worth $30, profit $7.70. At $235, put worth $15, loss −$7.30. At $250, both worthless, loss −$22.30. At $265, call worth $15, loss −$7.30. At $280, call worth $30, profit $7.70. Instant visualization of your entire risk profile.
The hardest question with straddles: what's the probability the stock reaches my breakevens? This requires pulling implied volatility, converting to daily standard deviation, using lognormal distributions, and calculating cumulative probabilities. The math involves natural logarithms and statistical functions most traders can't implement correctly.
Ask Sourcetable: "What's my probability of profit?" The AI pulls current IV (55% for CRM), calculates the expected 1-day post-earnings move distribution, and returns: 52% probability of closing beyond breakevens. It also notes: "IV is at 78th percentile historically. You're buying expensive options. After earnings, IV typically drops to 28%, creating a 22% vega headwind. Factor this into your expectations."
This kind of volatility-adjusted probability analysis would require building Black-Scholes models in Excel. Sourcetable does it conversationally.
Straddle payoff diagrams have a distinctive V-shape: losses at the strike, profits in both directions beyond breakevens. In Excel, building this requires creating price columns from $200-$300, calculating intrinsic value for both the call and put at each price using MAX() functions, subtracting total cost, then charting. Total time: 15 minutes.
In Sourcetable, ask: "Show me a risk graph." The AI generates the V-shaped diagram instantly. You see the −$22.30 maximum loss at $250, the breakevens at $227.70 and $272.30, and the unlimited profit slopes extending outward. Current price is marked at $250, showing you're right at the max loss point if held to expiration with no move.
Want to compare strikes? Ask: "Overlay a $245 straddle on this chart." The AI adds the second straddle (lower cost, lower breakevens, but starting further from current price) to the same graph. Visual comparison makes the tradeoff obvious—pay more for ATM protection or pay less but need bigger moves.
Straddles have negative theta on both sides—you're long premium, so time decay works against you. With 2 days to earnings, theta might be −$1.50 per day on the call and −$1.40 on the put, so you're losing $2.90 per day just from time passage. But after earnings with 28 days remaining, theta might accelerate to −$3.50 per day. Understanding this helps you time exits.
Ask Sourcetable: "How much do I lose per day from theta?" It returns: Current theta: −$2.90/day (−$290 per straddle per day). Then: "Show my position value in 3 days if the stock stays at $250." The AI projects: "Position worth $13.60, down $8.70 from current $22.30. You'll have lost 39% of your premium to time decay if no move occurs. Consider closing if no volatility by Day 2."
Implied volatility often spikes before earnings (IV expansion) then crashes immediately after (IV crush). If you buy a straddle with IV at 55% and it drops to 28% post-earnings, your options lose value from vega alone—even if the stock moves. A $10 favorable stock move might only translate to $3 in P&L gain after IV crush destroys $7 in extrinsic value.
Ask Sourcetable: "What happens if IV drops to 28% right after earnings?" The AI models vega impact: "If CRM moves to $265 (a $15 favorable move) but IV crushes from 55% to 28%, your call gains $15 intrinsic value but loses $9 from vega. Your put becomes worthless (−$10.80). Net P&L: +$15 − $9 − $10.80 − $11.50 = −$16.30, still a loss despite a 6% favorable move."
This kind of vega-adjusted scenario modeling is nearly impossible in Excel without advanced options pricing models. Sourcetable handles it through simple questions.
Long straddles are powerful tools in specific situations. Understanding when to deploy them—and when to avoid them—is the difference between consistent profits and expensive lessons.
Before Binary Events: Earnings, FDA approvals, merger votes, court rulings—any event with uncertain outcome but certain resolution timing. These create the explosive moves straddles need to overcome their high cost.
Low IV Relative to Expected Move: If historical average move is 15% but IV implies only 8%, options are cheap relative to expected volatility. Sourcetable can identify these mispricings by comparing current IV percentile to historical earnings moves.
Short Time to Event: Buy straddles 1-3 days before the catalyst, not 30 days. Time decay accelerates as expiration approaches, and you want to minimize theta burn while waiting for the event.
High Volume, Liquid Options: Tight bid-ask spreads are critical. If you're paying $0.50 in slippage entering and another $0.50 exiting, you've given up $1 on a $22 straddle—4.5% of your position right out of the gate.
High IV Relative to Historical Moves: If IV is at the 90th percentile but the stock historically only moves 6% on earnings, you're overpaying for protection that exceeds realistic outcomes. The straddle breakevens might be 10% away while the stock rarely moves more than 8%.
After the Event: Never buy straddles post-earnings or post-announcement. IV collapses immediately, making both options significantly cheaper. The opportunity was before the event, not after.
On Range-Bound Stocks: If a stock has been consolidating with low volatility for months and no catalyst is imminent, straddles bleed theta without offering realistic profit scenarios. You need a reason to expect a breakout.
When You Have Directional Conviction: If you're confident CRM will beat earnings and rally, buy calls. If you think they'll miss and drop, buy puts. Straddles are for when you have no edge on direction but strong conviction on magnitude.
Sourcetable helps identify optimal conditions. Connect live market data and ask: "Which stocks on my watchlist have earnings this week with IV below historical average move?" The AI scans your list, pulls earnings dates, calculates average historical moves, compares to current IV, and returns candidates where straddles might be underpriced.
The long straddle is a pure volatility play—buy a call and put at the same strike, profiting from big moves in either direction. Maximum loss is the total premium paid. Maximum profit is unlimited in both directions (less premium cost).
Traditional Excel analysis requires calculating two breakevens, modeling P&L across 50+ price points, computing probability of profit using IV and lognormal distributions, tracking theta decay, and modeling vega exposure—easily 45+ minutes per straddle.
Sourcetable turns analysis into conversation: "What are my breakevens?" → $227.70 and $272.30. "What's my probability of profit?" → 52%. "What if IV crushes to 28%?" → detailed vega impact analysis.
Long straddles work best 1-3 days before binary events (earnings, FDA decisions) when IV is low relative to expected moves. They fail when IV is already elevated, after the event when IV crushes, or on range-bound stocks with no catalyst.
The biggest risk isn't direction—it's insufficient movement. You need the stock to move beyond your breakevens. A 6% favorable move might still be a loss if your breakevens are 9% away. Always compare required move to historical reality.
If your question is not covered here, you can contact our team.
Contact Us