Hello

I am looking for a formula to find consolidation of min 5 bars with LOW clearance about 5c

I try to make it as 

Please try the following.

TrueInRow(ABS(L - L1) <= .05, 4) = 4

Dear Bruce

Thank you. It's seems it works.

Please clarify TrueInRow check boolean condition  in a row with summing result

for each bar from offset 

I mean if offset 4 as example bars with names ABCD it  check for formula from a position of bar

A is ABS(L - L1) <= .05  ok if yes = 1

B is ABS(L - L1) <= .05  ok if yes = 1

C is ABS(L - L1) <= .05  ok if yes = 1

D is ABS(L - L1) <= .05  ok if yes = 1

So it mean I dont need to use L1 L2 L3 L4........ 

If it possible to play song when new share appears in filter?

Thanks again.

By the way, I don\t know why but if I use 

ABS(L - L1) <= .05  if show formula error, if I use

ABS(L - L1) <= 1/20 - it's work 

why formula field not  support .05 ?

If you just want a sum of the number of bars where it is true, you can use CountTrue() instead of TrueInRow(). The difference is that TrueInRow() requires the most recent bars to be true consecutively in order to be counted where CountTrue() does not.

If your computer has the , set to the decimal marker instead of using the . as the decimal marker as is more usual in the United States, you will want to use fractions instead of decimals to avoid errors.

it seems the , not work as the .

http://prntscr.com/mbrqov

but 1/20 instead of 0.05 or 0,05 work good ))

http://prntscr.com/mbrq1v

Yes, you are definitely going to want to use a fraction instead of a decimal as mentioned in my previous response.

The issue is that the stuff that gets calculated on your computer is going to require the decimal marker as the , while the stuff that gets calculated on our servers require the . as the decimal marker. Since some stuff gets calculated in both places, you really can't get away with using either the . or the , as the decimal marker if you have the , set as the decimal marker on your computer.