NexusFi: Find Your Edge


Home Menu

 





Alert condition Kijun-Sen changes slope direction


Discussion in Sierra Chart

Updated
    1. trending_up 1,362 views
    2. thumb_up 2 thanks given
    3. group 2 followers
    1. forum 4 posts
    2. attach_file 0 attachments




 
Search this Thread

Alert condition Kijun-Sen changes slope direction

  #1 (permalink)
smoske
Antwerp Belgium
 
Posts: 4 since Feb 2018
Thanks Given: 0
Thanks Received: 0

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

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
Futures True Range Report
The Elite Circle
NexusFi Journal Challenge - April 2024
Feedback and Announcements
Ninja Mobile Trader VPS (ninjamobiletrader.com)
Trading Reviews and Vendors
Better Renko Gaps
The Elite Circle
 
  #2 (permalink)
 Sawtooth 
Prescott AZ USA
 
Experience: Advanced
Platform: SierraChart
Broker: Stage5, FCM:Dorman, Data:Denali, Routing:Teton
Trading: YM ES NQ
Posts: 474 since Nov 2009
Thanks Given: 219
Thanks Received: 603


smoske View Post
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.

Reply With Quote
  #3 (permalink)
smoske
Antwerp Belgium
 
Posts: 4 since Feb 2018
Thanks Given: 0
Thanks Received: 0


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)

?

Reply With Quote
  #4 (permalink)
 Sawtooth 
Prescott AZ USA
 
Experience: Advanced
Platform: SierraChart
Broker: Stage5, FCM:Dorman, Data:Denali, Routing:Teton
Trading: YM ES NQ
Posts: 474 since Nov 2009
Thanks Given: 219
Thanks Received: 603

[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)

Reply With Quote
Thanked by:
  #5 (permalink)
 Sawtooth 
Prescott AZ USA
 
Experience: Advanced
Platform: SierraChart
Broker: Stage5, FCM:Dorman, Data:Denali, Routing:Teton
Trading: YM ES NQ
Posts: 474 since Nov 2009
Thanks Given: 219
Thanks Received: 603


smoske View Post
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#.

Reply With Quote
Thanked by:




Last Updated on February 6, 2018


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts