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 (2) |
Author: lizgdal   😊 😞
Number: of 6131 
Subject: Finance Sector: SIP changes and GTR1
Date: 12/08/24 5:55 PM
Post New | Post Reply | Report Post | Recommend It!
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
gtr1.net: GTR1 Backtester - Finance2024

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%

Post New | Post Reply | Report Post | Recommend It!
Print the post
Members reply directly to lizgdal 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 (2) |


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