Support Board
Date/Time: Sun, 24 Nov 2024 02:38:42 +0000
[User Discussion] - Background Alert for Prior Daily H/L Crossover in Replay Mode
View Count: 94
| [2024-11-06 12:09:58] |
| User871209 - Posts: 85 |
|
Hello, I'm trying to set up an alert with a background color change when the prior daily high or low of the current daily candle is crossed. My setup includes: - Daily High/Low Study - Color Background Based on Alert Condition Study: =CROSSOVER(C, ID1.SG2) OR CROSSUNDER(C, ID1.SG3) However, when I run the replay to test this, the background color alert isn’t triggering as expected. Is there an error in my setup, or is there an issue with using Replay Mode for this type of alert? Any assistance would be greatly appreciated. Thank you! |
| [2024-11-06 14:55:36] |
| Sawtooth - Posts: 4118 |
|
There is no CROSSUNDER function. The CROSSOVER function works both directions. Also, the syntax is wrong. Try this: =OR(CROSSFROMBELOW(C, ID1.SG2), CROSSFROMABOVE(C, ID1.SG3)) https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#CROSSFROMABOVE_Function Study/Chart Alerts And Scanning: Alert Formula Examples Date Time Of Last Edit: 2024-11-06 14:57:07
|
| [2024-11-06 16:57:45] |
| User871209 - Posts: 85 |
|
Hello Sawtooth, Thank you so much for your help—I really appreciate it! I followed your instructions for the alert setup, adjusting the ID to match my Daily OHLC (ID13) as follows: =OR(CROSSFROMBELOW(C, ID13.SG2), CROSSFROMABOVE(C, ID13.SG3)) It works perfectly when the candle crosses the low, but it doesn’t seem to trigger when it crosses the high. Do you have any thoughts on why this might be happening? Once again Thanks, Regards, |
| [2024-11-06 18:08:06] |
| Sawtooth - Posts: 4118 |
|
Do you have any thoughts on why this might be happening?
Sorry, I didn't test it. I just fixed the syntax.In the Daily OHLC study, set the 'Graph High and Low Historically' to Yes. Then use this formula instead: =OR(ID13.SG2 > ID13.SG2[-1], ID13.SG3 < ID13.SG3[-1]) |
| [2024-11-06 18:18:30] |
| User871209 - Posts: 85 |
|
Sawtooth, Perfect, it works flawlessly! Thank you again, Kudos, |
To post a message in this thread, you need to log in with your Sierra Chart account: