Support Board
Date/Time: Sat, 30 Nov 2024 04:31:30 +0000
[Programming Help] - Renko Reversal Bar Alert
View Count: 679
| [2022-12-18 21:37:39] |
| User216753 - Posts: 19 |
|
Hello, I need an alert that will alert me when a renko bar closes that is the opposite color of the bar previous to it when the bar previous to it is a candle that fulfills a predetermined number of bars of the same color (trend). Thanx |
| [2022-12-20 16:02:46] |
| User216753 - Posts: 19 |
|
Still waiting on an answer?
|
| [2022-12-20 22:27:12] |
| Sawtooth - Posts: 4123 |
|
1. Use this spreadsheet syntax example to find the candle colors: Spreadsheet Example Formulas and Usage: Formula that Matches the Coloring of Up and Down Price Bars Edit to Alert syntax; see below. 2. Use these Alert syntax identifiers for Renko Open and Close: Study/Chart Alerts And Scanning: Available Main Price Graph Identifiers/Variables 3. Add the Spreadsheet Formula study. Hide the study. In the Formula field, paste and edit the formula example from #1 above: B3 to ID0.SG22 E3 to ID0.SG23 E4 to ID0.SG23[-1] T4 to ID1.SG1[-1] where ID1 is the Spreadsheet Formula study. 4. For long alerts, add the Color Bar Based On Alert Condition study. Use a formula like this on its Alerts tab: =AND(ID1.SG1=1, ID1.SG1[-1]=-1, ID1.SG1[-2]=-1, ID1.SG1[-3]=-1) where ID1 is the Spreadsheet Formula study. 5. For short alerts, add another Color Bar Based On Alert Condition study. Use a formula like this on its Alerts tab: =AND(ID1.SG1=-1, ID1.SG1[-1]=1, ID1.SG1[-2]=1, ID1.SG1[-3]=1) where ID1 is the Spreadsheet Formula study. Date Time Of Last Edit: 2022-12-20 22:35:46
|
| [2022-12-21 15:22:17] |
| User216753 - Posts: 19 |
|
Thank you so much!!
|
To post a message in this thread, you need to log in with your Sierra Chart account: