Hi Bruce 

I m platinum member with TC2000 and this is first time i m asking a question , i hope you can help,

i would please need help in creating a PCF combo to work in all time frames where my intention is

1) to make breakout entry after a first pivot is formed into stock going bullish side with first bar closing above the ichimoku current kumo,

2) and the continuation of that above pcf must be that new bars ahead forming a first pivot pulling back to make a pivot above the cloud and price remains above conversion line and conversion line remains above base line with chikou span above the bar from 26 period ago when the first pivot is formed,

3) and forward kumo has lead span A above lead span B 

4)and  formula only for this part to work with points (1 and 2) forward kumo lead span A crossing up lead span B with current price as happening 

Same pcf i need for bearish side to work in all time frames

where my intention is

5) to make breakout entry after a  first pivot is formed into the stock going bearish side with first bar closing below the ichimoku current kumo,

6) and the continuation of above pcf must be that new bars ahead forming a first pivot pulling back to make a pivot below the cloud and price remains below the conversion line and conversion line remains below the base line with chikou span below the bar from 26 periods ago when the first pivot is formed ,

7)and forward kumo has lead span A below lead span B

8) and formula only for this part to work with points (5 and 6) that forward kumo lead span A crossing down lead span B with current price as happening 

Thanks in advance,

How do you want to define a pivot? Is it just a high surrounded by a lower high on both sides or a low surrounded by a high lower on both sides, or maybe a certain number of lower highs or higher lows on both sides or something else entirely?

Where does the pivot fit into 1? How far back can the pivot occur before the first bar closes above the top of the cloud? What is the difference between this and just checking for the first bar closing above the clound?

For 2 and 3, is it just that there is a pivot above the cloud with all bars following the pivot meeting the stated requirements? If so, do the lows of the bars need to remain above the conversion line or just the closing prices?

I have no idea what is meant by 4 and will need additional clarification as to what it might mean.

Sorry Bruce i might have confused you so i will try in different way from previous notes of yours for ichimoku to explain what i need

this pcf  from forum gives me kumo breakout bullish where first bar closed outside the current kumo which is perfect

C > ((MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4 + (MAXH52.26 + MINL52.26) / 2 + ABS((MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4 - (MAXH52.26 + MINL52.26) / 2)) / 2 AND C1 <= ((MAXH9.27 + MINL9.27 + MAXH26.27 + MINL26.27) / 4 + (MAXH52.27 + MINL52.27) / 2 + ABS((MAXH9.27 + MINL9.27 + MAXH26.27 + MINL26.27) / 4 - (MAXH52.27 + MINL52.27) / 2)) / 2

now what i want is a pivot to form that is having a down day close in red  after the first bar closed outside the current kumo this may be the second day or third or fourth day , but it has to be the first day in red closing down outside the kumo breakout, and thats what i wish to scan , but the down day also has to have the closing price to be above the cloud and conversion below the close of price and base line below conversion, and forward kumo lead span A above lead span B ,and chikou span above the bar from 26 days ago,  so i need all this to work in one PCF

and this should work in all time frames and i need samething for bearish side below cloud and everything reversed as mentioned in highlighted para,

As far as point number 4 from your previous notes this is the pcf

(MAXH9 + MINL9 + MAXH26 + MINL26) / 4 > (MAXH52 + MINL52) / 2 AND (MAXH9.1 + MINL9.1 + MAXH26.1 + MINL26.1) / 4 <= (MAXH52.1 + MINL52.1) / 2

this triggers the forward lead span A crossing up lead span B with current  price action,so i want to use this formula to work with above para mentioned in yellow in a single PCF, and need the same for reverse where lead span A crossing down Lead span B,

Thanks a lot Bruce, appreciate your prompt reply,

The following formula for 2 allows for 1 to have happened up to 8 bars ago. Every OR in the formula separates the testing for each day. We can probably increase the number of bars tested beyond 8, but at some point the formula will become too long and slow to be practical or post in the forums. We could also shorten the formula to check fewer bars if 8 is overkill as this would speed things up a bit.

C1 > C AND C > ((MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4 + (MAXH52.26 + MINL52.26) / 2 + ABS((MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4 - (MAXH52.26 + MINL52.26) / 2)) / 2 AND C > (MAXH9 + MINL9) / 2 AND (MAXH9 + MINL9) / 2 > (MAXH26 + MINL26) / 2 AND C > C26 AND ((C1 > ((MAXH9.27 + MINL9.27 + MAXH26.27 + MINL26.27) / 4 + (MAXH52.27 + MINL52.27) / 2 + ABS((MAXH9.27 + MINL9.27 + MAXH26.27 + MINL26.27) / 4 - (MAXH52.27 + MINL52.27) / 2)) / 2 AND C2 <= ((MAXH9.28 + MINL9.28 + MAXH26.28 + MINL26.28) / 4 + (MAXH52.28 + MINL52.28) / 2 + ABS((MAXH9.28 + MINL9.28 + MAXH26.28 + MINL26.28) / 4 - (MAXH52.28 + MINL52.28) / 2)) / 2) OR (C1 >= C2 AND C2 > ((MAXH9.28 + MINL9.28 + MAXH26.28 + MINL26.28) / 4 + (MAXH52.28 + MINL52.28) / 2 + ABS((MAXH9.28 + MINL9.28 + MAXH26.28 + MINL26.28) / 4 - (MAXH52.28 + MINL52.28) / 2)) / 2 AND C3 <= ((MAXH9.29 + MINL9.29 + MAXH26.29 + MINL26.29) / 4 + (MAXH52.29 + MINL52.29) / 2 + ABS((MAXH9.29 + MINL9.29 + MAXH26.29 + MINL26.29) / 4 - (MAXH52.29 + MINL52.29) / 2)) / 2) OR (C1 >= C2 AND C2 >= C3 AND C3 > ((MAXH9.29 + MINL9.29 + MAXH26.29 + MINL26.29) / 4 + (MAXH52.29 + MINL52.29) / 2 + ABS((MAXH9.29 + MINL9.29 + MAXH26.29 + MINL26.29) / 4 - (MAXH52.29 + MINL52.29) / 2)) / 2 AND C4 <= ((MAXH9.30 + MINL9.30 + MAXH26.30 + MINL26.30) / 4 + (MAXH52.30 + MINL52.30) / 2 + ABS((MAXH9.30 + MINL9.30 + MAXH26.30 + MINL26.30) / 4 - (MAXH52.30 + MINL52.30) / 2)) / 2) OR (C1 >= C2 AND C2 >= C3 AND C3 >= C4 AND C4 > ((MAXH9.30 + MINL9.30 + MAXH26.30 + MINL26.30) / 4 + (MAXH52.30 + MINL52.30) / 2 + ABS((MAXH9.30 + MINL9.30 + MAXH26.30 + MINL26.30) / 4 - (MAXH52.30 + MINL52.30) / 2)) / 2 AND C5 <= ((MAXH9.31 + MINL9.31 + MAXH26.31 + MINL26.31) / 4 + (MAXH52.31 + MINL52.31) / 2 + ABS((MAXH9.31 + MINL9.31 + MAXH26.31 + MINL26.31) / 4 - (MAXH52.31 + MINL52.31) / 2)) / 2) OR (C1 >= C2 AND C2 >= C3 AND C3 >= C4 AND C4 >= C5 AND C5 > ((MAXH9.31 + MINL9.31 + MAXH26.31 + MINL26.31) / 4 + (MAXH52.31 + MINL52.31) / 2 + ABS((MAXH9.31 + MINL9.31 + MAXH26.31 + MINL26.31) / 4 - (MAXH52.31 + MINL52.31) / 2)) / 2 AND C6 <= ((MAXH9.32 + MINL9.32 + MAXH26.32 + MINL26.32) / 4 + (MAXH52.32 + MINL52.32) / 2 + ABS((MAXH9.32 + MINL9.32 + MAXH26.32 + MINL26.32) / 4 - (MAXH52.32 + MINL52.32) / 2)) / 2) OR (C1 >= C2 AND C2 >= C3 AND C3 >= C4 AND C4 >= C5 AND C5 >= C6 AND C6 > ((MAXH9.32 + MINL9.32 + MAXH26.32 + MINL26.32) / 4 + (MAXH52.32 + MINL52.32) / 2 + ABS((MAXH9.32 + MINL9.32 + MAXH26.32 + MINL26.32) / 4 - (MAXH52.32 + MINL52.32) / 2)) / 2 AND C7 <= ((MAXH9.33 + MINL9.33 + MAXH26.33 + MINL26.33) / 4 + (MAXH52.33 + MINL52.33) / 2 + ABS((MAXH9.33 + MINL9.33 + MAXH26.33 + MINL26.33) / 4 - (MAXH52.33 + MINL52.33) / 2)) / 2) OR (C1 >= C2 AND C2 >= C3 AND C3 >= C4 AND C4 >= C5 AND C5 >= C6 AND C6 >= C7 AND C7 > ((MAXH9.33 + MINL9.33 + MAXH26.33 + MINL26.33) / 4 + (MAXH52.33 + MINL52.33) / 2 + ABS((MAXH9.33 + MINL9.33 + MAXH26.33 + MINL26.33) / 4 - (MAXH52.33 + MINL52.33) / 2)) / 2 AND C8 <= ((MAXH9.34 + MINL9.34 + MAXH26.34 + MINL26.34) / 4 + (MAXH52.34 + MINL52.34) / 2 + ABS((MAXH9.34 + MINL9.34 + MAXH26.34 + MINL26.34) / 4 - (MAXH52.34 + MINL52.34) / 2)) / 2) OR (C1 >= C2 AND C2 >= C3 AND C3 >= C4 AND C4 >= C5 AND C5 >= C6 AND C6 >= C7 AND C7 >= C8 AND C8 > ((MAXH9.34 + MINL9.34 + MAXH26.34 + MINL26.34) / 4 + (MAXH52.34 + MINL52.34) / 2 + ABS((MAXH9.34 + MINL9.34 + MAXH26.34 + MINL26.34) / 4 - (MAXH52.34 + MINL52.34) / 2)) / 2 AND C9 <= ((MAXH9.35 + MINL9.35 + MAXH26.35 + MINL26.35) / 4 + (MAXH52.35 + MINL52.35) / 2 + ABS((MAXH9.35 + MINL9.35 + MAXH26.35 + MINL26.35) / 4 - (MAXH52.35 + MINL52.35) / 2)) / 2))

Adding 3 to the above formula results in:

C1 > C AND C > ((MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4 + (MAXH52.26 + MINL52.26) / 2 + ABS((MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4 - (MAXH52.26 + MINL52.26) / 2)) / 2 AND C > (MAXH9 + MINL9) / 2 AND (MAXH9 + MINL9) / 2 > (MAXH26 + MINL26) / 2 AND (MAXH9 + MINL9 + MAXH26 + MINL26) / 4 > (MAXH52 + MINL52) / 2 AND C > C26 AND ((C1 > ((MAXH9.27 + MINL9.27 + MAXH26.27 + MINL26.27) / 4 + (MAXH52.27 + MINL52.27) / 2 + ABS((MAXH9.27 + MINL9.27 + MAXH26.27 + MINL26.27) / 4 - (MAXH52.27 + MINL52.27) / 2)) / 2 AND C2 <= ((MAXH9.28 + MINL9.28 + MAXH26.28 + MINL26.28) / 4 + (MAXH52.28 + MINL52.28) / 2 + ABS((MAXH9.28 + MINL9.28 + MAXH26.28 + MINL26.28) / 4 - (MAXH52.28 + MINL52.28) / 2)) / 2) OR (C1 >= C2 AND C2 > ((MAXH9.28 + MINL9.28 + MAXH26.28 + MINL26.28) / 4 + (MAXH52.28 + MINL52.28) / 2 + ABS((MAXH9.28 + MINL9.28 + MAXH26.28 + MINL26.28) / 4 - (MAXH52.28 + MINL52.28) / 2)) / 2 AND C3 <= ((MAXH9.29 + MINL9.29 + MAXH26.29 + MINL26.29) / 4 + (MAXH52.29 + MINL52.29) / 2 + ABS((MAXH9.29 + MINL9.29 + MAXH26.29 + MINL26.29) / 4 - (MAXH52.29 + MINL52.29) / 2)) / 2) OR (C1 >= C2 AND C2 >= C3 AND C3 > ((MAXH9.29 + MINL9.29 + MAXH26.29 + MINL26.29) / 4 + (MAXH52.29 + MINL52.29) / 2 + ABS((MAXH9.29 + MINL9.29 + MAXH26.29 + MINL26.29) / 4 - (MAXH52.29 + MINL52.29) / 2)) / 2 AND C4 <= ((MAXH9.30 + MINL9.30 + MAXH26.30 + MINL26.30) / 4 + (MAXH52.30 + MINL52.30) / 2 + ABS((MAXH9.30 + MINL9.30 + MAXH26.30 + MINL26.30) / 4 - (MAXH52.30 + MINL52.30) / 2)) / 2) OR (C1 >= C2 AND C2 >= C3 AND C3 >= C4 AND C4 > ((MAXH9.30 + MINL9.30 + MAXH26.30 + MINL26.30) / 4 + (MAXH52.30 + MINL52.30) / 2 + ABS((MAXH9.30 + MINL9.30 + MAXH26.30 + MINL26.30) / 4 - (MAXH52.30 + MINL52.30) / 2)) / 2 AND C5 <= ((MAXH9.31 + MINL9.31 + MAXH26.31 + MINL26.31) / 4 + (MAXH52.31 + MINL52.31) / 2 + ABS((MAXH9.31 + MINL9.31 + MAXH26.31 + MINL26.31) / 4 - (MAXH52.31 + MINL52.31) / 2)) / 2) OR (C1 >= C2 AND C2 >= C3 AND C3 >= C4 AND C4 >= C5 AND C5 > ((MAXH9.31 + MINL9.31 + MAXH26.31 + MINL26.31) / 4 + (MAXH52.31 + MINL52.31) / 2 + ABS((MAXH9.31 + MINL9.31 + MAXH26.31 + MINL26.31) / 4 - (MAXH52.31 + MINL52.31) / 2)) / 2 AND C6 <= ((MAXH9.32 + MINL9.32 + MAXH26.32 + MINL26.32) / 4 + (MAXH52.32 + MINL52.32) / 2 + ABS((MAXH9.32 + MINL9.32 + MAXH26.32 + MINL26.32) / 4 - (MAXH52.32 + MINL52.32) / 2)) / 2) OR (C1 >= C2 AND C2 >= C3 AND C3 >= C4 AND C4 >= C5 AND C5 >= C6 AND C6 > ((MAXH9.32 + MINL9.32 + MAXH26.32 + MINL26.32) / 4 + (MAXH52.32 + MINL52.32) / 2 + ABS((MAXH9.32 + MINL9.32 + MAXH26.32 + MINL26.32) / 4 - (MAXH52.32 + MINL52.32) / 2)) / 2 AND C7 <= ((MAXH9.33 + MINL9.33 + MAXH26.33 + MINL26.33) / 4 + (MAXH52.33 + MINL52.33) / 2 + ABS((MAXH9.33 + MINL9.33 + MAXH26.33 + MINL26.33) / 4 - (MAXH52.33 + MINL52.33) / 2)) / 2) OR (C1 >= C2 AND C2 >= C3 AND C3 >= C4 AND C4 >= C5 AND C5 >= C6 AND C6 >= C7 AND C7 > ((MAXH9.33 + MINL9.33 + MAXH26.33 + MINL26.33) / 4 + (MAXH52.33 + MINL52.33) / 2 + ABS((MAXH9.33 + MINL9.33 + MAXH26.33 + MINL26.33) / 4 - (MAXH52.33 + MINL52.33) / 2)) / 2 AND C8 <= ((MAXH9.34 + MINL9.34 + MAXH26.34 + MINL26.34) / 4 + (MAXH52.34 + MINL52.34) / 2 + ABS((MAXH9.34 + MINL9.34 + MAXH26.34 + MINL26.34) / 4 - (MAXH52.34 + MINL52.34) / 2)) / 2) OR (C1 >= C2 AND C2 >= C3 AND C3 >= C4 AND C4 >= C5 AND C5 >= C6 AND C6 >= C7 AND C7 >= C8 AND C8 > ((MAXH9.34 + MINL9.34 + MAXH26.34 + MINL26.34) / 4 + (MAXH52.34 + MINL52.34) / 2 + ABS((MAXH9.34 + MINL9.34 + MAXH26.34 + MINL26.34) / 4 - (MAXH52.34 + MINL52.34) / 2)) / 2 AND C9 <= ((MAXH9.35 + MINL9.35 + MAXH26.35 + MINL26.35) / 4 + (MAXH52.35 + MINL52.35) / 2 + ABS((MAXH9.35 + MINL9.35 + MAXH26.35 + MINL26.35) / 4 - (MAXH52.35 + MINL52.35) / 2)) / 2))

I'm probably missing something because I can't see what is in yellow, but 4 would seem to differ from 3 only in that it not only checks for the forward Leading Span A to be above Leading Span B, but for Leading Span A to be at or below Leading Span B at one bar from the end of forward portion of the cloud (it is not just checking for A above B but for A to cross above B).

C1 > C AND C > ((MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4 + (MAXH52.26 + MINL52.26) / 2 + ABS((MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4 - (MAXH52.26 + MINL52.26) / 2)) / 2 AND C > (MAXH9 + MINL9) / 2 AND (MAXH9 + MINL9) / 2 > (MAXH26 + MINL26) / 2 AND (MAXH9 + MINL9 + MAXH26 + MINL26) / 4 > (MAXH52 + MINL52) / 2 AND (MAXH9.1 + MINL9.1 + MAXH26.1 + MINL26.1) / 4 <= (MAXH52.1 + MINL52.1) / 2 AND C > C26 AND ((C1 > ((MAXH9.27 + MINL9.27 + MAXH26.27 + MINL26.27) / 4 + (MAXH52.27 + MINL52.27) / 2 + ABS((MAXH9.27 + MINL9.27 + MAXH26.27 + MINL26.27) / 4 - (MAXH52.27 + MINL52.27) / 2)) / 2 AND C2 <= ((MAXH9.28 + MINL9.28 + MAXH26.28 + MINL26.28) / 4 + (MAXH52.28 + MINL52.28) / 2 + ABS((MAXH9.28 + MINL9.28 + MAXH26.28 + MINL26.28) / 4 - (MAXH52.28 + MINL52.28) / 2)) / 2) OR (C1 >= C2 AND C2 > ((MAXH9.28 + MINL9.28 + MAXH26.28 + MINL26.28) / 4 + (MAXH52.28 + MINL52.28) / 2 + ABS((MAXH9.28 + MINL9.28 + MAXH26.28 + MINL26.28) / 4 - (MAXH52.28 + MINL52.28) / 2)) / 2 AND C3 <= ((MAXH9.29 + MINL9.29 + MAXH26.29 + MINL26.29) / 4 + (MAXH52.29 + MINL52.29) / 2 + ABS((MAXH9.29 + MINL9.29 + MAXH26.29 + MINL26.29) / 4 - (MAXH52.29 + MINL52.29) / 2)) / 2) OR (C1 >= C2 AND C2 >= C3 AND C3 > ((MAXH9.29 + MINL9.29 + MAXH26.29 + MINL26.29) / 4 + (MAXH52.29 + MINL52.29) / 2 + ABS((MAXH9.29 + MINL9.29 + MAXH26.29 + MINL26.29) / 4 - (MAXH52.29 + MINL52.29) / 2)) / 2 AND C4 <= ((MAXH9.30 + MINL9.30 + MAXH26.30 + MINL26.30) / 4 + (MAXH52.30 + MINL52.30) / 2 + ABS((MAXH9.30 + MINL9.30 + MAXH26.30 + MINL26.30) / 4 - (MAXH52.30 + MINL52.30) / 2)) / 2) OR (C1 >= C2 AND C2 >= C3 AND C3 >= C4 AND C4 > ((MAXH9.30 + MINL9.30 + MAXH26.30 + MINL26.30) / 4 + (MAXH52.30 + MINL52.30) / 2 + ABS((MAXH9.30 + MINL9.30 + MAXH26.30 + MINL26.30) / 4 - (MAXH52.30 + MINL52.30) / 2)) / 2 AND C5 <= ((MAXH9.31 + MINL9.31 + MAXH26.31 + MINL26.31) / 4 + (MAXH52.31 + MINL52.31) / 2 + ABS((MAXH9.31 + MINL9.31 + MAXH26.31 + MINL26.31) / 4 - (MAXH52.31 + MINL52.31) / 2)) / 2) OR (C1 >= C2 AND C2 >= C3 AND C3 >= C4 AND C4 >= C5 AND C5 > ((MAXH9.31 + MINL9.31 + MAXH26.31 + MINL26.31) / 4 + (MAXH52.31 + MINL52.31) / 2 + ABS((MAXH9.31 + MINL9.31 + MAXH26.31 + MINL26.31) / 4 - (MAXH52.31 + MINL52.31) / 2)) / 2 AND C6 <= ((MAXH9.32 + MINL9.32 + MAXH26.32 + MINL26.32) / 4 + (MAXH52.32 + MINL52.32) / 2 + ABS((MAXH9.32 + MINL9.32 + MAXH26.32 + MINL26.32) / 4 - (MAXH52.32 + MINL52.32) / 2)) / 2) OR (C1 >= C2 AND C2 >= C3 AND C3 >= C4 AND C4 >= C5 AND C5 >= C6 AND C6 > ((MAXH9.32 + MINL9.32 + MAXH26.32 + MINL26.32) / 4 + (MAXH52.32 + MINL52.32) / 2 + ABS((MAXH9.32 + MINL9.32 + MAXH26.32 + MINL26.32) / 4 - (MAXH52.32 + MINL52.32) / 2)) / 2 AND C7 <= ((MAXH9.33 + MINL9.33 + MAXH26.33 + MINL26.33) / 4 + (MAXH52.33 + MINL52.33) / 2 + ABS((MAXH9.33 + MINL9.33 + MAXH26.33 + MINL26.33) / 4 - (MAXH52.33 + MINL52.33) / 2)) / 2) OR (C1 >= C2 AND C2 >= C3 AND C3 >= C4 AND C4 >= C5 AND C5 >= C6 AND C6 >= C7 AND C7 > ((MAXH9.33 + MINL9.33 + MAXH26.33 + MINL26.33) / 4 + (MAXH52.33 + MINL52.33) / 2 + ABS((MAXH9.33 + MINL9.33 + MAXH26.33 + MINL26.33) / 4 - (MAXH52.33 + MINL52.33) / 2)) / 2 AND C8 <= ((MAXH9.34 + MINL9.34 + MAXH26.34 + MINL26.34) / 4 + (MAXH52.34 + MINL52.34) / 2 + ABS((MAXH9.34 + MINL9.34 + MAXH26.34 + MINL26.34) / 4 - (MAXH52.34 + MINL52.34) / 2)) / 2) OR (C1 >= C2 AND C2 >= C3 AND C3 >= C4 AND C4 >= C5 AND C5 >= C6 AND C6 >= C7 AND C7 >= C8 AND C8 > ((MAXH9.34 + MINL9.34 + MAXH26.34 + MINL26.34) / 4 + (MAXH52.34 + MINL52.34) / 2 + ABS((MAXH9.34 + MINL9.34 + MAXH26.34 + MINL26.34) / 4 - (MAXH52.34 + MINL52.34) / 2)) / 2 AND C9 <= ((MAXH9.35 + MINL9.35 + MAXH26.35 + MINL26.35) / 4 + (MAXH52.35 + MINL52.35) / 2 + ABS((MAXH9.35 + MINL9.35 + MAXH26.35 + MINL26.35) / 4 - (MAXH52.35 + MINL52.35) / 2)) / 2))

On the reverse side, 5 should be very similar to 1:

C < ((MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4 + (MAXH52.26 + MINL52.26) / 2 - ABS((MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4 - (MAXH52.26 + MINL52.26) / 2)) / 2 AND C1 >= ((MAXH9.27 + MINL9.27 + MAXH26.27 + MINL26.27) / 4 + (MAXH52.27 + MINL52.27) / 2 - ABS((MAXH9.27 + MINL9.27 + MAXH26.27 + MINL26.27) / 4 - (MAXH52.27 + MINL52.27) / 2)) / 2

Bruce all of the above work flawlessly for bullish side, thats exactly what i wanted, you are Genius its a priviledge for Worden Brothers to have you in their team, and don't worry about the part in yellow i guess it just vanishes when i click post,

however for the bearish side

Only one question more i have is  i wanted the first bar closing below the current kumo which u gave me the formula as C < ((MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4 + (MAXH52.26 + MINL52.26) / 2 - ABS((MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4 - (MAXH52.26 + MINL52.26) / 2)) / 2 AND C1 >= ((MAXH9.27 + MINL9.27 + MAXH26.27 + MINL26.27) / 4 + (MAXH52.27 + MINL52.27) / 2 - ABS((MAXH9.27 + MINL9.27 + MAXH26.27 + MINL26.27) / 4 - (MAXH52.27 + MINL52.27) / 2)) / 2

but this does not have conversion above price and base line above conversion and chikou span below low of the price from 26 bars ago and forward lead span A below forward lead span B

so if u can please formulate that in one PCF would be great,

Next what i wanted is as first bar closed below the current kumo then  forming a pivot by having a first up day close in the following days but below the cloud,so do u think it can be formulated ??

Thanks a Lot,

Cheers

I'd mislabeled it. That formula is just 5. Steps 6, 7 and 8 are still a work in progress.

The following topic continues where we left off above.

The following formula represents part 6:

C1 < C AND C < ((MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4 + (MAXH52.26 + MINL52.26) / 2 - ABS((MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4 - (MAXH52.26 + MINL52.26) / 2)) / 2 AND C < (MAXH9 + MINL9) / 2 AND (MAXH9 + MINL9) / 2 < (MAXH26 + MINL26) / 2 AND C < C26 AND ((C1 < ((MAXH9.27 + MINL9.27 + MAXH26.27 + MINL26.27) / 4 + (MAXH52.27 + MINL52.27) / 2 - ABS((MAXH9.27 + MINL9.27 + MAXH26.27 + MINL26.27) / 4 - (MAXH52.27 + MINL52.27) / 2)) / 2 AND C2 >= ((MAXH9.28 + MINL9.28 + MAXH26.28 + MINL26.28) / 4 + (MAXH52.28 + MINL52.28) / 2 - ABS((MAXH9.28 + MINL9.28 + MAXH26.28 + MINL26.28) / 4 - (MAXH52.28 + MINL52.28) / 2)) / 2) OR (C1 <= C2 AND C2 < ((MAXH9.28 + MINL9.28 + MAXH26.28 + MINL26.28) / 4 + (MAXH52.28 + MINL52.28) / 2 - ABS((MAXH9.28 + MINL9.28 + MAXH26.28 + MINL26.28) / 4 - (MAXH52.28 + MINL52.28) / 2)) / 2 AND C3 >= ((MAXH9.29 + MINL9.29 + MAXH26.29 + MINL26.29) / 4 + (MAXH52.29 + MINL52.29) / 2 - ABS((MAXH9.29 + MINL9.29 + MAXH26.29 + MINL26.29) / 4 - (MAXH52.29 + MINL52.29) / 2)) / 2) OR (C1 <= C2 AND C2 <= C3 AND C3 < ((MAXH9.29 + MINL9.29 + MAXH26.29 + MINL26.29) / 4 + (MAXH52.29 + MINL52.29) / 2 - ABS((MAXH9.29 + MINL9.29 + MAXH26.29 + MINL26.29) / 4 - (MAXH52.29 + MINL52.29) / 2)) / 2 AND C4 >= ((MAXH9.30 + MINL9.30 + MAXH26.30 + MINL26.30) / 4 + (MAXH52.30 + MINL52.30) / 2 - ABS((MAXH9.30 + MINL9.30 + MAXH26.30 + MINL26.30) / 4 - (MAXH52.30 + MINL52.30) / 2)) / 2) OR (C1 <= C2 AND C2 <= C3 AND C3 <= C4 AND C4 < ((MAXH9.30 + MINL9.30 + MAXH26.30 + MINL26.30) / 4 + (MAXH52.30 + MINL52.30) / 2 - ABS((MAXH9.30 + MINL9.30 + MAXH26.30 + MINL26.30) / 4 - (MAXH52.30 + MINL52.30) / 2)) / 2 AND C5 >= ((MAXH9.31 + MINL9.31 + MAXH26.31 + MINL26.31) / 4 + (MAXH52.31 + MINL52.31) / 2 - ABS((MAXH9.31 + MINL9.31 + MAXH26.31 + MINL26.31) / 4 - (MAXH52.31 + MINL52.31) / 2)) / 2) OR (C1 <= C2 AND C2 <= C3 AND C3 <= C4 AND C4 <= C5 AND C5 < ((MAXH9.31 + MINL9.31 + MAXH26.31 + MINL26.31) / 4 + (MAXH52.31 + MINL52.31) / 2 - ABS((MAXH9.31 + MINL9.31 + MAXH26.31 + MINL26.31) / 4 - (MAXH52.31 + MINL52.31) / 2)) / 2 AND C6 >= ((MAXH9.32 + MINL9.32 + MAXH26.32 + MINL26.32) / 4 + (MAXH52.32 + MINL52.32) / 2 - ABS((MAXH9.32 + MINL9.32 + MAXH26.32 + MINL26.32) / 4 - (MAXH52.32 + MINL52.32) / 2)) / 2) OR (C1 <= C2 AND C2 <= C3 AND C3 <= C4 AND C4 <= C5 AND C5 <= C6 AND C6 < ((MAXH9.32 + MINL9.32 + MAXH26.32 + MINL26.32) / 4 + (MAXH52.32 + MINL52.32) / 2 - ABS((MAXH9.32 + MINL9.32 + MAXH26.32 + MINL26.32) / 4 - (MAXH52.32 + MINL52.32) / 2)) / 2 AND C7 >= ((MAXH9.33 + MINL9.33 + MAXH26.33 + MINL26.33) / 4 + (MAXH52.33 + MINL52.33) / 2 - ABS((MAXH9.33 + MINL9.33 + MAXH26.33 + MINL26.33) / 4 - (MAXH52.33 + MINL52.33) / 2)) / 2) OR (C1 <= C2 AND C2 <= C3 AND C3 <= C4 AND C4 <= C5 AND C5 <= C6 AND C6 <= C7 AND C7 < ((MAXH9.33 + MINL9.33 + MAXH26.33 + MINL26.33) / 4 + (MAXH52.33 + MINL52.33) / 2 - ABS((MAXH9.33 + MINL9.33 + MAXH26.33 + MINL26.33) / 4 - (MAXH52.33 + MINL52.33) / 2)) / 2 AND C8 >= ((MAXH9.34 + MINL9.34 + MAXH26.34 + MINL26.34) / 4 + (MAXH52.34 + MINL52.34) / 2 - ABS((MAXH9.34 + MINL9.34 + MAXH26.34 + MINL26.34) / 4 - (MAXH52.34 + MINL52.34) / 2)) / 2) OR (C1 <= C2 AND C2 <= C3 AND C3 <= C4 AND C4 <= C5 AND C5 <= C6 AND C6 <= C7 AND C7 <= C8 AND C8 < ((MAXH9.34 + MINL9.34 + MAXH26.34 + MINL26.34) / 4 + (MAXH52.34 + MINL52.34) / 2 - ABS((MAXH9.34 + MINL9.34 + MAXH26.34 + MINL26.34) / 4 - (MAXH52.34 + MINL52.34) / 2)) / 2 AND C9 >= ((MAXH9.35 + MINL9.35 + MAXH26.35 + MINL26.35) / 4 + (MAXH52.35 + MINL52.35) / 2 - ABS((MAXH9.35 + MINL9.35 + MAXH26.35 + MINL26.35) / 4 - (MAXH52.35 + MINL52.35) / 2)) / 2))

Adding part 7 gives us:

C1 < C AND C < ((MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4 + (MAXH52.26 + MINL52.26) / 2 - ABS((MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4 - (MAXH52.26 + MINL52.26) / 2)) / 2 AND C < (MAXH9 + MINL9) / 2 AND (MAXH9 + MINL9) / 2 < (MAXH26 + MINL26) / 2 AND (MAXH9 + MINL9 + MAXH26 + MINL26) / 4 < (MAXH52 + MINL52) / 2 AND C < C26 AND ((C1 < ((MAXH9.27 + MINL9.27 + MAXH26.27 + MINL26.27) / 4 + (MAXH52.27 + MINL52.27) / 2 - ABS((MAXH9.27 + MINL9.27 + MAXH26.27 + MINL26.27) / 4 - (MAXH52.27 + MINL52.27) / 2)) / 2 AND C2 >= ((MAXH9.28 + MINL9.28 + MAXH26.28 + MINL26.28) / 4 + (MAXH52.28 + MINL52.28) / 2 - ABS((MAXH9.28 + MINL9.28 + MAXH26.28 + MINL26.28) / 4 - (MAXH52.28 + MINL52.28) / 2)) / 2) OR (C1 <= C2 AND C2 < ((MAXH9.28 + MINL9.28 + MAXH26.28 + MINL26.28) / 4 + (MAXH52.28 + MINL52.28) / 2 - ABS((MAXH9.28 + MINL9.28 + MAXH26.28 + MINL26.28) / 4 - (MAXH52.28 + MINL52.28) / 2)) / 2 AND C3 >= ((MAXH9.29 + MINL9.29 + MAXH26.29 + MINL26.29) / 4 + (MAXH52.29 + MINL52.29) / 2 - ABS((MAXH9.29 + MINL9.29 + MAXH26.29 + MINL26.29) / 4 - (MAXH52.29 + MINL52.29) / 2)) / 2) OR (C1 <= C2 AND C2 <= C3 AND C3 < ((MAXH9.29 + MINL9.29 + MAXH26.29 + MINL26.29) / 4 + (MAXH52.29 + MINL52.29) / 2 - ABS((MAXH9.29 + MINL9.29 + MAXH26.29 + MINL26.29) / 4 - (MAXH52.29 + MINL52.29) / 2)) / 2 AND C4 >= ((MAXH9.30 + MINL9.30 + MAXH26.30 + MINL26.30) / 4 + (MAXH52.30 + MINL52.30) / 2 - ABS((MAXH9.30 + MINL9.30 + MAXH26.30 + MINL26.30) / 4 - (MAXH52.30 + MINL52.30) / 2)) / 2) OR (C1 <= C2 AND C2 <= C3 AND C3 <= C4 AND C4 < ((MAXH9.30 + MINL9.30 + MAXH26.30 + MINL26.30) / 4 + (MAXH52.30 + MINL52.30) / 2 - ABS((MAXH9.30 + MINL9.30 + MAXH26.30 + MINL26.30) / 4 - (MAXH52.30 + MINL52.30) / 2)) / 2 AND C5 >= ((MAXH9.31 + MINL9.31 + MAXH26.31 + MINL26.31) / 4 + (MAXH52.31 + MINL52.31) / 2 - ABS((MAXH9.31 + MINL9.31 + MAXH26.31 + MINL26.31) / 4 - (MAXH52.31 + MINL52.31) / 2)) / 2) OR (C1 <= C2 AND C2 <= C3 AND C3 <= C4 AND C4 <= C5 AND C5 < ((MAXH9.31 + MINL9.31 + MAXH26.31 + MINL26.31) / 4 + (MAXH52.31 + MINL52.31) / 2 - ABS((MAXH9.31 + MINL9.31 + MAXH26.31 + MINL26.31) / 4 - (MAXH52.31 + MINL52.31) / 2)) / 2 AND C6 >= ((MAXH9.32 + MINL9.32 + MAXH26.32 + MINL26.32) / 4 + (MAXH52.32 + MINL52.32) / 2 - ABS((MAXH9.32 + MINL9.32 + MAXH26.32 + MINL26.32) / 4 - (MAXH52.32 + MINL52.32) / 2)) / 2) OR (C1 <= C2 AND C2 <= C3 AND C3 <= C4 AND C4 <= C5 AND C5 <= C6 AND C6 < ((MAXH9.32 + MINL9.32 + MAXH26.32 + MINL26.32) / 4 + (MAXH52.32 + MINL52.32) / 2 - ABS((MAXH9.32 + MINL9.32 + MAXH26.32 + MINL26.32) / 4 - (MAXH52.32 + MINL52.32) / 2)) / 2 AND C7 >= ((MAXH9.33 + MINL9.33 + MAXH26.33 + MINL26.33) / 4 + (MAXH52.33 + MINL52.33) / 2 - ABS((MAXH9.33 + MINL9.33 + MAXH26.33 + MINL26.33) / 4 - (MAXH52.33 + MINL52.33) / 2)) / 2) OR (C1 <= C2 AND C2 <= C3 AND C3 <= C4 AND C4 <= C5 AND C5 <= C6 AND C6 <= C7 AND C7 < ((MAXH9.33 + MINL9.33 + MAXH26.33 + MINL26.33) / 4 + (MAXH52.33 + MINL52.33) / 2 - ABS((MAXH9.33 + MINL9.33 + MAXH26.33 + MINL26.33) / 4 - (MAXH52.33 + MINL52.33) / 2)) / 2 AND C8 >= ((MAXH9.34 + MINL9.34 + MAXH26.34 + MINL26.34) / 4 + (MAXH52.34 + MINL52.34) / 2 - ABS((MAXH9.34 + MINL9.34 + MAXH26.34 + MINL26.34) / 4 - (MAXH52.34 + MINL52.34) / 2)) / 2) OR (C1 <= C2 AND C2 <= C3 AND C3 <= C4 AND C4 <= C5 AND C5 <= C6 AND C6 <= C7 AND C7 <= C8 AND C8 < ((MAXH9.34 + MINL9.34 + MAXH26.34 + MINL26.34) / 4 + (MAXH52.34 + MINL52.34) / 2 - ABS((MAXH9.34 + MINL9.34 + MAXH26.34 + MINL26.34) / 4 - (MAXH52.34 + MINL52.34) / 2)) / 2 AND C9 >= ((MAXH9.35 + MINL9.35 + MAXH26.35 + MINL26.35) / 4 + (MAXH52.35 + MINL52.35) / 2 - ABS((MAXH9.35 + MINL9.35 + MAXH26.35 + MINL26.35) / 4 - (MAXH52.35 + MINL52.35) / 2)) / 2))

With the actual crossover check for part 8 resulting in:

C1 < C AND C < ((MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4 + (MAXH52.26 + MINL52.26) / 2 - ABS((MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4 - (MAXH52.26 + MINL52.26) / 2)) / 2 AND C < (MAXH9 + MINL9) / 2 AND (MAXH9 + MINL9) / 2 < (MAXH26 + MINL26) / 2 AND (MAXH9 + MINL9 + MAXH26 + MINL26) / 4 < (MAXH52 + MINL52) / 2 AND (MAXH9.1 + MINL9.1 + MAXH26.1 + MINL26.1) / 4 >= (MAXH52.1 + MINL52.1) / 2 AND C < C26 AND ((C1 < ((MAXH9.27 + MINL9.27 + MAXH26.27 + MINL26.27) / 4 + (MAXH52.27 + MINL52.27) / 2 - ABS((MAXH9.27 + MINL9.27 + MAXH26.27 + MINL26.27) / 4 - (MAXH52.27 + MINL52.27) / 2)) / 2 AND C2 >= ((MAXH9.28 + MINL9.28 + MAXH26.28 + MINL26.28) / 4 + (MAXH52.28 + MINL52.28) / 2 - ABS((MAXH9.28 + MINL9.28 + MAXH26.28 + MINL26.28) / 4 - (MAXH52.28 + MINL52.28) / 2)) / 2) OR (C1 <= C2 AND C2 < ((MAXH9.28 + MINL9.28 + MAXH26.28 + MINL26.28) / 4 + (MAXH52.28 + MINL52.28) / 2 - ABS((MAXH9.28 + MINL9.28 + MAXH26.28 + MINL26.28) / 4 - (MAXH52.28 + MINL52.28) / 2)) / 2 AND C3 >= ((MAXH9.29 + MINL9.29 + MAXH26.29 + MINL26.29) / 4 + (MAXH52.29 + MINL52.29) / 2 - ABS((MAXH9.29 + MINL9.29 + MAXH26.29 + MINL26.29) / 4 - (MAXH52.29 + MINL52.29) / 2)) / 2) OR (C1 <= C2 AND C2 <= C3 AND C3 < ((MAXH9.29 + MINL9.29 + MAXH26.29 + MINL26.29) / 4 + (MAXH52.29 + MINL52.29) / 2 - ABS((MAXH9.29 + MINL9.29 + MAXH26.29 + MINL26.29) / 4 - (MAXH52.29 + MINL52.29) / 2)) / 2 AND C4 >= ((MAXH9.30 + MINL9.30 + MAXH26.30 + MINL26.30) / 4 + (MAXH52.30 + MINL52.30) / 2 - ABS((MAXH9.30 + MINL9.30 + MAXH26.30 + MINL26.30) / 4 - (MAXH52.30 + MINL52.30) / 2)) / 2) OR (C1 <= C2 AND C2 <= C3 AND C3 <= C4 AND C4 < ((MAXH9.30 + MINL9.30 + MAXH26.30 + MINL26.30) / 4 + (MAXH52.30 + MINL52.30) / 2 - ABS((MAXH9.30 + MINL9.30 + MAXH26.30 + MINL26.30) / 4 - (MAXH52.30 + MINL52.30) / 2)) / 2 AND C5 >= ((MAXH9.31 + MINL9.31 + MAXH26.31 + MINL26.31) / 4 + (MAXH52.31 + MINL52.31) / 2 - ABS((MAXH9.31 + MINL9.31 + MAXH26.31 + MINL26.31) / 4 - (MAXH52.31 + MINL52.31) / 2)) / 2) OR (C1 <= C2 AND C2 <= C3 AND C3 <= C4 AND C4 <= C5 AND C5 < ((MAXH9.31 + MINL9.31 + MAXH26.31 + MINL26.31) / 4 + (MAXH52.31 + MINL52.31) / 2 - ABS((MAXH9.31 + MINL9.31 + MAXH26.31 + MINL26.31) / 4 - (MAXH52.31 + MINL52.31) / 2)) / 2 AND C6 >= ((MAXH9.32 + MINL9.32 + MAXH26.32 + MINL26.32) / 4 + (MAXH52.32 + MINL52.32) / 2 - ABS((MAXH9.32 + MINL9.32 + MAXH26.32 + MINL26.32) / 4 - (MAXH52.32 + MINL52.32) / 2)) / 2) OR (C1 <= C2 AND C2 <= C3 AND C3 <= C4 AND C4 <= C5 AND C5 <= C6 AND C6 < ((MAXH9.32 + MINL9.32 + MAXH26.32 + MINL26.32) / 4 + (MAXH52.32 + MINL52.32) / 2 - ABS((MAXH9.32 + MINL9.32 + MAXH26.32 + MINL26.32) / 4 - (MAXH52.32 + MINL52.32) / 2)) / 2 AND C7 >= ((MAXH9.33 + MINL9.33 + MAXH26.33 + MINL26.33) / 4 + (MAXH52.33 + MINL52.33) / 2 - ABS((MAXH9.33 + MINL9.33 + MAXH26.33 + MINL26.33) / 4 - (MAXH52.33 + MINL52.33) / 2)) / 2) OR (C1 <= C2 AND C2 <= C3 AND C3 <= C4 AND C4 <= C5 AND C5 <= C6 AND C6 <= C7 AND C7 < ((MAXH9.33 + MINL9.33 + MAXH26.33 + MINL26.33) / 4 + (MAXH52.33 + MINL52.33) / 2 - ABS((MAXH9.33 + MINL9.33 + MAXH26.33 + MINL26.33) / 4 - (MAXH52.33 + MINL52.33) / 2)) / 2 AND C8 >= ((MAXH9.34 + MINL9.34 + MAXH26.34 + MINL26.34) / 4 + (MAXH52.34 + MINL52.34) / 2 - ABS((MAXH9.34 + MINL9.34 + MAXH26.34 + MINL26.34) / 4 - (MAXH52.34 + MINL52.34) / 2)) / 2) OR (C1 <= C2 AND C2 <= C3 AND C3 <= C4 AND C4 <= C5 AND C5 <= C6 AND C6 <= C7 AND C7 <= C8 AND C8 < ((MAXH9.34 + MINL9.34 + MAXH26.34 + MINL26.34) / 4 + (MAXH52.34 + MINL52.34) / 2 - ABS((MAXH9.34 + MINL9.34 + MAXH26.34 + MINL26.34) / 4 - (MAXH52.34 + MINL52.34) / 2)) / 2 AND C9 >= ((MAXH9.35 + MINL9.35 + MAXH26.35 + MINL26.35) / 4 + (MAXH52.35 + MINL52.35) / 2 - ABS((MAXH9.35 + MINL9.35 + MAXH26.35 + MINL26.35) / 4 - (MAXH52.35 + MINL52.35) / 2)) / 2))

Thanks a lot bruce, they all work fantastic, appreciate your promptness and wisdom !

Best Regards

You're welcome.