timfor 17 posts msg #70955 - Ignore timfor |
1/26/2009 11:31:27 AM
Hello,
I am struggling with a basic filter and as a newbie I'm hoping someone can help me. I've read the instructions, etc. but I must be doing something wrong. I hope someone will be willing to help me out.
What I want is a filter that looks for stocks that have a total price movement of at least four dollars on average over a period of 5 days. For clarification sake, here is what I mean by "total price movement".
Fictitious stock ABC Corp has the following price action:
Day 1: Low $10, High $15...total price movement for day = $5 ($15-$10=$5)
Day 2: Low $12, High $15...total price movement for day= $3 ($15-$12=$3)
Day 3: Low $12, High $17...total price movement for day= $5 ($17-$12=$5)
Day 4: Low $14, High $18...total price movement for day= $4 ($18-$14=$4)
Day 5: Low $12, High $15...total price movement for day= $3 ($15-$12=$3)
So, total of $5+$3+$5+$4+$3 = $20 divided by five days and you get an average of $4 of total price movement per day.
Here is the filter I wrote:
Average Day Point Range(5) greater than or equal to 4.0
and Average Volume(90) above 500000
and Open above 7.00
and Close below 40
This doesn't seem to be giving me the results that I think it should.
Can someone please point out what I'm doing wrong?
Thanks in advance for any assistance you can provide.
Tim
|