AdamW328
84 posts
msg #78901
- Ignore AdamW328 |
9/9/2009 7:45:35 PM
Hello, what is the proper syntax for the following:
Volume 75% above average volume(90) within the last 5 days
What I am looking for here is for volume to be 75% above the average volume(90). I would like to find stocks that have had this volume increase for any of the last 5 trading days (including the current day)
Your help is appreciated!
|
chetron
2,817 posts
msg #78902
- Ignore chetron
modified |
9/9/2009 7:50:47 PM
if you use "within" you must use "crossed above/below" also......
wow, this is messed up.
tro, can you help? tia
|
trendscanner
265 posts
msg #78917
- Ignore trendscanner
modified |
9/9/2009 9:53:18 PM
Just figured out this is more complicated than it looks at first glance.
|
AdamW328
84 posts
msg #78936
- Ignore AdamW328 |
9/10/2009 7:37:59 AM
Yeah, it seems simple but not so much.
Can anyone else out there figure this out?
Thanks!
|
welliott111
98 posts
msg #78974
- Ignore welliott111 |
9/10/2009 4:48:38 PM
|
trendscanner
265 posts
msg #78989
- Ignore trendscanner
modified |
9/10/2009 8:42:09 PM
I've been pondering this and can't think of how to do it simply in SF language. The number of daily volume combinations that could meet this criteria is 5 factorial or 60 combinations.
Welliott, I'm not sure your filter is capturing all of the possible combinations. I think it's capturing only hi vol days that include today as a hi vol day. If you include the line
"volume below v90plus75"
in the filter, shouldn't it show all of the hits over the last 5 days except for today when volume was above v90plus75 ? I tried it and it didn't return any hits, with that line included. Maybe it's right, I don't know. Or maybe there's some easy way to do it.
I tried
and it didn't seem to work. Gives a syntax error in debug.
Actually, looking at your filter again, would this be it?
|
welliott111
98 posts
msg #78993
- Ignore welliott111 |
9/10/2009 9:14:30 PM
To get "volume BELOW v90plus75" to work you have to remove "today equals 1"
|
trendscanner
265 posts
msg #78994
- Ignore trendscanner |
9/10/2009 9:31:22 PM
Got it! THANKS! Still learning to speak Stock Fetcherese
|
AdamW328
84 posts
msg #79000
- Ignore AdamW328 |
9/10/2009 10:15:45 PM
Trendscanner and Welliot thanks for your help!
Did we figure it out? I am looking for the volume to be ABOVE 75% as your syntax says below but that is just a simple error....
Please let me know if this returns the needed results. I will post the full scan if this is correct and it will post some great shorts at there top. We know this market can't go up forever and I would luv to share my filter now when I think we are reaching a top.
Again, your help has been appreciated!
|
welliott111
98 posts
msg #79001
- Ignore welliott111 |
9/10/2009 10:28:15 PM
Try this one Adam, and let us know if it works for you
1 in "today" column means volume was >75% above avgvol(90) "today"
timeslast5days column is self-explanatory
|