New Members: Be sure to confirm your email address by clicking on the link that was sent to your email inbox. You will not be able to post messages until you click that link.
Having Max() return a date instead of price
I am using this scanner code to find stocks that their 253 days low is less or equal than 1.1 and also the 253 days max is 3.5 equal or more
The problem is I want the 253 days max of 3.5 to be true only forward looking AFTER the 253 days min(253,low) <= 1.1 is found and don't care about maxes before this 1.1 low how to accomplish this?
here is the flawed code I currently use:
[type is stock] and [country = US] and [PctDiff(today's low,max(253,high)) <= -50] and [ max(253,high) >= 3.5 ] and [min(253,low) <= 1.1] and [ volume > 1200000 ]