← Back to Templates

Long Put Synthetic Straddle

Description

Long Put Synthetic Straddle thumbnail

Constructs a synthetic straddle from long stock and long puts: for every 100 shares held, two at the money puts are bought, leaving the position close to delta neutral and long volatility in the way an outright straddle is.

Put quotes come from bid and ask on the contracts you select, with the stock's last price and previous close alongside. The sheet totals the premium outlay and maps profit and loss at expiration across a range of stock prices, showing the move needed in either direction before the structure pays.

Template Screenshots

Long Put Synthetic Straddle screenshot 1

Market data in your Excel sheets

1 billion usable data points on stocks, options, ETFs, and fundamentals, with simple Excel formulas.

See plans
How does MarketXLS work?
▶
How does MarketXLS work? Watch Demo

Similar Templates

No similar templates found