Registered User Joined: 3/17/2006 Posts: 16
|
Any one have a formula for finding the Stochastic(12,9,9) %K is under %D?
Basically needing a formulat to find a %K that has not crossed the %D yet.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try one of the following:
Simple:
STOC12.9 < AVG(STOC12.9,9)
Exponential:
XAVG(STOC12.1,9) < .200198266760174 * (XAVG(STOC12.1.0,9) + 8 / 10 * (XAVG(STOC12.1.1,9) + 8 / 10 * (XAVG(STOC12.1.2,9) + 8 / 10 * (XAVG(STOC12.1.3,9) + 8 / 10 * (XAVG(STOC12.1.4,9) + 8 / 10 * (XAVG(STOC12.1.5,9) + 8 / 10 * (XAVG(STOC12.1.6,9) + 8 / 10 * (XAVG(STOC12.1.7,9) + 8 / 10 * (XAVG(STOC12.1.8,9) + 8 / 10 * (XAVG(STOC12.1.9,9) + 8 / 10 * (XAVG(STOC12.1.10,9) + 8 / 10 * (XAVG(STOC12.1.11,9) + 8 / 10 * (XAVG(STOC12.1.12,9) + 8 / 10 * (XAVG(STOC12.1.13,9) + 8 / 10 * (XAVG(STOC12.1.14,9) + 8 / 10 * (XAVG(STOC12.1.15,9) + 8 / 10 * (XAVG(STOC12.1.16,9) + 8 / 10 * (XAVG(STOC12.1.17,9) + 8 / 10 * (XAVG(STOC12.1.18,9) + 8 / 10 * (XAVG(STOC12.1.19,9) + 8 / 10 * (XAVG(STOC12.1.20,9) + 8 / 10 * (XAVG(STOC12.1.21,9) + 8 / 10 * (XAVG(STOC12.1.22,9) + 8 / 10 * (XAVG(STOC12.1.23,9) + 8 / 10 * (XAVG(STOC12.1.24,9) + 8 / 10 * (XAVG(STOC12.1.25,9) + 8 / 10 * (XAVG(STOC12.1.26,9) + 8 / 10 * (XAVG(STOC12.1.27,9) + 8 / 10 * (XAVG(STOC12.1.28,9) + 8 / 10 * (XAVG(STOC12.1.29,9) + 8 / 10 * (XAVG(STOC12.1.30,9))))))))))))))))))))))))))))))))
You may be interested in the following:
Understanding Stochastics How to create a Personal Criteria Forumula (PCF) Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 3/17/2006 Posts: 16
|
Again I am in your debt
|