Login Page - Create Account

Support Board


Date/Time: Sat, 30 Nov 2024 04:28:36 +0000



Post From: Renko Reversal Bar Alert

[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