Support Board
Date/Time: Sun, 12 Jan 2025 03:56:43 +0000
[Programming Help] - Any help with spreadsheet logical functions?
View Count: 1378
| [2017-01-26 17:58:12] |
| 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| [2017-01-26 18:07:08] |
| |
|
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] |
| 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 |
To post a message in this thread, you need to log in with your Sierra Chart account: