I need to figure out how to write the formula for 2 separate Ichimoku scans (Using standard 9, 26, 52 Ichimoku settings for both scans):

1) Price breaking up through the top of the cloud (either Leading Span A or Leading Span B...whichever is higher)

2) Lagging Span indicator breaking up through the top of the cloud either Leading Span A or Leading Span B...whichever is higher)

I could be wrong, but I don't think I can do these conditions using the "create scan condition" off the chart price indicator.

Any ideas?

The following Condition Formula should check for price crossing up through the top of the cloud:

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

And the following Condition Formula should check for Lagging Span crossing up through the top of the cloud at the most recent point at which it is plotted:

C > (MAXH9.52 + MINL9.52 + MAXH26.52 + MINL26.52) / 4 AND C > (MAXH52.52 + MINL52.52) / 2 AND (C1 <= (MAXH9.53 + MINL9.53 + MAXH26.53 + MINL26.53) / 4 OR C1 <= (MAXH52.53 + MINL52.53) / 2)

PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!

Thanks Bruce

I am a newbie here, so that I am sorry for my question: what would be a correct syntax for the opposite (price crossing bottom of the cloud and lagging span crossing down through the bottom)?

Thank you

In this particular case it would just involve reversing all of the > and < symbols in the formulas.

The following Condition Formula should check for price crossing down through the bottom of the cloud:

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

And the following Condition Formula should check for Lagging Span crossing down through the bottom of the cloud at the most recent point at which it is plotted:

C < (MAXH9.52 + MINL9.52 + MAXH26.52 + MINL26.52) / 4 AND C < (MAXH52.52 + MINL52.52) / 2 AND (C1 >= (MAXH9.53 + MINL9.53 + MAXH26.53 + MINL26.53) / 4 OR C1 >= (MAXH52.53 + MINL52.53) / 2)

Bruce,

thank you very much, simple and easy.

The scan only shows the most recent bar that has crossed the cloud. Is it possible to edit the formula so the scan gathers stocks that have broke the cloud within 16 bars. Would somthing like C16 work or will that only look at the close from 16 periods ago?

Nevermind I see such a condition was already made for the indicator. I simply added "Price History above Ichimoku - Lead Span A"  and  "Price History above Ichimoku - Lead Span B"  This seems to be finding stocks that have broke the cloud in the past and have continued above it.

Although, I do have another question. Is it possible to create a condition that finds Leading Span A is greater than Leading Span B 26 days out? The provided conditions seem to only calculate the "crossing up"  or "greater than/above" on the current day.

A Condition Formula for Leading Span A being above Leading Span B at the far right endpoint of where it is being plotted 26 bars in the future can be written as:

(MAXH9 + MINL9 + MAXH26 + MINL26) / 4 > (MAXH52 + MINL52) / 2

A Condition Formula for Leading Span A being above Leading Span B 26-bars in the past where Lagging Span is most recently plotted can be written as:

(MAXH9.52 + MINL9.52 + MAXH26.52 + MINL26.52) / 4 > (MAXH52.52 + MINL52.52) / 2

May I ask what is the formula for it?

Thank you

I could be wrong, but I suspect Prime90 was referencing the following Condition Formula for price being above both Lead Span A and Lead Span B:

