← Back to Templates


Protective Put / Synthetic Long Call Option Strategy
Description

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

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