Support Board
Date/Time: Thu, 27 Feb 2025 22:42:29 +0000
[User Discussion] - Zig Zag Study Question
View Count: 1234
| [2021-07-23 12:56:56] |
| 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 - 231 views Screenshot 2.JPG / V - Attached On 2021-07-23 12:55:26 UTC - Size: 61.95 KB - 240 views |
| [2021-07-23 18:04:38] |
| Sawtooth - Posts: 4177 |
|
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] |
| 58LesPaul - Posts: 429 |
|
Will this work with ZigZag Cummulative Volume? I tried and got nothing. Thanks |
| [2021-07-23 21:32:19] |
| Sawtooth - Posts: 4177 |
|
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] |
| 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] |
| Sawtooth - Posts: 4177 |
|
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] |
| 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 - 187 views ZZ Setting2.png / V - Attached On 2021-07-31 17:15:26 UTC - Size: 66.84 KB - 189 views ZZ Study subgraph.png / V - Attached On 2021-07-31 17:15:35 UTC - Size: 50.93 KB - 195 views |
| [2021-07-31 17:17:23] |
| 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 - 220 views SS Formula window.png / V - Attached On 2021-07-31 17:16:21 UTC - Size: 36.21 KB - 212 views |
| [2021-07-31 18:16:45] |
| Sawtooth - Posts: 4177 |
|
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] |
| 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: