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,529 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,529 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.
 
  |