Login Page - Create Account

Support Board


Date/Time: Fri, 07 Feb 2025 18:27:03 +0000



Post From: How to Colour Price Bars base on Green and Red Cumulative Delta Volume bars ?

[2021-06-21 12:21:48]
Sawtooth - Posts: 4173
You'll need to create a persistent value for each of the two colors so that it stays the same until the next color change.

Add the Spreadsheet Formula study
- Set the Chart Region to 1
- Use a formula like this in the Formula field:
=IF(AND(ID8.SG1[0]>ID8.SG1[-1],ID8.SG1[-1]<=ID8.SG1[-2]),1,IF(AND(ID8.SG1[0]<ID8.SG1[-1],ID8.SG1[-1]>=ID8.SG1[-2]),-1,ID6.SG1[-1]))
where ID6 is the Spreadsheet Formula study, and ID8 is the SMA Length 1 of the CDelta study.
- Set the Draw Style to Color Bar
- Set the Auto-Coloring to Based On +/-

The formula is a variation of example #9 here:
Study/Chart Alerts And Scanning: Alert Formula Examples
Date Time Of Last Edit: 2021-06-21 12:22:02