Login Page - Create Account

Support Board


Date/Time: Sat, 04 May 2024 05:15:07 +0000



No alert sound for MACD

View Count: 1259

[2015-12-23 03:36:43]
User457299 - Posts: 38
Hi

I have set my chart setting and MACD studies alert to =ID1.SG3>0 but when the SG3 goes above zero no sound is prompt. I used it on 1 minute chart. I have enabled the alerts. Able to advise on how to set this alerts either SG3 above zero. Thanks.

Regards
Wee Jiat
[2015-12-23 04:00:33]
Sawtooth - Posts: 3993
Try this:
=AND(ID1.SG3[-1]<0,ID1.SG3>0)
[2015-12-23 04:17:23]
User457299 - Posts: 38
My subgraph is a colour base bar type. Your formula given to mean does it mean above zero will prompt sound alert. I still don't get any sound alert.

I want a formula that will prompt an alert sound whenever SG3 is above zero. Thanks.

Chart settings and studies both have alert, which one do I have to set; currently I set both.

Regards
Wee Jiat
[2015-12-23 04:47:25]
Sawtooth - Posts: 3993
The formula in post #2 will go TRUE when the MACD Diff crosses from below 0 to above 0.
This assumes the MACD is ID1.
You can put this formula in the Alerts tab of any study, or on the Alerts tab of the Chart Settings.
If you also want a visual marker or a color bar, you must add the Color Bar Based On Alert Condition study and put this formula in its Alerts tab only.
[2015-12-23 05:26:42]
User457299 - Posts: 38
MACD diff crosses from below 0 to above 0 but no alert sound being prompt. My speaker is working fine.

Is there another formula?
[2015-12-23 08:37:14]
Sierra Chart Engineering - Posts: 104368
You should only put the formula on the MACD study itself. Use this formula on the MACD study Alerts tab:
=SG3>0

Also refer to these troubleshooting steps here:
https://www.sierrachart.com/index.php?page=doc/doc_GeneralSettings.html#TroubleshootingAlertSounds
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
[2015-12-23 10:44:24]
User457299 - Posts: 38
I tried several charts and only works on EUR/JPY. The other charts totally no alerts and alert manager do not show anything. I have input everything correctly.

I have team viewer and can use yahoo chat if support board not able to solve.
[2015-12-23 10:58:01]
Sierra Chart Engineering - Posts: 104368
Could be a problem with the Value Format setting:
https://www.sierrachart.com/index.php?page=doc/doc_StudyChartAlertsAndScanning.php#ValueFormat
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
[2015-12-23 11:14:48]
User457299 - Posts: 38
If I change the price display format, the price display at the Y axis will not be accurate.

I tried but still no alert sound.

Is there other alternative?
[2015-12-23 17:37:38]
Sierra Chart Engineering - Posts: 104368
What symbol is the MACD study applied to? So we can set up an example Chartbook.
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: 2015-12-23 17:37:48
[2015-12-24 00:07:24]
User457299 - Posts: 38
Currently only EURJPY works. The others like AUDUSD, EURNZD, EURGBP, EURCHF etc totally no alerts.

At the studies alerts I input =SG3>0, but when when the currency pair moves above 0, there is no alerts.

I tried user52989 =OR(AND(SG1[-1]>0.01,SG1[0]<0.01),AND(SG1[-1]<-0.01,SG1[0]>-0.01)) also failed.
[2015-12-24 01:08:46]
Sawtooth - Posts: 3993
You'll need to change the Value Format of the MACD study to at least 0.00001

If you only want the alert in the bar when the crossover occurs, this will work:
=AND(ID1.SG3[-1]<0,ID1.SG3>0)

If you want the alert at every bar when it is above 0, this will work:
ID1.SG3>0

User52989's contribution will alert on the first occurrence if the MACD Diff is outside a narrow band on both sides of 0, but the offsets will probably not be what you want, plus you didn't change SG1 to SG3.

You can quickly and easily see a visual of what works and what doesn't by using these formulas with an ID# in the Color Bar Based On Alert Study.

