← 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

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