Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Worden Discussion Forum » Customer Training & Support » Ask a Trainer - TC2000 version 7 » PCF formula

PCF formula Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
chartman2
Posted : Monday, March 14, 2005 4:49:26 PM
Gold Customer Gold Customer

Joined: 12/30/2004
Posts: 7
 I am trying to write a PCF to show me the 20 EMA that is turning up within the last 7 days.
I have XAVGC20.7 < XAVC20 Is this correct?
Back to top
Craig_S
Posted : Monday, March 14, 2005 4:52:21 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
 Sure. Try this one, though. It will give you some more info:

(XAVGC20-XAVGC20.7)/AVGC20.7*100

This will return the percent change in the average over the last 7 trading days. Now you can not only say up (values above 0) you can say down (values below 0) AND you can specify by how much in either direction (if you like). It also makes it a nifty sort condition.
- Craig
Here to Help!
Back to top
chartman2
Posted : Monday, March 14, 2005 5:22:57 PM
Gold Customer Gold Customer

Joined: 12/30/2004
Posts: 7
 Thanks that is much better.
Back to top
Craig_S
Posted : Monday, March 14, 2005 5:39:28 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
 Great! You may also enjoy this great video on PCFs by Doug:

Constructing more versatile and reusable Personal Criteria Formulas
- Craig
Here to Help!
Back to top
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.