← Back to Templates

Short Straddle Option Strategy

Description

Short Straddle Option Strategy thumbnail

Selling a call and a put at the same strike and expiration is what this workbook prices out, collecting two premiums in exchange for the obligation to be assigned on whichever side finishes in the money. Losses grow as the underlying moves away from the strike in either direction, and the short call leg has no upper bound, so this is not a defined risk position.

Bid, ask, previous close and the option symbol are fetched on demand for both legs next to the stock's last price, so the credit and both breakevens recalculate as quotes change.

Template Screenshots

Short Straddle Option Strategy screenshot 1

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
How does MarketXLS work?
How does MarketXLS work? Watch Demo

Similar Templates

No similar templates found