Home >> Support Board

Support Board

Date/Time: Sat, 27 Apr 2024 02:41:36 +0000

How to Post a Message for Support

Persistent and Incrementing Variables

View Count: 378

[2023-03-08 04:32:23] #1 [Go To First Post]
User486817 - Posts: 79
Hello, I am looking at this page regarding Persistent and Incrementing Variables: Spreadsheet Example Formulas and Usage: Formula to Count Bars Since An Event I am using the Color Bar Based on Alert Condition Study on a chart. I'm trying to count bars since a buy/sell alert was triggered. How can i translate the below two formulas using the ID1.SG1 notation i'm used to? i have this formula =IF(ID6.SG1=0,ID16.SG1[-1]+1,0) where ID6 is the Color Bar Based on Alert Condition study with formula =ID4.SG2<>0 and ID16.SG1 is the spreadsheet formula -- this works. but if ID6 is the same Color Bar Based on Alert Condition study, but the formula has multiple conditions like =OR(ID4.SG2<>0, ID5.SG2<>0, ID6.SG2<>0)for some reason it will not work. is there a way to achieve the same functionality of the below two formulas using only the spreadsheet formula study? can these two formulas be translated using ID1.SG1 notation? Buy Alert =IF(M3, 0,IF(OR(K3, P4 > 0), P4 + 1, P4)) Sell Alert =IF(K3, 0,IF(OR(M3, Q4 > 0), Q4 + 1, Q4)) thank you,

[2023-03-08 13:01:19] #2 [Go To First Post]
Sawtooth - Posts: 3976
can these two formulas be translated using ID1.SG1 notation? Yes. Buy bar count: =IF(SellAlert[0], 0,IF(OR(BuyAlert[0], ID1.SG1[-1] > 0), ID1.SG1[-1] + 1, ID1.SG1[-1])) where ID1 is this Spreadsheet Formula study. Sell bar count: =IF(BuyAlert[0], 0,IF(OR(SellAlert[0], ID2.SG1[-1] > 0), ID2.SG1[-1] + 1, ID2.SG1[-1])) where ID2 is this Spreadsheet Formula study. Date Time Of Last Edit: 2023-03-08 15:59:24

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