Home >> Support Board

Support Board

Date/Time: Sun, 28 Apr 2024 11:26:01 +0000

How to Post a Message for Support

[Programming Help] - Color Bar Alert with Pivot Points

View Count: 1335

[2016-07-01 00:52:30] #1 [Go To First Post]
Crudeoilist - Posts: 18
Dear Sir/Ma'am, How can I set and alert condition to color the bar when price is = to R1 or S1 in the pivot point study? I had loaded both the studies and used the following formula in the color bar alerts field. "=C=(ID:1,SG3)=1" Thanks in advance Crudeoilist

[2016-07-01 12:52:16] #2 [Go To First Post]
jackw - Posts: 57
To trigger an alert if price reaches R1 at any time during a bar, the formula would be: AND(H[-1]<ID1.SG3, H>=ID1.SG3) (Assuming ID1.SG3 refers to the R1 indicator line)

[2016-07-01 13:06:02] #3 [Go To First Post]
Crudeoilist - Posts: 18
Hi JackW, Firstly, I would like to thank you for taking the time help me. I am using the study "Color Bar Based on Alert Condition" with the formula "=CROSSOVER(C, ID1.SG3)" and the bars seem to change color at the pivot points but at times when the wick form at the pivot point on a 1min bar, the color does not change. (ID1 refers the pivot point study and SG3 refers the particular pivot point) Now in the spreadsheet under the BUY entry I use "=ID2.SG1@3 = 1" The formula you mentioned goes into the alert condition for the color bar or in the buy column in the spreadsheet? Thanks again

[2016-07-01 14:49:48] #4 [Go To First Post]
jackw - Posts: 57
I was referring to the formula for the "Color Bar Based on Alert Condition" study. Your formula, CROSSOVER(C,ID1.SG3), should also work, although you may have to change the "C" to an "H" to trigger an alert when only the wick reaches the pivot point. Unfortunately, I can't help you with your Buy/Sell entries in the spreadsheet. I have no experience with this.

[2016-07-04 11:02:15] #5 [Go To First Post]
Crudeoilist - Posts: 18
Thank you JackW you have been a great help with the tip regarding "H" i managed the buy sell entries, let me know if you need help with that. Kind regards, Crudeoilist

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