Registered User Joined: 12/2/2004 Posts: 1,775
|
I have a pcf that I added to conditions in an easy scan for price vs. 10-day sma, 100 * (C / AVGC10).
The problem is that I want to edit the condition in the easy scan by sliding the vertical value scale so that price percentage is at minimum on the low end and up to but not over 12% on the upper end. The edit scale will not let me set it at 12% for upper limit, only 10% and lower except for max.
In otherwords, the next increment down from Max is the value of 110.2541 (10.2541% price above 10day sma), nothing above that except MAX. Doesn't matter if I click the little down arrow of MAX or grab top of blue bar and pull down the smallest distance possible, the next percentage down from max is around 10%, nothing inbetween 10% and max.
Request if possible a pcf for price vs. 10-day simple moving average from minimum (price can be any distance percentage below the 10-day to +12% above the 10-day.
Thanks.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You could adjust the percentages in a Personal Criteria Formula similar to the following:
(-10) <= 100 * (C / AVGC10 - 1) AND 100 * (C / AVGC10 - 1) <= 12
The left number is the lower range of the Percent Change while the right number is the upper range of the Percent Change. If the number is negative, it needs to be in parentheses.
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 12/2/2004 Posts: 1,775
|
Thanks a ton Bruce L, just exactly what I was looking for...and easy to adjust and experiment with the percentages as you imply.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 10/23/2004 Posts: 251
|
Hi, Bruce can you please write me PCF Price 10% less above/below within 10-Simple Day moving average in weekly chart.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Naresh,
Please try the following:
ABS(10 * C / (C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45) - 1) <= .1
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 10/23/2004 Posts: 251
|
Thanks!
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Naresh,
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|