No. of Recommendations: 7
Either [Finance] or [FINa] can be used with the new SIP data, and have about 80% overlap. These do not include Real Estate stocks.
RealEstate: pref(if(trbc2.s=60,1,if(trbc7.s=5540201!5540202!5540301!5540302!5540303!5540304,1,0)),if(incd.s=933,1,0))
FINwoutRE: pref(if(RealEstate=1,0,if(trbc2.s=55,1,0)),if(incd.s=933,0,if(sector.s=7,1,0)))
Finance2024: pref(if(trbc2.s=40,1,0),FINwoutRE)
Finance: if(ord(1)>=26081,Finance2024,FINwoutRE)
FINa: if(fincd12.a=11,if(styp.a=18!48,0,1),0)
==================
Details:
TopLineFirst posted a field to handle the 2018 SIP industry change:
RealEstate: pref(if(trbc2.s=60,1,if(trbc7.s=5540201!5540202!5540301!5540302!5540303!5540304,1,0)),if(incd.s=933,1,0))
FINwoutRE: pref(if(RealEstate=1,0,if(trbc2.s=55,1,0)),if(incd.s=933,0,if(sector.s=7,1,0)))
http://www.datahelper.com/mi/search.phtml?nofool=y...These fields can be used with the new SIP data, but after the 20241001 SIP industry change, the Finance Sector is trbc2.s=40. Some new fields to handle this change:
Finance2024: pref(if(trbc2.s=40,1,0),FINwoutRE)
Finance: if(ord(1)>=26081,Finance2024,FINwoutRE)
The ordinal date of Tuesday 20241001 is 26079, but Thursday 26081 gives smoother stock counts.
The number of S&P 1500 stocks in the Finance sector increased from 190 to 222 in the last 20 years (using SIP data), and jumped to 260 with the new SIP data.
[fincd12.a] can also be used to find Finance stocks, but includes Real Estate stocks. Finance without Real Estate is:
FINa: if(fincd12.a=11,if(styp.a=18!48,0,1),0)
========================
The screen {Finance2024} compares the 2 fields [Finance] and [FINa]. Stocks passing step2 are placed in the Real Estate sector by either trbc2 or styp (union of the 2 lists). Stocks passing step3 are placed in the Real Estate sector by both trbc2 or styp (intersection of the 2 lists). The Jaccard Index (intersection size over union size) is also calculated.
Define {Finance2024}
Create [sumFlags]: [[Finance] + [FINa]]
Create [JaccardIndex]: [[# Eligible at step4]/[# Eligible at step3]]
step0: [S&P 1500 Member] == 1
step1: [Max([SI Sales Q1], [SI Sales Y1])] > 0
step2: [sumFlags] >= 1
step3: [sumFlags] == 2
step4: [JaccardIndex] != -987
https://gtr1.net/2013/?~Finance2024::sp1500.a:et1:...The Jaccard Index (IoU) using [Finance] and [FINa] varies between about 77% and 94%.
IoU IoU
From To Average StdDev
19970902 20011009 88% 4%
20011010 20091029 94% 2%
20091030 20181028 87% 3%
20181029 20241006 86% 1%
20241007 20241205 77% 0%
