Home >> Support Board

Support Board

Date/Time: Sun, 08 Sep 2024 01:32:19 +0000

How to Post a Message for Support

[Programming Help] - programming simple alert

View Count: 238

[2024-06-17 22:05:05] #1 [Go To First Post]
User653934 - Posts: 28
I want an alert on all my small time frame charts that goes off when the vwap and 9ema are =. I get a SYNTAX error when I try to program. It's about as clear as mud to me how to do this simple alert. Can anyone help? Date Time Of Last Edit: 2024-06-17 22:05:46

[2024-06-18 02:31:52] #2 [Go To First Post]
Sawtooth - Posts: 4083
I want an alert on all my small time frame charts that goes off when the vwap and 9ema are = Use a formula like this: =ID1.SG1=ID4.SG1 where ID1 is the 9EMA and ID4 is the VWAP However, it is unlikely that they would ever be exactly equal. You could use this formula to get an alert if they are within 1 tick of each other: =ABS(ID1.SG1-ID4.SG1)<TICKSIZE Note: Some spreadsheet functions work in Alert syntax. https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#ABS_Function Study/Chart Alerts And Scanning: Available Main Price Graph Identifiers/Variables

[2024-06-18 12:14:58] #3 [Go To First Post]
User653934 - Posts: 28
I'll go to work on it. Thank you.

[2024-07-31 21:16:43] #4 [Go To First Post]
User653934 - Posts: 28
I'm still getting syntax error. Do I put the 9EMA-Avg where the SG1 is? SC says I can use the unique identifier to the right of the Study. S_ID:27 for instance, but it sets off an alert every bar....

[2024-07-31 21:21:49] #5 [Go To First Post]
Sawtooth - Posts: 4083
What is the ID# of your VWAP study? What is the ID# of your 9EMA study?

[2024-07-31 21:24:08] #6 [Go To First Post]
User653934 - Posts: 28
vwap S_ID:108 9ema S_ID:27 They are both SG1 on the study page. Date Time Of Last Edit: 2024-07-31 21:24:30

[2024-07-31 22:44:37] #7 [Go To First Post]
Sawtooth - Posts: 4083
Use a formula like this: =ID27.SG1=ID108.SG1 where ID27 is the 9EMA and ID108 is the VWAP However, it is unlikely that they would ever be exactly equal. You could use this formula to get an alert if they are within 1 tick of each other: =ABS(ID27.SG1=ID108.SG1)<TICKSIZE

[2024-08-05 10:11:03] #8 [Go To First Post]
User653934 - Posts: 28
Thank you. How do I specify 1 tick? =ABS(ID27.SG1=ID108.SG1)<1TICK Alert Formula Error - Chart: M2KU24_FUT_CME[CB]5 Min #8 Study: Moving Average - Exponential Error:Formula references unknown study. Formula: =ABS(ID27.SG1=ID108.SG1)<1TICK No alertsound/email. I also tried using S_ID27.SG1 format and it shows the same error. Date Time Of Last Edit: 2024-08-05 10:35:57

[2024-08-05 13:10:47] #9 [Go To First Post]
Sawtooth - Posts: 4083
How do I specify 1 tick? Use TICKSIZE. Study/Chart Alerts And Scanning: Available Main Price Graph Identifiers/Variables Formula references unknown study Use the ID# of your 9EMA. I also tried using S_ID27.SG1 format Don't guess at the syntax. Study/Chart Alerts And Scanning: Alert Condition Formula Format

[2024-08-06 12:18:02] #10 [Go To First Post]
User653934 - Posts: 28
The 9ema is ID27. I didn't understand I had to use TICKSIZE, I thought that meant I had to specify the tick size. The formula is no longer giving me error messages. Reading SC specification isn't all that helpful, but you have been. Many thanks.

[2024-08-06 12:47:17] #11 [Go To First Post]
User653934 - Posts: 28
However, despite no error messages, the alert didn't go off when a9ema crossed the vwap. I saw it and made a profitable trade, but no signal.

[2024-08-06 12:53:08] #12 [Go To First Post]
Sawtooth - Posts: 4083
the alert didn't go off when a9ema crossed the vwap Try this formula: =CROSSOVER(ID27.SG1,ID108.SG1) To see a visual of where this happens, add the Color Bar Based On Alert Condition study, and put the above formula on its Alerts tab.

[2024-08-06 13:29:28] #13 [Go To First Post]
User653934 - Posts: 28
Hm, that didn't sound off either...Do I have to specify the formula in the chart settings>alert>alert condition? Do I need to name it? Date Time Of Last Edit: 2024-08-06 14:00:54

[2024-08-19 15:28:34] #14 [Go To First Post]
User653934 - Posts: 28
Still not triggering alert. Any ideas? Do I need to do anything in General Settings? Date Time Of Last Edit: 2024-08-19 15:29:36

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