Home >> Support Board

Support Board

Date/Time: Sun, 09 Mar 2025 20:28:01 +0000

How to Post a Message for Support

[Programming Help] - Can't hear the alert condition

View Count: 705

[2022-03-09 13:35:33] #1 [Go To First Post]
User837393 - Posts: 143
In a spreadhseet study I'm using the following alert condition: =OR(ID17.SG12=True, ID17.SG16=True, ID17.SG23=True, ID17.SG27=True, ID17.SG34=True, ID17.SG38=True, ID17.SG45=True, ID17.SG49=True) ...where ID17.SGxx Outputs a value of 1 or 0 for a Point on High or a Point on Low on a bar. I dont hear anything, but I do see the marker on the chart (telling me that the spreadhseet is working as intended). My issue is that I would like to have an audible alert when one of those parameteres is triggered, nut unfortunately I don't hear anything. Is there something I'm missing.

[2022-03-09 14:35:15] #2 [Go To First Post]
User837393 - Posts: 143
UPDATE: When implementing the alert condition into the Alert Tab of the chart (and not the study), it works. ...more to follow.... I will still try as to why it's not working when the condition is implemeted in the study itself. ...it use to work.

[2022-03-09 16:39:23] #3 [Go To First Post]
John - SC Support - Posts: 38516
When you say that you have the alert condition entered in the Study, are you saying that it is entered into a cell in the spreadsheet? Or is it entered on the Alert tab of the study? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2022-03-09 16:53:34] #4 [Go To First Post]
User837393 - Posts: 143
I meant in the Alert Tab of the study. The spreadsheet outputs a Point on Low or High of the bar only.

[2022-03-09 17:59:19] #5 [Go To First Post]
John - SC Support - Posts: 38516
And you have an Alert Sound selected on the Alert Tab for the study? And that alert is setup to give an audible alert: For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2022-03-09 18:30:44] #6 [Go To First Post]
User837393 - Posts: 143
Correct. In the Study Tab, the Alert 3 is selected. ... the starnge thing is that the audible alert works if the alert condition is implemented in the Chart Alert Tab.

[2022-03-09 18:59:46] #7 [Go To First Post]
John - SC Support - Posts: 38516
Are you getting the information posted to the Alert Message Log? If so, can you copy and paste a line? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2022-03-09 19:48:28] #8 [Go To First Post]
User837393 - Posts: 143
AS requested: Alert - Chart: ES-202203-GLOBEX/MES-202203-GLOBEX-USD [C][M] 2000 Trades #3 \| Study: Auto-Trade \| Formula: BC at row 4 is TRUE. \| Last Price: 4282.00 \| Bar start date-time: 2022-03-09 14:43:45 \| No alert sound/email.

[2022-03-09 21:58:18] #9 [Go To First Post]
John - SC Support - Posts: 38516
According to that line, you do not have an Alert Number selected for that Alert Sound for that study. You need to select a specific alert in order to get the sound for that alert. Refer to the following: Study/Chart Alerts And Scanning: To Enter an Alert Condition on a Study For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2022-03-09 21:58:39

[2022-03-09 22:19:33] #10 [Go To First Post]
User837393 - Posts: 143
What is the meaning of that quote : « The Spreadsheet System/Alert study and the Spreadsheet System for Trading study, do not support specifying an Alert Condition Formula or using the Alert options on the Alerts tab of the Study Settings window for these studies. The reason for this, is that the studies themselves have advanced alert functionality which is separate from the Alerts tab. » I’m specificaly using the spreadsheet system for trading study. Is this the reason why the audible alert condition is not working? … as mentionned earlier, that same condition works if implemented in the alert tab of the chart setings.

[2022-03-09 22:35:24] #11 [Go To First Post]
John - SC Support - Posts: 38516
At this point the information and the results have us confused. Can you please get us the Chartbook that has the chart and Spreadsheet in it and also attach the Spreadsheet itself. Refer to the following for how to attach files: https://www.sierrachart.com/index.php?page=PostingInformation.php#AttachFile We'll take a look at how everything is setup and figure out what is going on. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2022-03-10 17:09:11] #12 [Go To First Post]
User837393 - Posts: 143
For the moment I think its ok. I've just programed the alert condition throught the chart Alert Tab and I get the audible alert, which meets my intent. I now have another problem. Buy Exit and Sell Exit column. Sometime they work sometime they dont. What confuses me is that: Should we be using an IDxx.SGzz@3 or @4 when the spreadsheet study settings for the "Signal Only on Bar Close (Ln 17 & 18)" is set to yes? My understanding is that : If @4 row argument is used in the buy or sell condition => then ln 17 & 18 should be set to No If @3 row argument is used in the buy or sell condition => then ln 17 & 18 should be set to Yes Is this correct ? P.S : here is my Buy(Exit) condition : =AND ((OR((ID26.SG1@4)>0,(ID28.SG1@4)>0,(ID29.SG1@4)>0,(ID30.SG1@4)>0,(ID31.SG1@4)>0,(ID32.SG1@4)>0,(ID38.SG1@4)>0,(ID40.SG1@4)>0,(ID45.SG1@4)>0)),$J$8>0) Thank you Date Time Of Last Edit: 2022-03-10 17:20:18

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