whmc
6 posts
msg #103267
- Ignore whmc |
11/8/2011 6:04:50 PM
I am trying to figure out how to do a filter (or find one) that will find a stock that has moved into a previous down gap. For example, a stock gaps down after earnings (or for any other reason) and continues down or sideways after that. Eventually it starts back up. I would like to find out when the stock has moved back into the gap. Suggestions? (I think I posted this in the wrong place to start).
|
TheRumpledOne
6,411 posts
msg #103271
- Ignore TheRumpledOne
modified |
11/9/2011 7:57:18 AM
This is a start.
This will display stocks that gapped down TODAY and closed inside or above the gap.
But if the gap happened 1 or more days ago, this filter won't display that. Have to work on that.
This second version will get you closer to what you want.
When GAPDOWN = 1, the stock gapped down. Column GD-1 is 1 when stock gapped down 1 day ago.
GAPDAYS is the number of days since the most recent gap down.
CLOP is 1 when the close is above the open. CLOP-1 is when TODAY'S CLOSE is above the open 1 DAY AGO.
So if it has been 2 days since a stock gapped down, you would look at the CLOP-2 column to check if the stock close in the gap or above it.
You could write filters to display all stocks that are in/above the gap for 1 day ago, 2 days ago, etc...
|
djones000buck
206 posts
msg #103273
- Ignore djones000buck |
11/9/2011 9:31:27 AM
Just a quick and dirty statistical filter based on your first example. Just added it to an old stat display..
|
Eman93
4,750 posts
msg #103279
- Ignore Eman93 |
11/9/2011 7:13:08 PM
This is the whole problem with stock fetcher you can not store a price value....
For example you want to see any stock that gaped down more than 8% in last 6 months and price is above the open of the gap down day... not happening here bro...
I like the idea the vacuum is a good trade....
you just need to keep track manually and set a price alert.. so every day you run the filter to show stocks the gap down 8% then set a price alert for the open?
You would think it would be easy but SF just wants your dollars and not add anything.
|
TheRumpledOne
6,411 posts
msg #103285
- Ignore TheRumpledOne |
11/10/2011 11:30:09 AM
True, you can't store a value.
There are somethings that SF just can't do (at the moment).
Overall, IMHO, SF is the best dollar value for filtering and running reports.
|
whmc
6 posts
msg #103297
- Ignore whmc |
11/11/2011 9:07:11 AM
Thanks for the input. I will be working on them and let you know how it goes.
|