| sunspore 22 posts
 msg #144777
 - Ignore sunspore
 | 9/27/2018 8:07:32 PM 
 Hi,
 New to this, so bear with me...
 Looking for a way to encapsulate (nest?) a condition, into a lookback period - look for it a specified number of days back, or during a certain historical time frame.
 For instance, if I wanted to find this chart pattern on any stock 10 days ago, or within the last 2 months:
 
 Find stocks where Close above open
 And Close 1 day ago was below the open 1 day ago
 And High is above high 1 day ago
 And Low is below low 1 day ago
 
 I would have thought you could use parentheses and then define the lookback condition:
 
 Find stocks where (Close above open
 And Close 1 day ago was below the open 1 day ago
 And High is above high 1 day ago
 And Low is below low 1 day ago)
 10 days ago
 
 But that doesn't seem to work. Any help is greatly appreciated.
 
 
 
 | 
| four 5,087 posts
 msg #144778
 - Ignore four
 modified
 | 9/27/2018 11:38:09 PM 
 perhaps... run your filter and then use the drop-down
 
 
  
 
 | 
| four 5,087 posts
 msg #144779
 - Ignore four
 modified
 | 9/27/2018 11:43:34 PM 
 perhaps... build into filter
 
 YOUR ORIGINAL
 Find stocks where (Close above open
 And Close 1 day ago was below the open 1 day ago
 And High is above high 1 day ago
 And Low is below low 1 day ago)
 10 days ago
 MODIFIED
 Close 10 days ago above open 10 days ago
 And Close 11 day ago was below the open 11 day ago
 And High 10 days ago  is above high 11 day ago
 And Low 10 days ago is below low 11 day ago
 
 
 
 |