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....
.... 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,599 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:
|
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!
......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)
|
stockupgirl
6 posts
msg #101105
- Ignore stockupgirl |
6/6/2011 4:58:17 PM
Thank you everyone.
|