Login Page - Create Account

Support Board


Date/Time: Wed, 12 Mar 2025 15:57:16 +0000



[User Discussion] - trade alert

View Count: 639

[2022-05-09 16:33:18]
Ken Smith - Posts: 58
Im trying to build an alert. I am using a hurst moving avg, and a weighted moving avg. I have then changing color when the slope changes.

How can I build an alert that triggers when both MA,s change color either long or short.

I cant find anything in the instructions.

Thanks
Ken
[2022-05-09 17:01:36]
John - SC Support - Posts: 38610
Refer to the following:
Study/Chart Alerts And Scanning: Writing Formulas Based On Color Settings
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2022-05-09 17:58:20]
Ken Smith - Posts: 58
I tried using the formulas #8 and #9 , and neither one alerted a trade on the chart. I copy pasted the formulas from the Alert Formula Examples page.

Maybe Im looking at it wrong, where if the two moving averages change color based on slope trigger the alert.

Im doing this under the Trading system based on alert conditions.

thanks
ken
[2022-05-09 18:01:10]
Ken Smith - Posts: 58
I also want the trigger to happen when they are both in agreement at the same time....ie: both changed color base on slope
thanks
ken
[2022-05-10 03:19:29]
Sawtooth - Posts: 4182
Example 8 works if there are no segments of equal value.
Example 9 works if there is no more than one segment of equal value.
This spreadsheet syntax formula works if there are any number of segments of equal value:
Spreadsheet Example Formulas and Usage: Formula that Matches the Slope Coloring of a Study Subgraph Line
(This formula can be converted to Alert syntax, and then used in the Spreadsheet Formula study.)

Try this (this uses a variation of Example 9):
- Add the Spreadsheet Formula study, check Hide Study, and use a formula like this in its Formula field:
=IF(AND(ID1.SG1[0] > ID1.SG1[-1] , ID1.SG1[-1] <= ID1.SG1[-2]) , 1, IF(AND(ID1.SG1[0] < ID1.SG1[-1], ID1.SG1[-1] >= ID1.SG1[-2]) ,-1, ID3.SG1[-1]))
where ID1 is one MA, and ID3 is this Spreadsheet Formula study.
- Duplicate the above Spreadsheet Formula study and edit the formula to this:
=IF(AND(ID2.SG1[0] > ID2.SG1[-1] , ID2.SG1[-1] <= ID2.SG1[-2]) , 1, IF(AND(ID2.SG1[0] < ID2.SG1[-1], ID2.SG1[-1] >= ID2.SG1[-2]) ,-1, ID4.SG1[-1]))
where ID2 is the other MA and ID4 is this Spreadsheet Formula study.

These formulas create a persistent variable where 1 is upsloped and -1 is downsloped.

Buy signal:
=OR(AND(ID3.SG1[-1] = -1 , ID3.SG1 = 1 , ID4.SG1 = 1),AND(ID4.SG1[-1] = -1 , ID4.SG1 = 1 , ID3.SG1 = 1))
Sell signal:
=OR(AND(ID3.SG1[-1] = -1 , ID3.SG1 = 1 , ID4.SG1 = 1),AND(ID4.SG1[-1] = -1 , ID4.SG1 = 1 , ID3.SG1 = 1))
[2022-05-10 15:48:02]
Ken Smith - Posts: 58
I read that for a fee Sierra can build strategies etc. I appreciate the work you have done for me, but I have decided that I would like to add two more indicators, and when all 3 are in agreement then place a trade.

I hope that is the case.

If so, how do I contact those folks?

thanks
Ken
[2022-05-10 17:12:11]
John - SC Support - Posts: 38610
We do not build custom studies for customers. People like Tom Gilbert, who has been helping you does that kind of work. You can also find a list of other potential developers at the following link:
List of Third Party Sierra Chart Study and System Programmers
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2022-05-11 00:09:58]
Sawtooth - Posts: 4182
If so, how do I contact those folks?
What you want to do can be done with the Spreadsheet System for Trading study.
Contact me here:
https://www.sawtoothtrade.com/contact.html

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

Login

Login Page - Create Account