StockFetcher Forums · General Discussion · Simple Syntax help<< 1 2 3 >>Post Follow-up
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



Fetcher[
not otcbb
avgvol(90) > 500000

set{75pct,.75}
set{v90,avgvol(90)}
set{v90times75pct,v90 * 75pct}
set{v90plus75,v90 plus v90times75pct}


set{timeslast5days,count(volume above v90plus75,5)}
set{today,count(volume above v90plus75,1)}

today equals 1


add column average volume(90)
add column v90plus75
add column today
add column timeslast5days

do not draw average volume(10)
do not draw v90plus75
]



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

Fetcher[
set{hivol, average volume(90) * 1.75}
volume within the last 5 days above hivol
]



and it didn't seem to work. Gives a syntax error in debug.


Actually, looking at your filter again, would this be it?

Fetcher[
not otcbb
avgvol(90) > 500000

set{75pct,.75}
set{v90,avgvol(90)}
set{v90times75pct,v90 * 75pct}
set{v90plus75,v90 plus v90times75pct}

count(volume above v90plus75,5) above 0.5

add column average volume(90)
add column v90plus75
add column timeslast5days

do not draw average volume(10)
do not draw v90plus75
]






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"



Fetcher[
not otcbb
avgvol(90) > 500000

set{75pct,.75}
set{v90,avgvol(90)}
set{v90times75pct,v90 * 75pct}
set{v90plus75,v90 plus v90times75pct}


set{timeslast5days,count(volume above v90plus75,5)}
set{today,count(volume above v90plus75,1)}

volume below v90plus75


add column average volume(90)
add column v90plus75
add column today
add column timeslast5days

do not draw average volume(10)
do not draw v90plus75
]



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


Fetcher[
not otcbb
avgvol(90) > 500000

set{75pct,.75}
set{v90,avgvol(90)}
set{v90times75pct,v90 * 75pct}
set{v90plus75,v90 plus v90times75pct}


set{timeslast5days,count(volume above v90plus75,5)}
set{today,count(volume above v90plus75,1)}

today equals 1


add column average volume(90)
add column v90plus75
add column today
add column timeslast5days

do not draw average volume(10)
do not draw v90plus75
]



StockFetcher Forums · General Discussion · Simple Syntax help<< 1 2 3 >>Post Follow-up

*** Disclaimer *** StockFetcher.com does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. StockFetcher.com does not recommend particular securities. StockFetcher.com, Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.


Copyright 2016 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus