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 December 2024, in the thread "Re: BRK: Why Not XOM?", BreckHutHigh asked the members: "What about the long road trips with kids?" 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 (28) |
Author: RAMc   😊 😞
Number: of 6131 
Subject: Re: Hope for GTR1?
Date: 04/17/23 12:46 PM
Post New | Post Reply | Report Post | Recommend It!
No. of Recommendations: 2
I've been using the GTR1 ranking feature for two screens that I use, and now I'm adrift. . . variants of Mungofitch's ROE_Cash screen

I'm in the same boat. The only screen I've been using on GTR1 was my own version of ROE_Cash.
Borisnand posted a version of ROE_cash using only sip data on 10/25/2020. I tried to make a version
that would run on my SIP data only backtester. My first pass:
This version uses SP500 or SP400 as a quick filter of crap instead of top 1700 Mcap

(ci.SP = 500 OR ci.SP = 400) \
and CI.IND_2_DIG <> 55 \
and MLT.PFCPS >0 \
and CASH_Q1 > 0 \
and BSQ.Equity_Q1 > 0 \
and NETINC_12M >0 \
and fcfps_12M > 0 \
and 100*ISA.NETINC_12M/BSQ.EQUITY_Q1 >18 \
ORDER BY ((CASH_Q1 - LTDEBT_Q1)/MKTCAP) Desc

Doesn't backtest as well as the GTR1 version:
ROE_CASH_ 2004-10-01 thru 2023-03-31
Top 15 tilldrop 20 period 21 days slipRndTrp 0.70% , Dividends True , CashForNoPicks True
CAGR 14.0% GSD 28.5% CAGR/GSD 0.5 UlcrIndx 10.8% MxDD 54.7% AT 200%
11.37 X accumulated with 555 Buys, 4815 Holds and 100.0% Avg Invested

This can be screened using the SIP built in screener.
Boris also suggested creating a custom field in SIP which I didn't do which would probably improve the results.
Custom SIPro field for CashMinusDebt:

IIF(IsFieldNull([Cash Q1])=0,0,[Cash Q1]) + IIF(IsFieldNull([Short-term investments Q1])=0,0,[Short-term investments Q1]) - IIF(IsFieldNull([Long-term debt Q1])=0,0,[Long-term debt Q1]) - IIF(IsFieldNull([Short-term debt Q1])=0,0,[Short-term debt Q1])

RAM
Post New | Post Reply | Report Post | Recommend It!
Print the post
Members reply directly to RAMc here — and replies get answered. Reading is free; so is joining the conversation. Join Shrewd'm »
This community has written 6,115 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 (28) |


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