Login Page - Create Account

Support Board


Date/Time: Sat, 28 Dec 2024 19:27:09 +0000



CrossFromAbove or CrossFromBelow

View Count: 2805

[2016-01-19 15:53:10]
FXDojiStar - Posts: 8
I am using the Ichimoku Tenken-Sen crosses the Kijus-Sen as the base of the system WITH the Price staying below the cross as the trigger.

I wrote the formula and placed in the System Alert Condition section. UNFORTUNATELY I cant get it to work. Here is my formula:

ID6 = Tenken-Sen
ID4 = Kijun-Sen

=( CROSSFROMABOVE(ID6.SG1, ID4.SG1) AND (ID6.SG1 > C)) OR ( CROSSFROMBELOW(ID6.SG1, ID4.SG1) AND ( C > ID6.SG1) )

I have ticked - Enabled, Evaluate on bar close.

Thanks
[2016-01-19 19:16:24]
Sierra Chart Engineering - Posts: 104368
That formula does not make sense. You are improperly using the AND and OR functions. Refer to the documentation here for these functions:
https://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetFunctions.html
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
Date Time Of Last Edit: 2016-01-19 23:59:11
[2016-01-19 23:18:14]
Sawtooth - Posts: 4143
Try this syntax:

=OR(AND(CROSSFROMABOVE(ID6.SG1,ID4.SG1),ID6.SG1>C),AND(CROSSFROMBELOW(ID6.SG1,ID4.SG1),C>ID6.SG1))

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account