Home >> Support Board

Support Board

Date/Time: Fri, 26 Apr 2024 23:30:53 +0000

How to Post a Message for Support

[User Discussion] - Zig Zag Study Question

View Count: 1033

[2021-07-23 12:56:56] #1 [Go To First Post]
User483852 - Posts: 16
Hello, I am trying to plot Bid Ask Volume Difference using the Zig Zag Indicator as shown in the screenshot. I am trying to color the text based on + / - but the text on pivot lows gets colored red and pivot highs gets colored green. Please see attached screenshot. What would I need to do inorder to color the text based on positive or negative. Thanks in advance.


Screenshot 1.JPG / V - Attached On 2021-07-23 12:55:22 UTC - Size: 105.44 KB - 194 views Screenshot 2.JPG / V - Attached On 2021-07-23 12:55:26 UTC - Size: 61.95 KB - 203 views

[2021-07-23 18:04:38] #3 [Go To First Post]
Sawtooth - Posts: 3976
It can't be done with the Zigzag study. It can be done with two instances of the Spreadsheet Formula study: 1. Add the Spreadsheet Formula study: - Set the Chart Region to 1. - Set the Value Format to 1. - Set 'Draw Zero Values' to No. - Use a formula like this in the Formula field: =IF(AND(ID1.SG9[-1]>0,ID1.SG9<0),ID1.SG5,0) where ID1 is the ZZ study. - Set the Draw Style to 'Value On High' and set the Width/Size to 10. - Set the Auto-Coloring to 'Based on +/-' 2. Duplicate the above study. - Reverse the operators in the formula in the Formula field: =IF(AND(ID1.SG9[-1]<0,ID1.SG9>0),ID1.SG5,0) - Set the Draw Style to 'Value On Low' 3. In the ZZ study, 'Display Zigzag Volume' needs to be No, or you can Hide the study. Note: The formula only plots SG5 where SG9 changes polarity. Date Time Of Last Edit: 2021-07-31 17:53:39

[2021-07-23 21:21:20] #4 [Go To First Post]
58LesPaul - Posts: 429
Will this work with ZigZag Cummulative Volume? I tried and got nothing. Thanks

[2021-07-23 21:32:19] #5 [Go To First Post]
Sawtooth - Posts: 3976
Will this work with ZigZag Cummulative Volume? No, because that study has no subgraph that can be used to determine where the ZZ legs turn. You can use the ZZ study, and hide it.

[2021-07-31 16:26:27] #6 [Go To First Post]
User483852 - Posts: 16
Thank you for the spreadsheet formula method. It works well. Is there a way to Offset Text Labels for the spreadsheet formula study - that way the labels can be displayed at an offset from the candlestick bars

[2021-07-31 17:09:19] #7 [Go To First Post]
Sawtooth - Posts: 3976
Is there a way to Offset Text Labels for the spreadsheet formula study Use two Study Subgraph Above/Below Bar As Text studies. And Hide the two Spreadsheet Formula studies. Study Subgraph Above/Below Bar as Text Date Time Of Last Edit: 2021-08-02 11:09:20

[2021-07-31 17:16:00] #8 [Go To First Post]
58LesPaul - Posts: 429
Can someone tell me what I'm doing wrong please?


ZZ Study setting.png / V - Attached On 2021-07-31 17:15:17 UTC - Size: 65.66 KB - 150 views ZZ Setting2.png / V - Attached On 2021-07-31 17:15:26 UTC - Size: 66.84 KB - 157 views ZZ Study subgraph.png / V - Attached On 2021-07-31 17:15:35 UTC - Size: 50.93 KB - 165 views

[2021-07-31 17:17:23] #9 [Go To First Post]
58LesPaul - Posts: 429
Spreadsheet Formula Study screenshots


SS Formula Subgraph.png / V - Attached On 2021-07-31 17:16:14 UTC - Size: 45.39 KB - 181 views SS Formula window.png / V - Attached On 2021-07-31 17:16:21 UTC - Size: 36.21 KB - 181 views

[2021-07-31 18:16:45] #10 [Go To First Post]
Sawtooth - Posts: 3976
Can someone tell me what I'm doing wrong please? From post #3: "3. In the ZZ study, 'Display Zigzag Volume' needs to be No, or you can Hide the study." Also in the ZZ study: Set 'Input Data for High' to High. Set 'Input Data for Low' to Low. Note: Except for the 'Ask Bid Volume Difference' at the legs you option, the ZZ study settings can be left at default if you Hide the study. Date Time Of Last Edit: 2021-07-31 20:44:13

[2021-08-02 08:58:05] #11 [Go To First Post]
58LesPaul - Posts: 429
Thanks tomgilb, you are truly an asset to other members on this forum. Much appreciated!

To post a message in this thread, you need to log in with your Sierra Chart account: