StockFetcher Forums · Filter Exchange · Suggestions for a modification of this basic scan?<< >>Post Follow-up
jhenninger
63 posts
msg #51009
Ignore jhenninger
4/11/2007 8:11:46 AM

I'm working with some very basic RSI scans, and the one I am using right now is:

"Show stocks where RSI(3) is above 95
and Average Volume(30) is above 300000
and close is between 5 and 250"

I occasionally adjust the RSI period and value dependent on overall market conditions. However, I noticed that this scan didn't find GMO because it's 3-period RSI doesn't quite fit the qualifications. I was thinking about adding some sort of volume filter to this that would account for either a single bar volume extreme (say yesterday's volume is 50% greater than the 10 day volume average -- not sure of the correct stockfetcher syntax, or possibly a multiple day volume filter that might look for the 5 day average to be above the 30 day average by 50% or more.

My question is what do you experienced stockfether gurus suggest? And secondly, could anyone help me with the syntax itself? I can easily mess around with the above ideas, but without the syntax my ideas are pretty much useless.

Thanks, I really appreciate it ...

Jon (jmiles301@gmail.com)

nikoschopen
2,824 posts
msg #51013
Ignore nikoschopen
4/11/2007 12:10:17 PM

Not being one of the RSI gurus, I'm not qualified to comment. But here's the quick way to get around the volume thang.

"yesterday's volume is 50% greater than the 10 day volume average"
Fetcher[
Show stocks where RSI(3) is above 95
and Average Volume(30) is above 300000
and close is between 5 and 250

set{volratio, volume 1 day ago / avgvol(10)}
set{ratio, volratio * 100}
ratio above 149
set{ratio%, ratio - 100}
add column volume 1 day ago{Vol 1-day ago}
add column avgvol(10)
add column ratio%
]




"or possibly a multiple day volume filter that might look for the 5 day average to be above the 30 day average by 50% or more"
Fetcher[
Show stocks where RSI(3) is above 95
and Average Volume(30) is above 300000
and close is between 5 and 250

set{volratio, avgvol(5) / avgvol(30)}
set{ratio, volratio * 100}
ratio above 149
set{ratio%, volratio - 100}
add column avgvol(5)
add column avgvol(30)
add column ratio
]



jhenninger
63 posts
msg #51020
Ignore jhenninger
4/11/2007 3:56:41 PM

thank you for your help. that is precisely the filter syntax that i was looking for. appreciate it.

jon

StockFetcher Forums · Filter Exchange · Suggestions for a modification of this basic scan?<< >>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