Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

PCF for range percentage of price below and above 10-day sma? Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
fpetry
Posted : Thursday, December 9, 2010 2:12:37 PM
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.

Bruce_L
Posted : Thursday, December 9, 2010 2:21:39 PM


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
fpetry
Posted : Thursday, December 9, 2010 2:45:37 PM
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.
Bruce_L
Posted : Thursday, December 9, 2010 2:48:40 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
You're welcome.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Naresh
Posted : Monday, December 13, 2010 10:36:42 AM
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.
Bruce_L
Posted : Monday, December 13, 2010 10:43:01 AM


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
Naresh
Posted : Monday, December 13, 2010 10:50:26 AM
Registered User
Joined: 10/23/2004
Posts: 251
Thanks!
Bruce_L
Posted : Monday, December 13, 2010 10:54:27 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
Naresh,
You're welcome.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.