Since the MACD Diff is a histogram of the MACD and its MA, you could use this formula instead:
=CROSSFROMBELOW(ID1.SG1:ID1.SG1[-1],ID1.SG2:ID1.SG2[-1])
This will alert at the first occurrence only.
Date Time Of Last Edit: 2015-12-24 01:14:20
[2015-12-24 02:14:25]
User457299 - Posts: 38
I have changed the MACD value format to 0.00001 and there is alert sound. It should be fine for the other currency pair.

Thanks a lot tomgilb, really appreciate your kind assistance.
[2015-12-28 06:32:53]
User457299 - Posts: 38
I would want to be alerted if SG3 goes either above 0 or below 0.

What is the input formula? Thanks.
[2015-12-28 07:05:16]
Sawtooth - Posts: 3993
Try this:
=OR(AND(ID1.SG3[-1]<0,ID1.SG3>0),AND(ID1.SG3[-1]>0,ID1.SG3<0))
[2015-12-28 10:37:47]
User457299 - Posts: 38
Don't seems to work. Got other input formula.
[2015-12-28 17:01:57]
Sawtooth - Posts: 3993
The formula is valid, but with AUDUSD, there is not enough default granularity in the data to correctly display it.
You'll need to go to Global Settings >> Symbol Settings and change the Tick Size to 0.000005, then go to Edit >> Delete All Data and Download. Then go to the MACD study and set the Value Format to 0.00000001
[2015-12-29 05:24:54]
User457299 - Posts: 38
I have changed tick size and value format as stated, still no alert. I also delete all data and download.
[2015-12-29 07:27:24]
Sawtooth - Posts: 3993
It worked for me. I don't how I can help you further.
[2015-12-29 07:44:09]
User457299 - Posts: 38
I am so sorry. It work for me also, it just gave me an alert. I have to test it in real time before knowing this formula is valid or not.

Thanks a lot.
[2015-12-29 07:52:48]
User457299 - Posts: 38
Your tick size and value format with so many zero, does this imply to AUDUSD only or to all currency.

If I at the same time wants SG1 to also alert me when there is a crossover to either above or below zero, do I just replace SG3 to SG1 for the formula given?

If not what is the formula for both SG1 and SG3 to alert me when either SG1 or SG3 goes above or below zero?
Date Time Of Last Edit: 2015-12-29 10:33:23
[2015-12-29 17:08:02]
Sawtooth - Posts: 3993
Your tick size and value format with so many zero, does this imply to AUDUSD only or to all currency.
You would only need to do this to any symbol that didn't display properly.

If I at the same time wants SG1 to also alert me when there is a crossover to either above or below zero, do I just replace SG3 to SG1 for the formula given?
If you change SG3 to SG1, the alert will be when the MACD crosses zero.

If you want an alert when either cross zero in either direction:
=OR(AND(ID1.SG3[-1]<0,ID1.SG3>0),
AND(ID1.SG3[-1]>0,ID1.SG3<0),
AND(ID1.SG1[-1]<0,ID1.SG1>0),
AND(ID1.SG1[-1]>0,ID1.SG1<0))
I visually arranged the formula so you can see the pattern.

If you add the Color Bar Based On Alert Condition study to your chart, and put the formula in its Alerts tab, you will see a visual where each alert happens, without having to test it in real time or in replay. There is no other way to resolve a problem like this because you need to see every alert TRUE.

I don't mind helping with formulas but so that you can eventually become self-reliant, study the documentation on Simple Alerts:
http://www.sierrachart.com/index.php?page=doc/doc_StudyChartAlertsAndScanning.php
There are many examples at the bottom of the page.
[2015-12-30 05:13:01]
User457299 - Posts: 38
Thank up very much.

The formula works completely to my requirement. With the colour bar based on alert condition, I am able to see my alerts without having to test it on real time; so much easier.

I have actually gone through the documentation suggested by your link but not able to decipher much out of it. I presume may need some basic programming knowledge, will spent more time on your link provided.

Really appreciate for your patience in assisting. Thanks again.

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

Login

Login Page - Create Account