Thank you so much, Mr @Whycliffes , sir!
You have pointed out something in this post that may have saved me a good bit of suboptimal work. As for the spreadsheet, as I described in this post located at Explanation for List of factors.xlsx spreadsheet and the ranking of rank factors - #6 by carymac07, I figured out almost all of the causes and the data made a lot more sense. But now for something for which I need clarification.
Your post shows the columns AU through BA, with BA “TOTAL SCORE” being the one to use. I had been using the column AE “avg top 5 buckets” and column AS “Top 5 rank”. Now you indicate that I should use column BA “Total Score” sorted low (good) to high (bad). As I look at the columns, shouldn’t I focus on column BB “Rank” sorted low (good) to high (bad)?
I want to thank you very much for your post, because as of Thursday I have been performing simulations of each single factor (sorted by column AS “Top 5 rank”) for 6 different stock universes using 3 different rank sell rules, i.e., “Rank < 95”, “Rank < 60”, and “Rank < 40” instead of the one that what was intended to be used.
And I will try out your use of Bollinger Bands as you showed.
Thank you again,
Cary