Home >> Support Board

Support Board

Date/Time: Fri, 27 Dec 2024 00:51:06 +0000

How to Post a Message for Support

[User Discussion] - simple alert formula

View Count: 1311

[2015-10-24 17:19:56] #1 [Go To First Post]
User241643 - Posts: 6
Hi For trivial it may be for sb., but evidently me. In the "color Background based on alert condition" the intended formula is meant for the studies to graph(ID3), if SG1 line crossses SG line from above. One of my failure attempt is ID3.CROSSFROMABOVE(SG1,SG) or another =CROSSFROMABOVE(ID3.SG1,ID3.SG) ,results in Error:#NAME? Could anyone please give me a hand here. Thx in advance

[2015-10-24 20:47:25] #2 [Go To First Post]
Sawtooth - Posts: 4143
You need a SG# for both. Try this: =CROSSFROMABOVE(ID3.SG1,ID3.SG3)

[2015-10-24 22:29:38] #3 [Go To First Post]
User241643 - Posts: 6
Oh, silly me. much appreciated. thx

[2015-10-25 02:39:54] #4 [Go To First Post]
User241643 - Posts: 6
Hope you guys dont mind if I ask for one more, thought it reasonable since it's 2nd post in my entire trading "career" only. give a signal if there is a cross from below and ID1 SG1 is higher than 100 or lower than -100 and at the same time ID1 SG2 is lower or equals 2200. Given that ID1 is a numbers bars calculated studies. My failin invention: =CROSSFROMBELOW(ID3.SG1,ID3.SG2,AND((ID1.SG1>100,OR(ID1.SG1<-100)),AND(ID1.SG2>=2200) In anticipation of any response I remain.

[2015-10-25 04:33:57] #5 [Go To First Post]
Sawtooth - Posts: 4143
Try this: =AND(CROSSFROMBELOW(ID3.SG1,ID3.SG2),OR(ID1.SG1>100,ID1.SG1<-100),ID1.SG2<=2200)

[2015-10-25 20:46:04] #6 [Go To First Post]
User241643 - Posts: 6
Tomgilb, you re a *. Formula functions, though does not achieve the outcome desired. Have to come up with somthg better than that. At any rate, thx a lot mate.

[2015-10-26 00:34:41] #7 [Go To First Post]
User167108 - Posts: 49
Thanks Tomgilb . This one helped me too

[2015-10-26 00:54:48] #8 [Go To First Post]
Sawtooth - Posts: 4143
Maybe you want an alert when any of the three occur, while the others have already occurred. Try this: =OR( AND(ID3.SG2[-1]>ID3.SG1[-1],ID3.SG1>ID3.SG2,OR(ID1.SG1>100,ID1.SG1<-100),ID1.SG2<=2200), AND(ID3.SG1>ID3.SG2,OR(AND(ID1.SG1[-1]>0,ID1.SG1[-1]<100,ID1.SG1>100),AND(ID1.SG1[-1]<0,ID1.SG1[-1]>-100,ID1.SG1<-100),ID1.SG2<=2200), AND(ID3.SG1>ID3.SG2,OR(ID1.SG1>100,ID1.SG1<-100),ID1.SG2[-1]>2200,ID1.SG2<=2200)) The original formula is tripled, each with one crossover (the bolded). These are then combined with an OR to separate the individual crossovers. This is untested because I don't know the studies that are referenced.

[2015-11-17 00:04:52] #9 [Go To First Post]
User241643 - Posts: 6
Hi tomigilb, I greatly appreciate your effort. Formula is correct, as usual. In general however, I m not 100% that mechanical filtering out is that fruitful. In any event, thank you for your time. Marek

[2016-03-29 17:09:26] #10 [Go To First Post]
User241643 - Posts: 6
In pursuit of the above. The formula is =CROSSFROMABOVE(ID4.SG1,ID9.SG1) but I'd love to make it true ONLY if both conditions are met: line ID3.SG1 is below line ID3.SG2 AND line ID6.SG1 is below the line ID6.SG2 Could sb please help out? Thank's in adv.

[2016-03-29 17:40:43] #11 [Go To First Post]
Sawtooth - Posts: 4143
Try this: =AND(CROSSFROMABOVE(ID4.SG1,ID9.SG1),ID3.SG1<ID3.SG2,ID6.SG1<ID6.SG2)

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