Normalizing Formula Results In A Watchlist

Optuma Scripting
1

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

2

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)

$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:

Capture