Support Board
Date/Time: Fri, 07 Feb 2025 14:38:53 +0000
Post From: Bar based on midpoint
| [2022-01-07 19:22:44] |
| Sawtooth - Posts: 4173 |
|
This can also be done with 4 native studies: 1. Add the Color Bar Based On Alert Condition study. - Put this formula on its Alerts tab: =C[1] This locates the current bar. 2. Add the Spreadsheet Formula study. - Check 'Hide Study' - Put this formula in its Formula field: =AVERAGE(BID,ASK) 3. Add another Color Bar Based On Alert Condition study. - Use a formula like this on its Alerts tab: =AND(ID1.SG1=0,ID2.SG1>O) [that's an O for Open, not a zero] where ID1.SG1 is the color bar study in #1 above, and ID2 is the spreadsheet formula study in #2 above. - Set the DrawStyle color for an up bar. 4. Duplicate the Color Bar Based On Alert Condition study of #3 above, with these changes: - Use this formula: =AND(ID1.SG1=0,ID2.SG1<O) - Set the DrawStyle color for a down bar. |