| Date | Description | Amount | ROI | aROI | Profit |
| 2016-09-12 | Buy MO @ $64.14 | -$64.14 | |||
| 2016-09-13 | Div MO @ $0.61 | $0.61 | |||
| 2016-09-12 | Sell MO 9/23 2016 $64.00 Call @ $0.60 | $0.60 | |||
| 2016-09-23 | Buy MO 9/23 2016 $64.00 Call @ $0.03 | -$0.03 | |||
| 2016-09-23 | Sell MO 9/30 2016 $64.00 Call @ $0.47 | $0.47 | |||
| 2016-09-29 | Buy MO 9/30 2016 $64.00 Call @ $0.03 | -$0.03 | |||
| 2016-09-30 | Sell MO 10/28 2016 $63.00 Call @ $1.20 | $1.20 | |||
| 2016-10-28 | Assign MO @ $63.00 | $63.00 | 2.62% | 20.78% | $1.68 |
Saturday, October 29, 2016
Position closed -- MO
With the current price at $65.88, the MO call will be exercised this weekend:
Wednesday, October 5, 2016
MCD -- Rolled Out
The $0.03 limit order to buy back the 10/7 call was triggered yesterday, so I rolled the position out a month:
| Date | Description | Amount | ROI | aROI | Profit |
| 2016-07-27 | Buy MCD @ $119.79 | -$119.79 | |||
| 2016-07-27 | Sell MCD 8/5 2016 $120 Call @ $0.95 | $0.95 | |||
| 2016-08-03 | Buy MCD 8/5 2016 $120 Call @ $0.03 | -$0.03 | |||
| 2016-08-03 | Sell MCD 9/2 2016 $120 Call @ $0.75 | $0.75 | |||
| 2016-08-30 | Div MCD @ $0.89 | $0.89 | |||
| 2016-08-19 | Buy MCD 9/2 2016 $120 Call @ $0.03 | -$0.03 | |||
| 2016-09-06 | Sell MCD 10/7 2016 $117 Call @ $2.49 | $2.49 | |||
| 2016-10-04 | Buy MCD 10/7 2016 $117 Call @ $0.03 | -$0.03 | |||
| 2016-10-05 | Sell MCD 11/11 2016 $117 Call @ $1.25 | $1.25 | |||
| 2016-11-11 | If assigned at expiration | $117.00 | 2.88% | 9.82% | $3.45 |
| 2016-10-05 | Current Price | $113.41 | -0.12% | -0.61% | -$0.14 |
| 2016-10-05 | Buy and Hold | -- | -5.33% | -- | -$6.38 |
Sunday, September 25, 2016
Dividend Champions and options
Just out of curiosity, I thought I'd check the Dividend Champions for option availability. I started with the EXCEL file here:
http://www.dripinvesting.org/Tools/Tools.asp
Then I used my add-in to find the next five expiration dates from Yahoo for each ticker symbol. Then grabbed the first options page from Yahoo for each ticker and summed up the the open interest of all calls listed on the page.
I sorted by Expiry1 thru Expiry5, ascending, and by descending total open interest.
Then I broke the remaining data into groups, dropping those tickers that had no expiration dates listed (there were about 5 to 10).
I'm trying to decide how to use the data, but thought I'd post it in case anyone has any suggestions. I may just focus on the weeklies. Maybe also the Monthly 1 and Monthly 2 using a total open interest threshold (100? 300? 500?).
Anyway, the sorted data:
http://www.dripinvesting.org/Tools/Tools.asp
Then I used my add-in to find the next five expiration dates from Yahoo for each ticker symbol. Then grabbed the first options page from Yahoo for each ticker and summed up the the open interest of all calls listed on the page.
I sorted by Expiry1 thru Expiry5, ascending, and by descending total open interest.
Then I broke the remaining data into groups, dropping those tickers that had no expiration dates listed (there were about 5 to 10).
I'm trying to decide how to use the data, but thought I'd post it in case anyone has any suggestions. I may just focus on the weeklies. Maybe also the Monthly 1 and Monthly 2 using a total open interest threshold (100? 300? 500?).
Anyway, the sorted data:
| Ticker | Expiry1 | Expiry2 | Expiry3 | Expiry4 | Expiry5 | Tot OI | Group |
| T | 2016-09-30 | 2016-10-07 | 2016-10-14 | 2016-10-21 | 2016-10-28 | 14816 | Weeklies |
| CVX | 2016-09-30 | 2016-10-07 | 2016-10-14 | 2016-10-21 | 2016-10-28 | 11858 | |
| XOM | 2016-09-30 | 2016-10-07 | 2016-10-14 | 2016-10-21 | 2016-10-28 | 11404 | |
| PG | 2016-09-30 | 2016-10-07 | 2016-10-14 | 2016-10-21 | 2016-10-28 | 10954 | |
| MCD | 2016-09-30 | 2016-10-07 | 2016-10-14 | 2016-10-21 | 2016-10-28 | 7494 | |
| WMT | 2016-09-30 | 2016-10-07 | 2016-10-14 | 2016-10-21 | 2016-10-28 | 7076 | |
| MO | 2016-09-30 | 2016-10-07 | 2016-10-14 | 2016-10-21 | 2016-10-28 | 5206 | |
| PEP | 2016-09-30 | 2016-10-07 | 2016-10-14 | 2016-10-21 | 2016-10-28 | 3985 | |
| JNJ | 2016-09-30 | 2016-10-07 | 2016-10-14 | 2016-10-21 | 2016-10-28 | 3648 | |
| NUE | 2016-09-30 | 2016-10-07 | 2016-10-14 | 2016-10-21 | 2016-10-28 | 3259 | |
| LOW | 2016-09-30 | 2016-10-07 | 2016-10-14 | 2016-10-21 | 2016-10-28 | 3236 | |
| TGT | 2016-09-30 | 2016-10-07 | 2016-10-14 | 2016-10-21 | 2016-10-28 | 3046 | |
| WBA | 2016-09-30 | 2016-10-07 | 2016-10-14 | 2016-10-21 | 2016-10-28 | 2645 | |
| KO | 2016-09-30 | 2016-10-07 | 2016-10-14 | 2016-10-21 | 2016-10-28 | 2351 | |
| MDT | 2016-09-30 | 2016-10-07 | 2016-10-14 | 2016-10-21 | 2016-10-28 | 1923 | |
| MMM | 2016-09-30 | 2016-10-07 | 2016-10-14 | 2016-10-21 | 2016-10-28 | 1039 | |
| CL | 2016-09-30 | 2016-10-07 | 2016-10-14 | 2016-10-21 | 2016-10-28 | 918 | |
| ADM | 2016-09-30 | 2016-10-07 | 2016-10-14 | 2016-10-21 | 2016-10-28 | 691 | |
| EMR | 2016-10-21 | 2016-11-18 | 2016-12-16 | 2017-01-20 | 2017-03-17 | 8320 | Monthly 1 |
| CLX | 2016-10-21 | 2016-11-18 | 2016-12-16 | 2017-01-20 | 2017-04-21 | 3653 | |
| HP | 2016-10-21 | 2016-11-18 | 2016-12-16 | 2017-01-20 | 2017-03-17 | 2699 | |
| APD | 2016-10-21 | 2016-11-18 | 2016-12-16 | 2017-01-20 | 2017-03-17 | 2234 | |
| HRL | 2016-10-21 | 2016-11-18 | 2016-12-16 | 2017-01-20 | 2017-03-17 | 1789 | |
| ITW | 2016-10-21 | 2016-11-18 | 2016-12-16 | 2017-03-17 | 2288 | ||
| SHW | 2016-10-21 | 2016-11-18 | 2016-12-16 | 2017-03-17 | 1380 | ||
| BDX | 2016-10-21 | 2016-11-18 | 2016-12-16 | 2017-03-17 | 731 | ||
| DOV | 2016-10-21 | 2016-11-18 | 2016-12-16 | 2017-03-17 | 432 | ||
| MKC | 2016-10-21 | 2016-11-18 | 2016-12-16 | 2017-03-17 | 285 | ||
| LEG | 2016-10-21 | 2016-11-18 | 2016-12-16 | 2017-03-17 | 160 | ||
| RLI | 2016-10-21 | 2016-11-18 | 2016-12-16 | 2017-03-17 | 135 | ||
| CSL | 2016-10-21 | 2016-11-18 | 2016-12-16 | 2017-03-17 | 110 | ||
| NNN | 2016-10-21 | 2016-11-18 | 2016-12-16 | 2017-03-17 | 101 | ||
| NDSN | 2016-10-21 | 2016-11-18 | 2016-12-16 | 2017-03-17 | 80 | ||
| CINF | 2016-10-21 | 2016-11-18 | 2016-12-16 | 2017-03-17 | 78 | ||
| AWR | 2016-10-21 | 2016-11-18 | 2016-12-16 | 2017-03-17 | 59 | ||
| SEIC | 2016-10-21 | 2016-11-18 | 2016-12-16 | 2017-03-17 | 42 | ||
| LANC | 2016-10-21 | 2016-11-18 | 2016-12-16 | 2017-03-17 | 26 | ||
| VVC | 2016-10-21 | 2016-11-18 | 2016-12-16 | 2017-03-17 | 24 | ||
| CLC | 2016-10-21 | 2016-11-18 | 2016-12-16 | 2017-03-17 | 19 | ||
| MCY | 2016-10-21 | 2016-11-18 | 2016-12-16 | 2017-03-17 | 16 | ||
| NWN | 2016-10-21 | 2016-11-18 | 2016-12-16 | 2017-03-17 | 13 | ||
| JKHY | 2016-10-21 | 2016-11-18 | 2016-12-16 | 2017-03-17 | 12 | ||
| CTWS | 2016-10-21 | 2016-11-18 | 2016-12-16 | 2017-03-17 | 2 | ||
| PNY | 2016-10-21 | 2016-11-18 | 2016-12-16 | 2017-03-17 | 1 | ||
| VFC | 2016-10-21 | 2016-11-18 | 2017-01-20 | 2017-02-17 | 2017-05-19 | 4752 | Monthly 2 |
| AFL | 2016-10-21 | 2016-11-18 | 2017-01-20 | 2017-02-17 | 2017-05-19 | 1942 | |
| ED | 2016-10-21 | 2016-11-18 | 2017-01-20 | 2017-02-17 | 2017-05-19 | 1534 | |
| SYY | 2016-10-21 | 2016-11-18 | 2017-01-20 | 2017-02-17 | 2017-05-19 | 1441 | |
| GD | 2016-10-21 | 2016-11-18 | 2017-01-20 | 2017-02-17 | 2017-05-19 | 1108 | |
| HCP | 2016-10-21 | 2016-11-18 | 2017-01-20 | 2017-04-21 | 2018-01-19 | 15198 | |
| BEN | 2016-10-21 | 2016-11-18 | 2017-01-20 | 2017-04-21 | 2018-01-19 | 8386 | |
| KMB | 2016-10-21 | 2016-11-18 | 2017-01-20 | 2017-04-21 | 2018-01-19 | 8121 | |
| SWK | 2016-10-21 | 2016-11-18 | 2017-01-20 | 2017-04-21 | 2018-01-19 | 4041 | |
| TROW | 2016-10-21 | 2016-11-18 | 2017-01-20 | 2017-04-21 | 3930 | ||
| GWW | 2016-10-21 | 2016-11-18 | 2017-01-20 | 2017-04-21 | 1419 | ||
| ORI | 2016-10-21 | 2016-11-18 | 2017-01-20 | 2017-04-21 | 1370 | ||
| BCR | 2016-10-21 | 2016-11-18 | 2017-01-20 | 2017-04-21 | 1032 | ||
| BMS | 2016-10-21 | 2016-11-18 | 2017-01-20 | 2017-04-21 | 2018-01-19 | 651 | |
| NFG | 2016-10-21 | 2016-11-18 | 2017-01-20 | 2017-04-21 | 621 | ||
| MDU | 2016-10-21 | 2016-11-18 | 2017-01-20 | 2017-04-21 | 452 | ||
| SON | 2016-10-21 | 2016-11-18 | 2017-01-20 | 2017-04-21 | 382 | ||
| ATO | 2016-10-21 | 2016-11-18 | 2017-01-20 | 2017-04-21 | 238 | ||
| UGI | 2016-10-21 | 2016-11-18 | 2017-01-20 | 2017-04-21 | 189 | ||
| ABM | 2016-10-21 | 2016-11-18 | 2017-01-20 | 2017-04-21 | 121 | ||
| PPG | 2016-10-21 | 2016-11-18 | 2017-02-17 | 2017-05-19 | 3540 | Monthly 3 | |
| ADP | 2016-10-21 | 2016-11-18 | 2017-02-17 | 2017-05-19 | 1378 | ||
| PNR | 2016-10-21 | 2016-11-18 | 2017-02-17 | 2017-05-19 | 1371 | ||
| GPC | 2016-10-21 | 2016-11-18 | 2017-02-17 | 2017-05-19 | 1135 | ||
| RPM | 2016-10-21 | 2016-11-18 | 2017-02-17 | 2017-05-19 | 712 | ||
| CTAS | 2016-10-21 | 2016-11-18 | 2017-02-17 | 2017-05-19 | 678 | ||
| SPGI | 2016-10-21 | 2016-11-18 | 2017-02-17 | 2017-05-19 | 388 | ||
| PH | 2016-10-21 | 2016-11-18 | 2017-02-17 | 2017-05-19 | 192 | ||
| UVV | 2016-10-21 | 2016-11-18 | 2017-02-17 | 2017-05-19 | 128 | ||
| BKH | 2016-10-21 | 2016-11-18 | 2017-02-17 | 2017-05-19 | 111 | ||
| RAVN | 2016-10-21 | 2016-11-18 | 2017-02-17 | 2017-05-19 | 58 | ||
| EV | 2016-10-21 | 2016-11-18 | 2017-02-17 | 2017-05-19 | 47 | ||
| BRC | 2016-10-21 | 2016-11-18 | 2017-02-17 | 2017-05-19 | 26 | ||
| CBSH | 2016-10-21 | 2016-11-18 | 2017-02-17 | 2017-05-19 | 7 | ||
| FRT | 2016-10-21 | 2016-11-18 | 2017-02-17 | 267 | |||
| TDS | 2016-10-21 | 2016-11-18 | 2017-02-17 | 196 | |||
| DCI | 2016-10-21 | 2016-11-18 | 2017-02-17 | 75 | |||
| MGEE | 2016-10-21 | 2016-11-18 | 2017-02-17 | 73 | |||
| UBSI | 2016-10-21 | 2016-11-18 | 2017-02-17 | 16 | |||
| FUL | 2016-10-21 | 2016-11-18 | 79 | Others | |||
| STR | 2016-10-21 | 2016-12-16 | 2017-01-20 | 2017-04-21 | 91 | ||
| WTR | 2016-10-21 | 2016-12-16 | 2017-03-17 | 84 | |||
| SCL | 2016-10-21 | 2016-12-16 | 2017-03-17 | 58 | |||
| MSEX | 2016-10-21 | 2016-12-16 | 2017-03-17 | 8 | |||
| GRC | 2016-10-21 | 2016-12-16 | 2017-03-17 | 5 | |||
| UHT | 2016-10-21 | 2016-12-16 | 2017-03-17 | 2 | |||
| CWT | 2016-10-21 | 2016-12-16 | 2017-03-17 | 1 | |||
| MSA | 2016-10-21 | 2016-12-16 | 2017-03-17 | 1 | |||
| SJW | 2016-10-21 | 2016-12-16 | 2017-03-17 | 0 | |||
| TR | 2016-10-21 | 2016-12-16 | 2017-03-17 | 0 | |||
| VAL | 2016-10-21 | 2017-01-20 | 2017-04-21 | 2018-01-19 | 1599 | ||
| WGL | 2016-10-21 | 2017-01-20 | 2017-04-21 | 60 | |||
| TNC | 2016-10-21 | 2017-01-20 | 427 | ||||
| TMP | 2016-12-16 | 2017-03-17 | 24 | ||||
| SRCE | 2016-12-16 | 1 | |||||
| CTBI | 2016-12-16 | 1 | |||||
| ERIE | 2017-03-17 | 20 |
Saturday, September 24, 2016
MO -- Rolled out
The $0.03 limit order to buy back the call was triggered early on Friday, so I rolled it out a week:
| Date | Description | Amount | ROI | aROI | Profit |
| 2016-09-12 | Buy MO @ $64.14 | -$64.14 | |||
| 2016-09-13 | Div MO @ $0.61 | $0.61 | |||
| 2016-09-12 | Sell MO 9/23 2016 $64.00 Call @ $0.60 | $0.60 | |||
| 2016-09-23 | Buy MO 9/23 2016 $64.00 Call @ $0.03 | -$0.03 | |||
| 2016-09-23 | Sell MO 9/30 2016 $64.00 Call @ $0.47 | $0.47 | |||
| 2016-09-30 | If assigned at expiration | $64.00 | 2.35% | 47.74% | $1.51 |
| 2016-09-23 | Current Price | $63.87 | 2.15% | 71.39% | $1.38 |
Position closed -- LLY
With the current price at $81.16, the LLY call will be exercised this weekend:
| Date | Description | Amount | ROI | aROI | Profit |
| 2016-08-08 | Buy LLY @ $81.19 | -$81.19 | |||
| 2016-08-08 | Sell LLY 8/12 2016 $81 Call @ $0.55 | $0.55 | |||
| 2016-08-11 | Div LLY @ $0.51 | $0.51 | |||
| 2016-08-12 | Buy LLY 8/12 2016 $81 Call @ $0.03 | -$0.03 | |||
| 2016-08-12 | Sell LLY 8/26 2016 $80.50 Call @ $0.74 | $0.74 | |||
| 2016-08-24 | Buy LLY 8/26 2016 $80.50 Call @ $0.03 | -$0.03 | |||
| 2016-08-24 | Sell LLY 9/23 2016 $80.50 Call @ $0.53 | $0.53 | |||
| 2016-09-23 | Asgn LLY @ $80.50 | $80.50 | 1.95% | 15.49% | $1.59 |
Monday, September 12, 2016
New Dividend Play -- MO
MO is going ex-dividend for $0.61 tomorrow (9/13).
| Date | Description | Amount | ROI | aROI | Profit |
| 2016-09-12 | Buy MO @ $64.14 | -$64.14 | |||
| 2016-09-12 | Sell MO 9/23 2016 $64.00 Call @ $0.60 | $0.60 | |||
| 2016-09-23 | If assigned at expiration | $64.00 | 0.72% | 23.80% | $0.46 |
| 2016-09-12 | Current Price | $64.00 | 0.72% | 261.77% | $0.46 |
Tuesday, September 6, 2016
MCD -- Rolled down and out
The $0.03 limit order to buy back of the previous call was actually triggered a few weeks ago. I've been waiting for some price recovery before selling a new call. After it had recovered a little, I put in a limit order to sell a the "MCD 10/7 2016 $117 Call" for $2.49, when the current price had been about $1.25.
The run-up in MCD this morning triggered that limit order. In fact, the opening price was my limit price. :)
The run-up in MCD this morning triggered that limit order. In fact, the opening price was my limit price. :)
| Date | Description | Amount | ROI | aROI | Profit |
| 2016-07-27 | Buy MCD @ $119.79 | -$119.79 | |||
| 2016-07-27 | Sell MCD 8/5 2016 $120 Call @ $0.95 | $0.95 | |||
| 2016-08-03 | Buy MCD 8/5 2016 $120 Call @ $0.03 | -$0.03 | |||
| 2016-08-03 | Sell MCD 9/2 2016 $120 Call @ $0.75 | $0.75 | |||
| 2016-08-30 | Div MCD @ $0.89 | $0.89 | |||
| 2016-08-19 | Buy MCD 9/2 2016 $120 Call @ $0.03 | -$0.03 | |||
| 2016-09-06 | Sell MCD 10/7 2016 $117 Call @ $2.49 | $2.49 | |||
| 2016-10-07 | If assigned at expiration | $117.00 | 1.86% | 9.44% | $2.23 |
| 2016-09-06 | Current Price | $117.00 | 1.86% | 16.57% | $2.23 |
Subscribe to:
Posts (Atom)
Posts
