Normalizing Formula Results In A Watchlist

Optuma Forums Optuma Scripting Normalizing Formula Results In A Watchlist

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #67891
    Louis
    • Topics: 33
    • Replies: 55
    • Posts: 88

    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

    #67893
    Darren
    • 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.

    $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

    1 user thanked author for this post.
Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.

Pin It on Pinterest