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 (24) |
Author: RAMc   😊 😞
Number: of 6131 
Subject: Re: RunRadisJM
Date: 06/14/23 4:17 PM
Post New | Post Reply | Report Post | Recommend It!
No. of Recommendations: 3
Lizgdal writes:
I wish AAII would coordinate some of this work, so the 2 to 3 hour
task of moving individual files into a DB could be streamlined.


I took me months to put SIP data from '97 into a database. It's not hard to automate all the individual SIP monthly then weekly data from AAII. The problem for me was automating the individual install programs, the required interaction 'select / skip update' Then for windows 'do you want .. . This interface changed over time, many data fields were dropped, added, definitions changed, company id's changed, sector and industry codes changed and even a few supposedly unique company id being reused. The fact that Robbie kept up with all this in a first class way, only occasionally asking for small amounts of help to partially pay for his expenses but never rewarded for his labor is amazing.

However, I believe the advantages simple screens based on comparison to a linear combination of fundamentals is being arbitraged away by the big boys using much more sophisticated data analysis tools (ML).

If I could add one feature to radiscript it would be the capability of doing sum of factor rank. An example of what this can do for screens was posted by borisnand back in 2018. His example using GTR1:
where [rAll] is sum of the ranks of three fields:
[rAll]: [-1*[rA] + 1*[rB] - 1*[rC]]
where:
[rC]: [Rank by [SI PE-Forward EPS Est Y1] (Asc) at step6]
[rB]: [Rank by [Total Return % over 252 days] (Asc) at step6]
[rA]: [Rank by [Average dollar-volume over 63 days] (Asc) at step6]

http://www.datahelper.com/mi/search.phtml?nofool=y...
Simple screen from'97 to 3/23 CAGR = 26.95%

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


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