Normalizing Formula Results In A Watchlist

[Louis]

Hi,

I have the 11 S&P 500 sectors in a watchlist. I also have a column showing a result of a relative strength formula. I want to take the 11 results and normalize them using a stochastic calculation. What is the best way to do this?

thank you

[Darren]

Hi Louis,

Take the results and nest them in the stochastic function STOCH(), and change the %K value for the lookback period. Here’s the results for the last 22 days using the relative performance RIC.

R1=RIC(); C1=CLOSE(R1); STOCH(C1, BAR1=22, DEFAULT=%K)

1 2 3 4 5

R1=RIC(); C1=CLOSE(R1); STOCH(C1, BAR1=22, DEFAULT=%K)

$XLC is at its highest relative level over the last month, with $XLY at 99% and $XLK 95%. Both $XLI and $XLF are at their lowest relative levels:

1 user thanked author for this post.

Thomas

[Author]

Posts