Comments on Dividends4Life: Updated Dividend Stock Pre-Screen Model

D4L, one more... I changed the check for the 4 yr....

2008-08-20T19:34:00.000-05:00

D4L, one more... I changed the check for the 4 yr. average hurdle rate to:
AND(AVERAGE($J$10:$M$10)>$C$33,AVERAGE($K$10:$N$10)>$C$33,AVERAGE($L$10:$O$10)>$C$33,AVERAGE($M$10:$P$10)>$C$33,AVERAGE($N$10:$Q$10)>$C$33,AVERAGE($O$10:$R$10)>$C$33)

Then in C33 I place the hurdle rate I want, maybe not as high as 15%. In the long run, if you can consistently beat inflation

Anon: Nice change. I do something similar in my pr...

2008-08-20T19:04:00.000-05:00

Anon: Nice change. I do something similar in my production spreadsheet where I house the data for companies that pass the pre-screen.

Thanks for commenting.

Best Wishes,
D4L

Hi, I made a quick change to make the dividend dat...

2008-08-20T19:00:00.000-05:00

Hi, I made a quick change to make the dividend data populate automatically from the "Database" sheet. Place this in cell J9 and copy it to the right.
=INDEX(Dividend_History,MATCH(Stock_Ticker,Tickers,0),MATCH(J$7,Years_Available,0))

Now, you'll have to select the dividend history in the Database sheet (J5:T12) and Name the range Dividend_History, likewise for Tickers (A5:A12),