| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 1/10/2008
Posts: 98
|
I Use Detrend price Oscillator with a setting of 21. I need to convert the absolutes values on Y axis to a a % value.
Can You Help?
Thanks
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I guess you could use the following formula as a Custom PCF Indicator:
100 * (C / AVGC21.12 - 1)
Instead of the actual formula for a 21-Period DPO which would be:
C - AVGC21.12
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/10/2008
Posts: 98
|
When you say (C / AVGC21.12 - 1)
You mean C / (AVG21.12-1) OR (C / AVG21.12) -1 ?
I presume that is the first, right?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
No, the second is correct. The order of operations but division before subtraction.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/10/2008
Posts: 98
|
Bruce
Putting this formula give me negative values.
I would want values from to 100%
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Then you will need to describe the algorithm you wish to use for the calculations. There is no particularly obvious way to make such a conversion of a completely undbounded into a bounded indicator ranging from 0 to 100.
Price can be both above and below its offset moving average. The positive numbers represent price being above the moving average by that perentage and the negative numbers represent price being below the moving average by that percentage.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |