Login Page - Create Account

Support Board


Date/Time: Fri, 07 Feb 2025 17:24:26 +0000



Alert sounds based on color bar

View Count: 883

[2016-04-05 18:54:41]
User174857 - Posts: 11
Using Color Bar Based on Alert Condition. Alert Condition = ( c[0] <= c[-1] <= c[-2] )
Have Enabled checked and alert sound set.

Trying to get an audio alert on every tick the color bar is true. It works coloring the bar, but will not always give an audio alert on future ticks. So sometime there is a real long bar with many ticks but have no audio alerts as bar grows as it keeps coloring it. How do I get it to sound alert for every tick that equals true?
[2016-04-06 06:06:31]
Sierra Chart Engineering - Posts: 104368
This is not a valid formula and will work unreliably.

You would have to use the AND or OR functions:
https://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetFunctions.html
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
Date Time Of Last Edit: 2016-04-06 06:06:45
[2016-04-06 11:22:27]
User41683 - Posts: 37
In other words use this: =AND(C<=C[-1),C[-1]<=C[-2])
[2016-04-06 18:59:19]
Sierra Chart Engineering - Posts: 104368
There was a slight error in that formula. Here is the corrected formula:
=AND(C<=C[-1],C[-1]<=C[-2])
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
[2016-04-06 19:40:18]
User41683 - Posts: 37
Yes, stupid mistake. ] instead of )
[2016-04-06 20:13:17]
User174857 - Posts: 11
thanks for your help.. learning more as I go along

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

Login

Login Page - Create Account