2017 Spreadsheet of Option Premiums + Dividends

I like to time my covered call contracts to contain the dividend dates. You maintain complete ownership of the stock and the rights that come with that ownership while you have the open contract. The contract only obligates you to sell the stock at expiration if you still have the contract open; you can buy back the contract at any time before expiration. You can see I did this in the red below. I locked in the gains and resigned a new contract.

Sell Call Option Profit: $2,794

Buy Call Option Spent: $542

Difference = +$2,252

Since I have averaged over 10% profit by selling my ESPP (10% discounted stock), I am highlighting the additional profit that can be made by selling call options.

*The formatting of my spreadsheet is not perfect across mobile platforms so you may want to try widescreen.

$2,252/$2,500 = 90% additional profit compared to only $2,500.

12/29/17 Sell Call $100
12/18/17 Sell Call $95.00
12/12/17 Dividend $81.00
12/7/17 Buy Call $66.00
         
11/30/17 Sell Call $134.00
11/27/17 Sell Call $104.00
11/22/17 Sell Call $60.00
10/17/17 Buy Call $8
         
10/4/17 Sell Call $373.00
9/27/17 Buy Call $54
         
9/12/17 Dividend $80.85
7/27/17 Sell Call $208
7/13/17 Buy Call $155
         
6/12/17 Dividend $75.80
5/17/17 Sell Call $394 $80
         
4/26/17 Sell Call $226
4/13/17 Buy Call $79
         
4/6/2017 Sell & Buy Call $147.95 $19
         
4/6/17 Sell/Buy 100 shares
3/21/17 Sell & Buy Call $168.95 $82
         
3/10/17 Dividend $115.98
2/16/17 Sell Call $199.95
2/6/17 Sell Call $229.95

 

Thanks for reading!

Comment, subscribe, and ask questions.

–KEN

Advertisements