← 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

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