Optuma Forums › Optuma Scripting › Normalizing Formula Results In A Watchlist › Reply To: Normalizing Formula Results In A Watchlist
April 5, 2022 at 6:04 pm
#67893
- Topics: 70
- Replies: 788
- Posts: 858
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.
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: