# Support Board

Date/Time: Thu, 30 Jun 2022 02:22:56 +0000

## [User Discussion] - Simple alert

### View Count: 1363

 [2013-09-18 07:01:49] #1 mayerrs - Posts: 70 hi, could you pls someone help me with this formula? i would like to have this formula in sierra. my friend has it in other software and i am not able to make it in sch. thx in other software is this formula: Crosses Above (CCI (Close , 50) , -100) And Crosses Above (CCI (Close , 14) , 0)
 [2013-09-18 13:03:07] #2 M5amhan - Posts: 468 can you just please say what this formula is supposed to be saying
 [2013-09-18 13:05:33] #3 tomgilb - Posts: 3327 Try this: =AND(CROSSFROMBELOW(ID1.SG1,ID1.SG4),CROSSFROMBELOW(ID2.SG1,ID2.SG2)) This assumes the CCI50 is ID1 and the CCI14 is ID2. Edit formula as needed. It also assumes the Line3 Value of the CCI50 is set to -100.
 [2013-09-18 13:28:47] #4 mayerrs - Posts: 70 trade2day1: it says the code. cci50 cross from bellow -100 and cci14 cros from bellow 0 tomgilb: thank you it works!! do you have please any idea how it also drive for example vertical line when this hapaned? and also, would be possible to see vertical lines every single signal in past when this hapened? pls, see the pic. http://www.financnik.cz/images/pattern0_100long_podrobneji_2.jpg
 [2013-09-18 14:16:39] #5 tomgilb - Posts: 3327 Add the Color Bar Based On Alert Condition study, put the formula in its Alert tab instead, set the Draw Style to Background. There is also a way to do a vertical line, if that's what you'd prefer.
 [2013-09-18 14:45:39] #6 mayerrs - Posts: 70 yip, it works but i would prefer vertcal line. the color bar based on alert condition works not that well. i gotta say i have not foun vertical line study where i coul make this formula work. thx for your patience
 [2013-09-18 14:49:13] #7 M5amhan - Posts: 468 if you use Color Background Based on Alert Condition there is a vertical line option
 [2013-09-18 14:58:17] #8 mayerrs - Posts: 70 i got it, thanks guys