Skip to main content
No. of Recommendations: 10
I agree, the 2 screens are very similar. I was trying to modify the OP screen so it could be added to the weekly SI-Pro rankings. The screen picks stocks with good ROE and very high Cash minus Debt.

http://gtr1.net/2013/?~ROE_Cash_noFinance_with_crap_filters:...
http://gtr1.net/2013/?~ROE_Cash2020:h21f0.4::styp.a:ne14!15!...

The screen started out as:
"Of those with a reported ROE, take the top 30%--around 475 companies on average.
For each one, calculate their cash balance in excess of long term debt.
Buy equal dollar mounts of the 40 stocks with the largest net cash balances."
https://boards.fool.com/a-spy-alternative-screen-34516863.as...

{ROE_Cash_noFinance_with_crap_filters}
step0: US companies
step4: no Financial Sector
step5: Market Cap top 1700
step6: [Cash] > 0
step9: [FCFP] > 0
step10: [CFP] > 0
step11: [ROE] Top 500
step13: [CashLessLTDebt] Top 30

{ROE_Cash2020}
bstep6: no Financial Sector
bstep7: [FCF] > 0
bstep8: [ROE] > 18
bstep9: [CashLessDebt] Top 30

Possible changes:
1. drop step10. The GTR1 version of Cash Flow is not available in SIPro.

2. step0. Cash flow statements from US companies might work better in this screen. Otherwise many Chinese companies are picked. US limit could be added back to {ROE_Cash2020} as:
in GTR1: styp.a=10!11
in Radiscript: Keep :[SI Country]="United States"

3. step5 Market Cap is only needed because of step11 ROE top 500. The final sort will pick large cap stocks (companies with the most cash will be large cap companies).

4. step6 [Cash] > 0 is only needed because of step11 ROE top 500. The final sort will pick stocks with [Cash] > 0.

4. step11. ROE>18 passes about 300 out of 900 stocks on average in {ROE_Cash2020}. ROE>12 passes about 500 out of 900 stocks on average. I like the version that puts more emphasis on ROE. CashLessDebt gets plenty of weight when the final step reduces 300 stocks to 30. Using a hard cutoff of 18 or a Top 300 are similar. A hard cutoff is easier to run in many screeners. Top 30% might be good, but can't be run by some.

6. step13. Include short-term debt in [CashLessDebt]. Short-term debt is similar to long-term debt in this screen, and so should be included.
Print the post  

Announcements

What was Your Dumbest Investment?
Share it with us -- and learn from others' stories of flubs.
When Life Gives You Lemons
We all have had hardships and made poor decisions. The important thing is how we respond and grow. Read the story of a Fool who started from nothing, and looks to gain everything.
Contact Us
Contact Customer Service and other Fool departments here.
Work for Fools?
Winner of the Washingtonian great places to work, and Glassdoor #1 Company to Work For 2015! Have access to all of TMF's online and email products for FREE, and be paid for your contributions to TMF! Click the link and start your Fool career.