Can anyone help me with the following alert condition?:

When the Kijun-Sen changes of slope direction. The Sierra Chart programmers can"t help me

smoske 

Can anyone help me with the following alert condition?: When the Kijun-Sen changes of slope direction. The Sierra Chart programmers can"t help me

Since the Kijun-Sen has some segments that are flat, you'll need to use the Spreadsheet System/Alert study so that you can create a persistent variable to 'remember' the direction through those flat segments.

Try a formula like this, e.g. in cell Z3, where the Kijun-Sen is ID1:

 

Code

=IF(OR(ID1.SG1@3>ID1.SG1@4,AND(ID1.SG1@5>=ID1.SG1@4,ID1.SG1@3>ID1.SG1@4)),1,IF(OR(ID1.SG1@3<ID1.SG1@4,AND(ID1.SG1@5<=ID1.SG1@4,ID1.SG1@3<ID1.SG1@4)),-1,Z4))

It returns a 1 if the line is sloped up, or if the current segment is flat and the previous segment was up.
It returns a -1 if the line is sloped down, or if the current segment is flat and the previous segment was down.

You will then need to find the transitions using formulas in columns K and M:
K3:
=AND(Z4-1,Z3=1)
M3:
=AND(Z4=1,Z3=-1)

Then assign an alert# to column K and column M.

Hi,

Thank you for helping me. I have the answer: K3: =AND(Z4=-1,Z3=1)

But now I do not anderstand what I have to copy paste in sierra chart, maybe like this:

=IF(OR(ID1.SG1@3>ID1.SG1@4,AND(ID1.SG1@5>=ID1.SG1@4,ID1.SG1@3>ID1.SG1@4)),1,IF(OR(ID1.SG1@3<ID1.SG1@4,AND(ID1.SG1@5<=ID1.SG1@4,ID1.SG1@3<ID1.SG1@4)),-1,Z4))=AND(Z4-1,Z3=1)

?

[Mike, it would be nice if the post's author could indefinitely edit one's posts.]

Correction to post #2.

You will then need to find the transitions using formulas in columns K and M:
K3:
=AND(Z4=-1,Z3=1)
M3:
=AND(Z4=1,Z3=-1)

smoske 

Hi, Thank you for helping me. I have the answer: K3: =AND(Z4=-1,Z3=1) But now I do not anderstand what I have to copy paste in sierra chart, maybe like this: =IF(OR(ID1.SG1@3>ID1.SG1@4,AND(ID1.SG1@5>=ID1.SG1@4,ID1.SG1@3>ID1.SG1@4)),1,IF(OR(ID1.SG1@3<ID1.SG1@4,AND(ID1.SG1@5<=ID1.SG1@4,ID1.SG1@3<ID1.SG1@4)),-1,Z4))=AND(Z4-1,Z3=1)?

Add the Spreadsheet System/Alert study to your chart
-Give it a name in the Spreadsheet Name field
-Assign alerts to Column K and Column M
-You may want to set 'Signal Only On Bar Close (Columns K,M)' to Yes.
-On the Subgraphs tab, set the Draw Style of SG1 to your requirements
-Press OK and OK
-On the spreadsheet:
Put this in cell Z3:

 

Code

=IF(OR(ID1.SG1@3>ID1.SG1@4,AND(ID1.SG1@5>=ID1.SG1@4,ID1.SG1@3>ID1.SG1@4)),1,IF(OR(ID1.SG1@3<ID1.SG1@4,AND(ID1.SG1@5<=ID1.SG1@4,ID1.SG1@3<ID1.SG1@4)),-1,Z4))

Put this in cell K3:

 

Code

=AND(Z4=-1,Z3=1)

Put this in cell M3:

 

Code

=AND(Z4=1,Z3=-1)

The formula in Z3 assumes your Kijun-Sen study is ID1. If it is a different ID#, edit all 12 of the ID1s to the correct ID#.