tag:blogger.com,1999:blog-2371295367923834063.post1649912927390610118..comments2023-06-24T10:06:17.874-05:00Comments on Dividends4Life: Updated Dividend Stock Pre-Screen ModelUnknownnoreply@blogger.comBlogger3125tag:blogger.com,1999:blog-2371295367923834063.post-70378046155714178002008-08-20T19:34:00.000-05:002008-08-20T19:34:00.000-05:00D4L, one more... I changed the check for the 4 yr....D4L, one more... I changed the check for the 4 yr. average hurdle rate to:<BR/>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)<BR/><BR/>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 inflationAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2371295367923834063.post-20252748330381582222008-08-20T19:04:00.000-05:002008-08-20T19:04:00.000-05:00Anon: Nice change. I do something similar in my pr...Anon: Nice change. I do something similar in my production spreadsheet where I house the data for companies that pass the pre-screen.<BR/><BR/>Thanks for commenting.<BR/><BR/>Best Wishes,<BR/>D4LAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2371295367923834063.post-14801427801293787622008-08-20T19:00:00.000-05:002008-08-20T19:00:00.000-05:00Hi, I made a quick change to make the dividend dat...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.<BR/>=INDEX(Dividend_History,MATCH(Stock_Ticker,Tickers,0),MATCH(J$7,Years_Available,0))<BR/><BR/>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), Anonymousnoreply@blogger.com