StockFetcher Forums · Filter Exchange · Someone please help with this filter.<< >>Post Follow-up
stockupgirl
6 posts
msg #101054
Ignore stockupgirl
6/3/2011 9:41:42 PM

Can someone please help me with the formula (filter) to screen for this?
I'm looking for stocks from .001 to .05. with a 1 day volume spike of 7 times to 10 times the 10 day volume average. I would like it to show the volume for the day and the 10 day volume average. also I want the column to show high, low, close and previous close. and I want the share price to be near the bottom or 52 week low. Please someone help. I've tried everyhing and i'm going nuts.

Cacher
121 posts
msg #101071
Ignore Cacher
modified
6/4/2011 8:17:29 PM

Here you go....

Fetcher[
Price is between .001 and .05

set{ v7,average volume(10) *7}
set{ v10,average volume(10) * 10}
volume is between V7 and V10

draw average volume(10) on volume chart

add column low
add column high
add column close

add column close 1 day ago

close less than 15 percent above the 52 week low
]




.... now the bad news .... logically it should work fine....but the coding has a bug, maybe someone can shed some light on

why SF doesn't like this :
set{ v7,average volume(10) *7}
set{ v10,average volume(10) * 10}
volume is between V7 and V10

it works when modified to read:
set{ v7,average volume(10) *7}
set{ v10,average volume(10) * 10}
volume is greater than v7

it works when modified to read:
set{ v7,average volume(10) *7}
set{ v10,average volume(10) * 10}
volume is less than v10

...but it does not like the original "between" statement ...???.... any thoughts ???




Kevin_in_GA
4,548 posts
msg #101072
Ignore Kevin_in_GA
6/4/2011 8:44:26 PM

Just do this:

set{ v7,average volume(10) *7}
set{ v10,average volume(10) * 10}
volume is above V7
volume is below V10


rudolf100
6 posts
msg #101073
Ignore rudolf100
6/4/2011 9:38:05 PM

Here's what I came up with:


Fetcher[

Show stocks where price is less than 10% above the 52 week low
and Volume is more than 700% above the average volume(10) 1 day ago
and price is between .001 and .05

and add column Average Volume(10) {10 day Avg Vol}
and add column Todays High {Daily High}
and add column Todays Low {Daily Low}
and add column Close 1 day ago {Prev Close}
and add column price 52 week low {52 week low}
and add column Volume ROC(11) {daily vol chg}

]



Cacher
121 posts
msg #101074
Ignore Cacher
6/4/2011 9:43:47 PM

Thanks Kevin ...that works.... I had done that too...but was trying to understand what was wrong with my "between" code .... but sometimes you just have to say, if it works , then don't fix it .... and those 2 lines of code make it work.... thanks ... much appreciated !

so here is the working model,

(also needed to move the draw command...don't know why., but with the "new edits", the draw command then caused the screen to fail, and the need to "debug" ... hmmmmmm....so,.all I did to fix this failure was to move it above the coding of the averages..... it works now... don't know why ... but it does!

Fetcher[
Price is between .001 and .05

draw average volume(10) on volume chart

set{ v7,average volume(10) *7}
set{ v10,average volume(10) * 10}
volume is above V7
volume is below V10

add column low
add column high
add column close

add column close 1 day ago

close less than 15 percent above the 52 week low
]



......there are no results right now, but expanding variable ranges show that the screen is fully functional.

Cacher
121 posts
msg #101076
Ignore Cacher
6/4/2011 9:59:22 PM

I always enjoy seeing a different way to do the same job .... so this code seems right on target, (with 1 additional line ) ... but the results are different .... time to get the thinking cap on.

rudolf100...hope you don't mind, butt I tweeked it .", to be more like stockupgirls text. (at least my interpretation)

Fetcher[
Show stocks where price is less than 15% above the 52 week low
and Volume is more than 700% above the average volume(10) 1 day ago
and Volume is less than 1000% above the average volume(10) 1 day ago
and price is between .001 and .05

and add column Average Volume(10) {10 day Avg Vol}
and add column Todays High {Daily High}
and add column Todays Low {Daily Low}
and add column Close 1 day ago {Prev Close}
and add column price 52 week low {52 week low}
and add column Volume ROC(11) {daily vol chg}
]



stockupgirl
6 posts
msg #101105
Ignore stockupgirl
6/6/2011 4:58:17 PM

Thank you everyone.

StockFetcher Forums · Filter Exchange · Someone please help with this filter.<< >>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