← Back to Templates

Protective Put / Synthetic Long Call Option Strategy

Description

Protective Put / Synthetic Long Call Option Strategy thumbnail

Holding shares and buying a put against them produces a payoff shaped like a long call, which is where the second name comes from. The workbook prices the put beside the stock so the floor at the strike, the premium spent and the resulting breakeven above the current price are visible at once.

Ticker, expiration and strike build the option symbol, then bid, ask and previous close are retrieved on demand next to the underlying's last price. Downside below the strike is capped for the life of the contract, and the premium is what that cap costs.

Template Screenshots

Protective Put / Synthetic Long Call 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