Login Page - Create Account

Support Board


Date/Time: Fri, 27 Dec 2024 17:14:41 +0000



Post From: Color Background

[2016-04-09 14:33:35]
Sawtooth - Posts: 4143
You can do this with the Spreadsheet Study study, sort of.
(Need Fill Top-Skip Zeros & Fill Bottom-Skip Zeros Draw Styles to do it better)

Add the Spreadsheet Study study
-Set the Chart Region to 1
-Check 'Draw Study Underneath Main Price Graph'
-Give it a name in the Spreadsheet Name field
-Set the Draw Style of K(SG1) to Fill Top, and choose color
-Set the Draw Style of L(SG2) to Fill Bottom
-Click OK and OK
On the spreadsheet, use these formulas in cells K3 and L3:
K3:
=IF(AND(E3<ID1.SG2@3,E3>ID1.SG3@3),ID1.SG2@3,0)
L3:
=IF(AND(E3<ID1.SG2@3,E3>ID1.SG3@3),ID1.SG3@3,0)
where ID1 is the Keltner study. (E3 is the Last price).

Edit the ID# as necessary.