Bruce good monday morning 

some while back you had worked an idea on ZIGZAG line overlaid on price in custom pcf

But my question here is slightly different i want to use a Filter  in terms of percentage

So can you please make a custom PCF line that can be overlayed on price when Peak to trough reverses direction only after tickers direction moves atleast 5% away from its previous peak or trough

and another custom pcf overlay when peak to trough reverses direction only after tickers directions moves atleast 13% away from its previous peak or trough

thanks

So far the lack of recursive functions has made this request non-trivial. I may still be able to do it, but it is going to be complicated if I can do so (unless I have some sort of eureka moment).

hahaha :) Bruce you have worked on several Eureka moments, so no worries take your time will check closer to end of week , 

Meanwhile one more non related question  

how to modify this below pcf to be true using SGN " function or some other idea to get two consecutive back to back bars  or within two bars of each other in last 20 bars 

I am not quite sure what you want. Do you just want to return true when that formula at least twice in a span of two bars at least one in a span of twenty bars?

CountTrue(CountTrue(ABS(C - O) < .45 * ABS(H - L) AND H > H - .45 * ABS(H - L) AND C < H - .45 * ABS(H - L) AND O < H - .45 * ABS(H - L), 3) >= 2, 20) > 0

And:

CountTrue(CountTrue(ABS(C - O) < .45 * ABS(H - L) AND L < L + .45 * ABS(H - L) AND C > L + .45 * ABS(H - L) AND O > L + .45 * ABS(H - L), 3) >= 2, 20) > 0

Or are you looking for something else?

Bruce don't know how to answer your question in a best way but this is the way i see on chart ,, attached is the link for my first pcf in red highlighted bars where the pcf shows two bars consecutively and or within two bars of each other

https://www.dhirenshah.com/320-2/

same for the my second pcf in green highlighted bars where the pcf shows two bars consecutively and or within two bars of each other 

https://www.dhirenshah.com/323-2/

So i want to scan or sort the list when the cluster of red or green happens in last 20 bars 

thanks

I have made an alteration to the formulas in my original response (I had copied more of your original formulas than I should have into my formulas). Please try the newer versions.

No Bruce count true in last 20 bars the pcf seems to attract almost continuosly. so what should be corrected if we just want spike when 2 bars back to back next to each other happens lets forget about within 20 bars

Like for example this below pcf i use when price xup 8ema high 2 bars in a row 

SGN(C - XAVGH8) = SGN(C1 - XAVGH8.1) AND SGN(C1 - XAVGH8.1) > SGN(C2 - XAVGH8.2)

so can the same be done using SGN function for pcf I Posted : 11 March 2019 15:37:36

Really, all you need to do is get rid of the CountTrue( ,20) > 0 portion of each formula to create the conditions.

CountTrue(ABS(C - O) < .45 * ABS(H - L) AND H > H - .45 * ABS(H - L) AND C < H - .45 * ABS(H - L) AND O < H - .45 * ABS(H - L), 3) >= 2

And:

CountTrue(ABS(C - O) < .45 * ABS(H - L) AND L < L + .45 * ABS(H - L) AND C > L + .45 * ABS(H - L) AND O > L + .45 * ABS(H - L), 3) >= 2

Yup thats all I needed.... thankyou 

Now will wait for the eureka moment of my other question on zigzag :)

Cheers

Just an update. No Eureka moment so far.

Noted Bruce ... take your time may be weekend rest will help :)

Bruce any luck with turning point query ?/ my top first question in this post 

I was thinking what if you improvise on clear bar theory using this below formula that you had computed in past and if we can put percentages to match peaks and troughs in them 

That formula is really marking continuations, not pivots.