First, I run my "upcoming dividends" workbook. It is ordered by my estimated ex-dividend dates, which I try to confirm:
| Ticker | Options | Source | Estimated Ex-dividend date | Week | Yield | Ex-dividend date | Warning |
| IRET | M1X | Dividend Champion | xxxx-03-16 | 1 | 4.84% | 2017-03-16 | |
| WEYS | N | Dividend Champion | xxxx-03-16 | 1 | 3.37% | 2017-03-16 | |
| CINF | M1X | Dividend Champion | xxxx-03-20 | 1 | 2.70% | 2017-03-20 | |
| PM | W | freebelvin | xxxx-03-21 | 1 | 3.76% | 2017-03-21 | |
| SPLS | W | freebelvin | xxxx-03-22 | 1 | 5.54% | 2017-03-22 | |
| POR | M1X | freebelvin | xxxx-03-23 | 2 | 2.90% | 2017-03-23 | |
| NFG | M2 | Dividend Champion | xxxx-03-29 | 2 | 2.70% | 2017-03-29 | |
| DOW | W | freebelvin | xxxx-03-29 | 2 | 2.89% | 2017-03-29 | |
| MDT | W | Dividend Champion | xxxx-03-22 | 1 | 2.08% | 2017-03-22 | |
| PNY | M1X | Dividend Champion | xxxx-03-23 | 2 | 2.27% | 2016-09-21 | <== |
| NUE | W | Dividend Champion | xxxx-03-29 | 2 | 2.49% | 2017-03-29 | |
| ITW | M1 | Dividend Champion | xxxx-03-29 | 2 | 1.95% | 2017-03-29 | |
| SYK | M1 | PLA | xxxx-03-29 | 2 | 1.29% | 2017-03-29 | |
| BEN | M2 | Dividend Champion | xxxx-03-29 | 2 | 1.89% | 2017-03-29 | |
| CB | M3 | Dividend Champion | xxxx-03-29 | 2 | 2.01% | 2017-03-29 |
Next, I run those over 2.5% yield through by "CC List" workbook, to check for quick candidates:
| Ticker | Last Price | Strike | RIU | RIE | D/P | aROI | Call Description | Bid Price |
| PM | $112.42 | ITM | 0.3% | 0.3% | 0.7% | 13.3% | PM 3/24 2017 $112.00 Call | $0.79 |
| SPLS | $8.78 | -- | -- | 2.5% | 0.0% | -- | SPLS 3/24 2017 $9.00 Call | -- |
| POR | $45.03 | -- | -- | -- | -- | -- | -- | |
| NFG | $60.91 | -- | -- | -- | -- | -- | -- | |
| DOW | $64.44 | OTM | 0.8% | 0.9% | 0.8% | 32.7% | DOW 3/24 2017 $64.50 Call | $0.52 |
I used a 3/24 expiration date for comparison. That workbook checks the first ITM and first OTM call, to see what the best aROI would be. In this case, it looks like DOW is the only one to look at in more detail. So I run it through the "CC Roll" workbook, to see which calls are the best over many expiration dates and many strike prices. The top aROI results from that workbook:
| Action | Ticker Symbol | Pivot | Price | Extrinsic | Ex-Div? | Earn? | |
| Buy or owned | DOW | $0.00 | $64.44 | -- | 2017-03-29 | 2017-04-27 | |
| Buy to close | None | -- | -- | -- | |||
| Data Source | Barchart | ||||||
| Action | Ticker Symbol | Bid Price | Extrinsic | Profit | aROI | Dividends | Earn Rpt |
| Sell to open | DOW 3/17 2017 $64.50 Call | $0.22 | $0.22 | $0.22 | 62.3% | -- | -- |
| Sell to open | DOW 3/24 2017 $64.50 Call | $0.52 | $0.52 | $0.52 | 32.7% | -- | -- |
| Sell to open | DOW 3/31 2017 $64.50 Call | $0.66 | $0.66 | $0.66 | 23.4% | $0.46 | -- |
| Sell to open | DOW 3/24 2017 $64.00 Call | $0.76 | $0.32 | $0.32 | 20.1% | -- | -- |
| Sell to open | DOW 3/24 2017 $65.00 Call | $0.31 | $0.31 | $0.31 | 19.5% | -- | -- |
| Sell to open | DOW 4/7 2017 $64.50 Call | $0.76 | $0.76 | $0.76 | 18.7% | $0.46 | -- |
| Sell to open | DOW 3/31 2017 $64.00 Call | $0.95 | $0.51 | $0.51 | 18.1% | $0.46 | -- |
So it looks like the two best aROI would be with expiration dates prior to the ex-dividend date, and both are above the 30% aROI filter I try to use. However, the $0.22 bid price is a bit low for me to trade, since the commission would be too large an amount. I'll check tomorrow on the 3/24 expiration. If it is exercised at expiration, I may be able to write another for the ex-dividend week.
I may run PM through the "CC Roll" workbook tomorrow, seeing if any of the 3/24 expiration date strike prices look any better. Because it pays a $1.04 dividend, which can change the outcome a bit -- it can boost the aROI if the call gets exercised early.
Posts
No comments:
Post a Comment