← Back to Templates


Synthetic Long Stock Option Strategy
Description

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

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? Watch Demo
Similar Templates
No similar templates found