Wednesday, May 10, 2017

GuruFocus Dividend Screener

I just found out that the GuruFocus "All-in-One" stock screener has a few very useful dividend fields for screening. Here's what I tried out...

First, I got a list of stocks with weekly options from the CBOE:

http://www.cboe.com/products/weeklys-options/available-weeklys

Then, I plugged that list in as my universe for the GuruFocus screen, and it asked to use this criteria to filter them:
  • Forward dividend yield > 2.5%
  • Minimum of 10 years of dividend increases
  • Next ex-dividend date is within the next month
I ended up with 9 stocks, which GuruFocus allows me to download into EXCEL as a CSV file. Just four columns of that CSV file (which can be customized):

SymbolNext Ex-Dividend DateNext Dividend AmountForward Dividend Yield %
TGT2017-05-15USD 0.6004.19
ADM2017-05-16USD 0.3202.98
CVX2017-05-17USD 1.0804.05
NUS2017-05-24USD 0.3602.55
JNJ2017-05-25USD 0.8402.73
QCOM2017-05-26USD 0.5704.17
LMT2017-05-30USD 1.8202.67
PEP2017-05-31USD 0.8052.84
SU2017-06-01CAD 0.3202.96
 

No comments:

Post a Comment