Relative Strength crossover

I updated the title of your question to distinguish it from your previous post: https://www.hahn-tech.com/ans/watchlist-column-available-for-relative-strength-scan/

So glad you included your code as well as a clear description of what you are trying to achieve.

First item to mention is that we want to remove the AddChartBubble() statement. This may or may not cause the code to fail. Better safe than sorry.

Aside from that, I really don’t see any attempts to modify the code as you specified. This looks just like the code I presented in the video. Not sure that was your intention. As such, I really don’t have anything to explain about your attempt. So I will just provide the working code here:

input CorrelationWithSecurity = “SPX”;
input referenceDate = 20180402;
def close2 = close(CorrelationWithSecurity);
def RS = if close2 == 0 then 0 else close/close2;
def startDate = DaysFromDate(referenceDate) == 0;
def sr = CompoundValue(“historical data” = RS[0], “visible data” = if startDate <= 0 then sr[1] else RS[0]);
def SRatio = sr;
def crossingAbove = RS[1] < SRatio[1] and RS > SRatio;
def crossingBelow = RS[1] > SRatio[1] and RS < SRatio;
def hasCrossedAbove = Highest(crossingAbove, 3) > 0;
def hasCrossedBelow = Highest(crossingBelow, 3) > 0;
plot data = if hasCrossedAbove then 1 else if hasCrossedBelow then -1 else 0;
AssignBackgroundColor(if data == 1 then Color.GREEN else if data == -1 then Color.RED else Color.CURRENT);

Screenshots below shows the results. Please note, I have set the “referenceDate” input to about 6 months prior. Not sure what you had in mind by setting the date to three days ago. I understand you wanted the code to find crossovers having occurred on any of the most recent 3 bars (look back period). But setting that date to three days ago does not achieve that. What does achieve that are these two lines:

def hasCrossedAbove = Highest(crossingAbove, 3) > 0;
def hasCrossedBelow = Highest(crossingBelow, 3) > 0;

Change the value of 3 to however many days you want to look back for crossovers. I will add that the reference date must be set to more days ago then whatever value you apply to the look back period.