C > (MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4 AND C > (MAXH52.26 + MINL52.26) / 2

Bruce,

what would the formula look like to show stocks that broke the cloud within last 16 bars (not just the last bar)?

Thank you

Does price still need to be above the cloud?

Do you specifically need a Condition Formula or can it be a condition that isn't a Condition Formula?

Yes, the price should be above the cloud. I think I need a condition formula to be able to run a scan.

Thank you.

No, you don't need Condition Formulas to be able to run a scan. You can create a condition by clicking on an indicator on the chart and selecting Create Scan Condition.

Create Conditions from Your Chart

And you can then add those conditions to an EasyScan.

Building a Scan with Multiple Conditions

So you could click on Price History (the symbol and possibly company name in green in the same pane where price is plotted) and select Create Scan Condition to create a condition for price being above Leading Span A and repeat the process to create another condition for price being above Leading Span B. As long as both conditions are used in the same EasyScan, that EasyScan will only return symbols in the List to Scan of the EasyScan meeting the requirements of all of the EasyScan Conditions.

This resulting EasyScan would be more efficient than a single Condition Formula designed to do the same thing.

C > (MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4 AND C > (MAXH52.26 + MINL52.26) / 2

Note this Condition Formula checks for price being above Leading Span A and Leading Span B. It does not check for the crossover to have happened during any specific bar. It could have happened during the current bar, the previous bar, 16 bars ago or 100 bars ago as long as the close is still above the cloud.

So if there is nothing special about 16 bars, then you already have the desired Condition Formula.

If you specifically want the closing price to have been at or below the top of the cloud during one of the previous 16 bars, you would need to add a check for each of those 16 bars as follows:

C > (MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4 AND C > (MAXH52.26 + MINL52.26) / 2 AND (C1 <= (MAXH9.27 + MINL9.27 + MAXH26.27 + MINL26.27) / 4 OR C1 <= (MAXH52.27 + MINL52.27) / 2 OR C2 <= (MAXH9.28 + MINL9.28 + MAXH26.28 + MINL26.28) / 4 OR C2 <= (MAXH52.28 + MINL52.28) / 2 OR C3 <= (MAXH9.29 + MINL9.29 + MAXH26.29 + MINL26.29) / 4 OR C3 <= (MAXH52.29 + MINL52.29) / 2 OR C4 <= (MAXH9.30 + MINL9.30 + MAXH26.30 + MINL26.30) / 4 OR C4 <= (MAXH52.30 + MINL52.30) / 2 OR C5 <= (MAXH9.31 + MINL9.31 + MAXH26.31 + MINL26.31) / 4 OR C5 <= (MAXH52.31 + MINL52.31) / 2 OR C6 <= (MAXH9.32 + MINL9.32 + MAXH26.32 + MINL26.32) / 4 OR C6 <= (MAXH52.32 + MINL52.32) / 2 OR C7 <= (MAXH9.33 + MINL9.33 + MAXH26.33 + MINL26.33) / 4 OR C7 <= (MAXH52.33 + MINL52.33) / 2 OR C8 <= (MAXH9.34 + MINL9.34 + MAXH26.34 + MINL26.34) / 4 OR C8 <= (MAXH52.34 + MINL52.34) / 2 OR C9 <= (MAXH9.35 + MINL9.35 + MAXH26.35 + MINL26.35) / 4 OR C9 <= (MAXH52.35 + MINL52.35) / 2 OR C10 <= (MAXH9.36 + MINL9.36 + MAXH26.36 + MINL26.36) / 4 OR C10 <= (MAXH52.36 + MINL52.36) / 2 OR C11 <= (MAXH9.37 + MINL9.37 + MAXH26.37 + MINL26.37) / 4 OR C11 <= (MAXH52.37 + MINL52.37) / 2 OR C12 <= (MAXH9.38 + MINL9.38 + MAXH26.38 + MINL26.38) / 4 OR C12 <= (MAXH52.38 + MINL52.38) / 2 OR C13 <= (MAXH9.39 + MINL9.39 + MAXH26.39 + MINL26.39) / 4 OR C13 <= (MAXH52.39 + MINL52.39) / 2 OR C14 <= (MAXH9.40 + MINL9.40 + MAXH26.40 + MINL26.40) / 4 OR C14 <= (MAXH52.40 + MINL52.40) / 2 OR C15 <= (MAXH9.41 + MINL9.41 + MAXH26.41 + MINL26.41) / 4 OR C15 <= (MAXH52.41 + MINL52.41) / 2 OR C16 <= (MAXH9.42 + MINL9.42 + MAXH26.42 + MINL26.42) / 4 OR C16 <= (MAXH52.42 + MINL52.42) / 2)

Bruce,

This is the PCF for breaking above the cloud

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

Can you please provide for brekaing price breaking below the clod - Thanks, Aubrey

Please try the following Condition Formula.

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

That is great - Thank you.

You're welcome.