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
