Home >> Support Board

Support Board

Date/Time: Sun, 12 May 2024 23:46:09 +0000

How to Post a Message for Support

[Programming Help] - Any help with spreadsheet logical functions?

View Count: 1315

[2017-01-26 17:58:12] #1 [Go To First Post]
JRA - Posts: 97
I am Defining the start of a new trend when there is a close above the Prior Bollinger Band on Column K With IF (blabla,1,0). On the second Column L I define the start of a downtrend when there is a close below the lower Bollinger band with IF (blabla, 1,0). So Column K will be full of Zeros and at some point it will print 1,then Zero again. The same with Column L. What I want to define in another column is when the K column printed the first 1 to track the L Column until it prints 1. Any Ideas how can I define this with Logical functions. I am giving a screenshot for reference. Thank you in Advance


Sprd.png / V - Attached On 2017-01-26 17:56:58 UTC - Size: 14.29 KB - 232 views

[2017-01-26 18:07:08] #2 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
First, it is not necessary to use the IF function. You can just use a formula like: = ID0.SG4@3 > ID3.SG1@3 Did you want to know the time this happens?: What I want to define in another column is when the K column printed the first 1 Sounds like you want to use the GetCorrespondingMatch function: http://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#GetCorrespondingMatch_Function 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: 2017-01-26 18:07:41

[2017-01-26 18:25:56] #3 [Go To First Post]
JRA - Posts: 97
I will Give it try. Actually What I want to finally do is track the lower line when there is a close above the upper BB, and when there is a close below the lower BB track only the upper line. I like it because I force myself to trade with the trend and keeps my chart clean. Here is a screenshot for reference


BB.png / V - Attached On 2017-01-26 18:25:41 UTC - Size: 22.7 KB - 242 views

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