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 » $2 average

$2 average Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
nicky
Posted : Wednesday, December 27, 2006 4:58:09 PM
Registered User
Joined: 10/7/2004
Posts: 57
 how can i write a pcf that will pull out stocks that have a average $2 move from high to low and today only moved a $1 or less
Back to top
diceman
Posted : Wednesday, December 27, 2006 7:08:22 PM
Registered User
Joined: 1/28/2005
Posts: 6,049
 Try this:

H-L>=2ANDABS(C-C1)<=1

Not sure what you mean by "average high to low".

You must decide on an exact value.
(I used 2$)

(Average would change with the amount
of stocks you look at)

You did not say if the 1$ move should be
up or down so I used ABS. (1$ change)

Thanks
diceman
Back to top
Craig_S
Posted : Thursday, December 28, 2006 6:48:58 AM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
 A few quetsions:

1. Do you want AT LEAST $2 or LESS THAN $2 or BETWEEN X and Y values? I doubt you want an average that is EXACTLY $2.

2. Over how many days should the average daily range be measured? For how many days should the daily range meet your requirement?
- 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.