- This topic has 1 reply, 2 voices, and was last updated 10 months ago by .
Viewing 2 posts - 1 through 2 (of 2 total)
Viewing 2 posts - 1 through 2 (of 2 total)
- You must be logged in to reply to this topic.
Optuma Forums › Optuma Scripting › Normalizing Formula Results In A Watchlist
Tagged: Watchlist, normalize, stochastic
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
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:
Cookie | Duration | Description |
---|---|---|
cname | 14 days | This cookie is set by Optuma. The cookies is used to store the users campaign selection for selecting the correct version of Optuma to trial and is "Necessary". |
cookielawinfo-checbox-analytics | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics". |
cookielawinfo-checbox-functional | 11 months | The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". |
cookielawinfo-checbox-others | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other. |
cookielawinfo-checkbox-necessary | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary". |
cookielawinfo-checkbox-performance | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance". |
viewed_cookie_policy | 11 months | The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data. |