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
