billyspradling
13 posts
msg #63432
- Ignore billyspradling |
6/6/2008 11:43:50 AM
trying to make a filter that will give me stocks that have lost each month for the last 12 months and then gained for each of the last 4 weeks,
when i write the filter like this it shows some months up instead of down and the last 4 weeks some weeks down instead of up
show me stocks where the close is > 8% down for each of the last 12 months and then the close is up > 2% for each of the last 4 weeks
many thanks to anyone that can help me with this filter!!!!
|
dwiggains
448 posts
msg #63454
- Ignore dwiggains |
6/6/2008 9:29:25 PM
Hi
I have a start for you
I did not get any hits because you filter is to restrictive.
If I add anymore restrictions I get zero hits.
To finish your filter you would need to add.
close > 2% above close 5 days ago and
close 5 days ago > 2% above close 10 days ago and
close 10 days ago > 2% above close 15 days ago and
close 25 days ago >2% above close 20 days ago and
close 20 days ago > 8% below close 40 days ago
close 40 days ago > 8% below close 60 days ago
and so on till you get as many months back as you want.
Hope it helps
See ya
David
|
chetron
2,817 posts
msg #63475
- Ignore chetron
modified |
6/7/2008 3:38:10 PM
nice work, david, but you must of had your globals on. i get over 15 hits on the below.
TRO taught me to write filters in the forum as a follow up and test them in the preview message page. this works well.
|
dwiggains
448 posts
msg #63500
- Ignore dwiggains |
6/9/2008 9:13:47 AM
Thanks Chetron
Learn something everyday.
See ya
David
|