Scanning for the first 200 day New High after a 200 day New Low

Answers

• Options

  markd mod

  January 2 edited January 2

  I'm assuming you mean the first new 200 day high after after the last LOWER (or new) 200 day low (you could have a higher low 200 days ago, vs. 201,2,3 etc. days ago).
  
  If you make the assumption that the 200 day price channels are falling when the new 200 day high occurs, your scan could be this:
  
  [exchange is NASD] // or whatever
  
  and [high x 1 day ago Upper Price Chan(200)]
  and [Upper Price Chan(200) = min(200, Upper Price Chan(200))]
  
  and [Lower Price Chan(200) = min(200, Lower Price Chan(200))]
  
  The mins insure the channels have been falling and haven't ticked up any time in the last 200 days.
  
  But, it may be the case that both channels do NOT have to be falling or flat to meet your first 200 day new high condition. It may be possible that the Lower channel can start rising before price gets back above the upper channel. Also, there may be special cases where sharp price changes mean you could get a new low and a new high within a say a couple of weeks or a month. But that implies a narrow range or a special situation - something probably not tradable.
  
  The code above does get valid results, but not many, possibly due to the state of the market. You could set the start date back to see what happens.
  
  
  
  
  
  

  0
• Options

  bwschupp ✭

  January 4

  Hi markd, Thank you very much for your assistance. I'll go give it a try. Stay well!

  0