Subject: Re: Rankings for 12Jun2023
I've added to the rankings two screens that we discussed recently, ROE_Cash and ROE_Cash2. They are defined below.
Elan
Define {ROE_Cash}
Uses [Timeliness Rank] [Return On Shareholders Equity] [Cash] [Long-Term Debt Latest Qtr] [Market Cap $ (Mil)] [Domicile Code] [SIC Code] [ROE Latest Qtr]
Deblank [Timeliness Rank] [Return On Shareholders Equity] [Cash] [Long-Term Debt Latest Qtr] [Market Cap $ (Mil)] [Domicile Code] [SIC Code] [ROE Latest Qtr]
Create [CashminusLTD] :([Cash]-[Long-Term Debt Latest Qtr])
Keep :[Timeliness Rank]<=5
Keep :OR([SIC Code]<6000,[SIC Code]>6999)
Keep :[Domicile Code]="US"
Sort Descending [Return On Shareholders Equity]
Top :500 PlusTies
Sort Descending [CashminusLTD]
Top :30
End
Define {ROE_Cash2}
Uses [Timeliness Rank] [Long-Term Debt Latest Qtr] [Market Cap $ (Mil)] [Domicile Code] [SIC Code] [Return On Shareholders Equity] [ROE Latest Qtr] [Cash]
Deblank [Timeliness Rank] [Long-Term Debt Latest Qtr] [Market Cap $ (Mil)] [Domicile Code] [SIC Code] [Return On Shareholders Equity] [ROE Latest Qtr] [Cash]
Create [CashminusLTD] :([Cash]-[Long-Term Debt Latest Qtr])
Keep :[Timeliness Rank]<=5
Keep :OR([SIC Code]<6000,[SIC Code]>6999)
Keep :[Domicile Code]="US"
Sort Descending [Return On Shareholders Equity]
Top :60 PlusTies
Sort Descending [CashminusLTD]
Top :30
End