← Back to Templates

Synthetic Long Stock Option Strategy

Description

Synthetic Long Stock Option Strategy thumbnail

A long call and a short put at the same strike and expiration replicate the payoff of owning the shares, which is what this sheet builds and prices. The combined position gains and loses close to dollar for dollar with the underlying, including the full downside below the strike, for little or no net premium.

Strike and expiry inputs generate the option symbols, then bid, ask and previous close are pulled on demand for both legs beside the stock's last price, letting you weigh the synthetic's cost against buying the shares outright.

Template Screenshots

Synthetic Long Stock Option Strategy 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