Login Page - Create Account

Support Board


Date/Time: Fri, 22 Nov 2024 06:06:19 +0000



Alert Formula for 50 Moving AVG

View Count: 2601

[2013-04-30 23:55:46]
User20200 - Posts: 38
I am looking for the exact Alert Formula for when the PRICE BARS crossover or hit the 50 Moving AVG on Chart please???

Thank you,
Team One
[2013-05-01 00:17:08]
M5amhan - Posts: 468
=CROSSOVER(LASTTRADE,ID1.SG1) in the alert tab of your mov avg settings. this is assuming ID1.SG1 is your 50 mov avg
Date Time Of Last Edit: 2013-05-01 00:22:24
[2013-05-01 00:32:41]
User20200 - Posts: 38
Tried it, not doing anything... I have other studies for MACD & RSI and all work great!

My 50 MA is ID:10 of which I put in:

=CROSSOVER(LASTTRADE,ID10.SG1)

Help?
[2013-05-01 00:34:45]
M5amhan - Posts: 468
you have to wait for price to crossover before hearing an alert, this is what you wanted right?
[2013-05-01 00:39:28]
User20200 - Posts: 38
EXACTLY!!! When the PRICE BAR touches, hits crosses - I want an alert to ding... I use Range Bars 8 Tick

I am playing it on replay and all my other alerts work fine... Still not working!

Sorry

[2013-05-01 00:51:25]
M5amhan - Posts: 468
I just did it on replay as well and it didnt work either, but it works real time.. I tested it before posting it for you. I am not sure why it wont work on replay. =OR(CROSSOVER(LASTTRADE,ID1.SG1),(LASTTRADE=ID1.SG1)) this is a code that will give you an alert when it touches as well as crossover, I missed the touch part.
Date Time Of Last Edit: 2013-05-01 00:51:34
[2013-05-01 00:52:17]
Sierra Chart Engineering - Posts: 104368
This is the formula to use on the Moving Average study:
AND (H >= ID1.SG1,L <= ID1.SG1)

Either change or remove ID1. This formula can also be tested by using the Color Bar Based on Alert Condition study. This is how we did it.
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

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

Login

Login Page - Create Account