← Back to Templates

Protective Call

Description

Protective Call thumbnail

Caps the risk on a short stock position by buying a call above it, so a rally stops costing money at the call strike instead of running open ended. The call is priced from bid and ask, the shares are marked with last price and previous close, and profit and loss is mapped across expiration prices, showing where the premium paid pushes the breakeven and where the call takes over. Strike and expiry are inputs, making the trade off between the cost of protection and how far the stock can run before it bites easy to test.

Template Screenshots

Protective Call 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