← Back to Templates


Covered Call Option Strategy
Description

Owning shares and selling a call against them is priced out in this workbook, with the premium received, the effective sale price at the strike and the breakeven below the current price all laid out. The call caps gains above the strike, while the shares below it still carry their full downside less the premium collected.
Option symbol, bid, ask and previous close come in on demand for the short call, alongside the stock's last price, so the yield on the position and the assignment price stay accurate as the chain moves.
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