← 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

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