Login Page - Create Account

Support Board


Date/Time: Mon, 23 Dec 2024 01:06:47 +0000



Post From: ZigZag Line Coloring

[2015-05-16 02:16:38]
Sawtooth - Posts: 4141
Yes, it's possible. Here's an example:

In the ZZ study:
-Set the Volume to Accumulate to something other than None or Ask Bid Volume Difference.
-Set Additional Outputs for Spreadsheet to Yes.
-Check Hide Study.

In the spreadsheet study:
-Give it a name in the Spreadsheet Name field.
-Set the Chart Region to 1.
-Set all Draw Styles to Ignore except M(SG3) and N(SG4).
-Set the M(SG3) color to green, and the N(SG4) color to red.
-Set M(SG3) and N(SG4) Draw Styles to Line-SkipZeros, the Line Styles to Dot, and the Width to 3.
-Use these formulas on the spreadsheet:
K3:
=IF(AD3>0,AE3,K4)
L3:
=IF(AD3<0,AE3,L4)
M3:
=IF(OR(K3>L3,N4=0),AA3,0)
N3:
=IF(OR(K3<L3,M4=0),AA3,0)

The formulas assume the ZZ study is at the top of the Studies to Graph list.
Date Time Of Last Edit: 2015-05-16 02:21:20