| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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
|
|
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
|
|
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!
|
|
|
Guest-1 |