Login Page - Create Account

Support Board


Date/Time: Mon, 29 Apr 2024 01:06:56 +0000



Post From: Volume - Colored Based on Volume

[2020-06-25 14:50:56]
Sawtooth - Posts: 3982
The formula I offered will only work when using Volume - Colored Based on Volume study, as you put in the title of this thread.
Sorry, I didn't notice in the pics that you were instead using the Volume - Colored Based on Bar Closes study.

I see that you are also using Renko bars. Apparently the Volume - Colored Based on Bar Closes study is not using Renko open and close values.

Try this:
1. Add the Renko Visual Open/Close Values study, and hide the study.

2. Use a formula like this in O3:
=IF(AF3>AE3,1,IF(AF3<AE3,-1,O4))
-where the Renko open is in AE3 and the Renko close is in AF3. Edit as needed.

3. Use these formulas in K3/M3:
K3: =AND(AC3>3000000,O4=-1,O3=1)
M3: =AND(AC3>3000000,O4=1,O3=-1)