Hi, Shrewd!        Login  
Shrewd'm.com 
A merry & shrewd investing community
Best Of MIBest OfAll BoardsThe Shrewd’m WeeklyLearn to InvestHow to Become Shrewd
Search
Shrewd'm.com Merry shrewd investors
Search
Best Of MIBest OfAll BoardsThe Shrewd’m WeeklyLearn to InvestHow to Become Shrewd


The week's question
In March 2025, in the thread "Re: OT, out", Umm asked the members: "Do you think it is because America is made up of magical soil that makes businesses based in America magically profitable?" This week it is put to everyone again. The button below opens the small thread re-asking it - read what others have said so far, then give your own answer as an ordinary reply.
Answer this questionContinue to Shrewd'mThis note won't appear again
Investment Strategies / Mechanical Investing
Unthreaded | Threaded | Whole Thread (25) |
Author: mungofitch ✹✺ SILVER
SHREWD
  😊 😞

Number: of 6243 
Subject: Re: ROE Cash LT Debt Screen
Date: 07/11/23 2:37 PM
Post New | Post Reply | Report Post | Recommend It!
No. of Recommendations: 9
A couple questions I have.
IS the screen Mungofitch listed similar or same as weekly screens on this board?
Which ROE is used quarter, year or 5 year?
Where can I do my own screening, using which screening sites?
Does FT screener work for this, StOck Invetor Pro, Value Line, Portfolio 123 or other.
Which is best?


The ROE_Cash screen that is posted is similar, but not identical, to the screen I posted about which I call LargeCapCash outlined here
http://www.datahelper.com/mi/search.phtml?nofool=y...
I used the Value Line database to create and test it, and still do.
Their "Return on Shareholders' Equity" field is for one year, from the last full year annual statements available. They might do some adjustments, I'm not sure.
You can also use their figure for ROE latest quarter, which is I think the trailing four quarters (?), with very similar results in backtest.
It tests a bit better over a long backtest, a hair worse lately, close to a wash.
I have done more testing over the years with the annual figure, and there is lower turnover because it only changes once a year for each stock, so I tend to stick with that even though it is a little out of date.

If you wanted to do the screening yourself for precisely the screen I posted, you would need a subscription to Value Line.
It's hard to get the right product on line, usually you have to phone them and ask for the cheapest product that includes the "Analyzer" for the standard 1700 set of stocks.
You get a Windows program, and the subscription lets you download their database updates weekly and export it all to tab-delimited file.
There are multiple tools to proceed from there. I still use Radiscreen, the very old Excel macro.

As for which version (Value Line or SIpro or other) is best, I can't comment.
I have not really looked at the results of the SIpro version which is in the regular postings.
However, I might make the general comment that "translating" a screen to another stock database really does make it a different screen in the general case.

I have to say I am quite pleased with the first three years out of sample for the Value Line version.
(outperforming the S&P by 3-7%/year depending on the variant, when I would conservatively think something more like 1-2% would be expected in real life use)
In fact they have been so good that a couple of below-average years would not be unexpected : )
So far, it seems to meet the originally stated goal: a fairly diversified alternative to the S&P that has lower company-specific risk, and a reasonable expectation of slightly higher long run returns.
And not too much work or too much turnover.
(in a 40 stock portfolio HTD 45 run each two months, you replace under 1.5 stocks per month on average)

Jim

Post New | Post Reply | Report Post | Recommend It!
Print the post
Members reply directly to mungofitch here — and replies get answered. Reading is free; so is joining the conversation. Join Shrewd'm »
This community has written 6,227 posts about Mechanical Investing. The article-length ones it recommended most:
Dividend investing · 52 recs · 2025
Non-Mag7 screen · 34 recs · 2025
OT - Div yields and returns · 32 recs · 2024
Using AI to generate backtesting programs · 30 recs · 2025
Rankings for 19Dec2022 · 29 recs · 2022
Unthreaded | Threaded | Whole Thread (25) |


Announcements
Mechanical Investing FAQ
Contact Shrewd'm
Contact the developer of these message boards.

Best Of MI | Best Of | Favourites & Replies | All Boards | Followed Shrewds | Open Questions | Moving a community