Watchlist column available for Relative Strength Scan

Ok, when markets are open, this works. When markets are closed, it does not. You have been warned.

This is the code to show red or green background on the watchlist based on the relative strength of the ticker symbol in that row, as compared to the ticker symbol you select for “CorrelationWithSecurity”. The default value being “SPX”. Please note the user input “referenceDate” must be set to a day in which markets were open. The custom column must be set to daily. If you want details on the source of this code you will want to view the following video: https://www.hahn-tech.com/thinkorswim-scan-relative-strength/

input CorrelationWithSecurity = "SPX";
input referenceDate = 20171201;
def close2 = close(symbol = 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; plot data = RS > SRatio;
AssignBackgroundColor(if data then Color.GREEN else Color.CURRENT);

Screenshot below shows the result.

I did not provide code for the “RSI Crossover” because that portion of the request lacked specific details. I suggest you post that as a new question and consider the following. How are the colors determined? RSI Crossing over what? Should the color change for only on the bar a crossover occurs or should the color remain the same color until the next opposite crossover?

Keep in mind that “RSI”… http://tlc.thinkorswim.com/center/reference/Tech-Indicators/studies-library/R-S/RSI.html

…is not the same as “Relative Strength” http://tlc.thinkorswim.com/center/reference/Tech-Indicators/studies-library/R-S/RelativeStrength.html