Narrow range counter

• 12/02/2021 at 12:02 PM #182705
  Alfy

  Good morning guys, i hope you are all keeping well. I wondered if anyone could help me. Im looking to build a counter that counts for how many days todays range is the narrowest. I describe range as either open versus close or high-low i don’t mind which. So for example, if todays range was 50 cents and it was the narrowest range of the last 3 days then the answer would be 3. Thanks in advance for any help you can offer.

  

  Alfy

  Participant

  Topics: 34

  Replies: 53

  Been thanked: 5 times
  12/02/2021 at 12:51 PM #182710
  robertogozzi

  There you go:

  N = 500 //LookBack period //MyRange = range MyRange = abs(open - close) Result = 0 FOR i = N DOWNTO 2 IF MyRange = lowest[i](MyRange) THEN Result = i break ENDIF NEXT RETURN i AS "Count"

  1 2 3 4 5 6 7 8 9 10 11

  N       = 500      //LookBack period //MyRange = range MyRange = abs(open - close) Result = 0 FOR i = N DOWNTO 2    IF MyRange = lowest[i](MyRange) THEN       Result = i       break    ENDIF NEXT RETURN i AS "Count"

  You can select the type of range in lines 2 and 3, just comment out the one you don’t want to use (now it’s OPEN-CLOSE).

  N is the lookback period to scan, 500 hundred bars is quite high, with more than 1K units it could be slow.

  Using the indicator’s settings you may make it an histogram.

   

   

  1 user thanked author for this post.

  Alfy

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17151

  Been thanked: 4040 times
  12/02/2021 at 2:20 PM #182719
  Alfy

  Hi Roberto, first of all thank you. The indicator works well for high -low but with open-close i forgot that some days the open close would be negative numbers. Is there a way of normalising the open close numbers so that all days are positive and then the indicator picks up the lowest number irrespective of whether the open close difference was up or down on the day please?

  

  Alfy

  Participant

  Topics: 34

  Replies: 53

  Been thanked: 5 times
  12/02/2021 at 3:21 PM #182725
  robertogozzi

  It already turns negative numbers into positive ones with ABS() in line 3.

   

  1 user thanked author for this post.

  Alfy

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17151

  Been thanked: 4040 times
  12/02/2021 at 3:30 PM #182727
  Alfy

  Oh thanks so much for explaining that!

  

  Alfy

  Participant

  Topics: 34

  Replies: 53

  Been thanked: 5 times
• Author
  Posts