[fabi470]

Hi David,

I hope you`re doing fine. 
Currently i am working on Industry Group Relative Strength Table similar to yours (104 Dow Jones Sector Industry Groups sorted by Relative Strength - Stage Analysis). 

In my opinion the most important time frames for defining the RS are the 1-week, 1-month, 3-months and the 1-year period. Do you agree (i know, everyone has a quite different view on such subjective topics)?

I am wondering how you calculate the RS of the industry groups in your Google Sheet Table (you name it "RS Score"). I guess, it is not the SCTR score from stockcharts.com, is it? If it is, how do you import the SCTR into Google Sheets? If it is NOT, do you mind to tell us, how you calculate the RS score?

I would really appreciate your answers, David!

Greetings from germany and a nice weekend!

Hi fabi470,

Yes, I focus on similar time periods, and am looking for groups that are rising up the rankings strongly that could become future leading groups. As I want to catch the moves early enough to get in at the early part of Stage 2 or even late in Stage 1 if the base structure is forming in a favourable way for lower risk entries.

The RS score in my sheets is the SCTR score from stockcharts. I simply copy and paste this into a google sheet each week, and then on a separate sheet calculate the change for the 1 week, 2 week, 4 week and 12 week change, plus the overall score, which is longer term as the SCTR is made up from multiple things as far back as 200 days. See stockcharts website for how it is calculated.

Hi David, 

thank you for your quality response (as always). I really appreciate them.

I am working on my google sheets screener right now and i might have a problem: it looks like there is no historic data available in google finance for industry groups (sectors work fine). Do you have any clue how i could get (at least) the data from the past 3 months?

Otherwise: you said, that you update the SCTR score in your Sheet every weekend. That would be fine for me - but: where do you get the 1-,4- and 12-week data from? Is there any trick or is that a premium stockcharts.com feature only?

Would be happy about an answer from you!