← 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

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