Subject: Re: Dividend investing
Probably. There are a bunch of ROE-type screens in SiPro, for example this random one from an old list I had
This does not work in backtests:
FINwithRE: pref(if(trbc2.s=40!60,1,0),if(sector.s=7,1,if(incd.s=933,1,0)))
Excluding finance companies is probably not needed in this YieldROE screen, but if you want to exclude them the industry definition must be updated for the October 2024 change. Finance and RE sector in SIP is:
sector.s=7 from 19970902 to 20181028
trbc2.s=55!60 from 20181029 to 20241004 (TRBC industry codes)
trbc2.s=40!60 from 20241007 to now (GICS industry codes)
==== links ====
FINwithRE: pref(if(trbc2.s=55!60,1,0),if(sector.s=7,1,if(incd.s=933,1,0)))
FINwithRE2024: pref(if(trbc2.s=40!60,1,0),FINwithRE)
FINandREs: if(ord(1)>=26081,FINwithRE2024,FINwithRE)
see https://www.shrewdm.com/MB?pid...
"The previous (before SiPro's change in October) trbc2 codes for financial and real estate companies are 55 and 60.
The respective GICS codes are 40 and 60, and oddly the real estate company code did not change."
see https://www.shrewdm.com/MB?pid...
==== Sector definitions ====
GICS Sector
10 Energy
15 Materials
20 Industrials
25 Consumer Discretionary
30 Consumer Staples
35 Health Care
40 Financials
45 Information Technology
50 Communication Services
55 Utilities
60 Real Estate
TRBC Sector
50 Energy
51 Basic Materials
52 Industrials
53 Consumer Cyclicals
54 Consumer Non-Cyclicals
55 Financials
56 Healthcare
57 Technology
59 Utilities
60 Real Estate
61 Institutions, Associations & Organizations
62 Government Activity
63 Academic & Educational Services
==== gtr1 counts ====
TRBC TRBC GICS GICS
trbc2.s 20181029 20241004 20241007 20250623
0 0 0 0 0
10 0 0 211 219
15 0 0 230 223
20 0 0 682 705
25 0 0 579 572
30 0 0 210 204
35 0 0 754 711
40 0 0 743 755
45 0 0 636 627
50 271 218 273 279
51 231 230 0 0
52 590 574 0 0
53 566 600 0 0
54 187 216 0 0
55 949 648 93 92
56 607 728 0 0
57 637 922 0 0
58 71 0 0 0
59 96 106 0 0
60 0 245 206 208
63 0 35 0 0
https://gtr1.net/2013/?~sector...