Support Board
Date/Time: Sun, 22 Dec 2024 14:57:03 +0000
Zig-Zag Cumulative
View Count: 1096
| [2015-02-08 20:19:37] |
| JayShea - Posts: 92 |
|
I'd like to write a condition in a spreadsheet that recognizes whether the ZZ-Cumulative is positive or negative. I.E. If ZZ is positive only show Buy conditions and vice-versa Is that possible? Thanks JD |
| [2015-02-09 17:06:58] |
| |
|
Look at the slope of the of the zigzag Subgraph (SG1). To make sure this is outputted to the Spreadsheet, make sure Do Not Output Subgraphs Set to Ignore is set to No. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2015-02-10 16:26:18] |
| JayShea - Posts: 92 |
|
Support Thanks for the reply. I feel dense due to my inability to find the option you reference Do Not Output Subgraphs Set to Ignore is not readily visible to me. I see SG1 and attach a screen shot of what I'm viewing. As such I don't see "slope of the of the zigzag Subgraph (SG1)." I also attach a screenshot of Settings and Inputs. Finally I attach a screenshot of the Spreadsheet showing the columns representing SG1 and SG2 (as I understand those items). Please tell me what I'm not getting. I'm well caffeinated so it should be clear when you offer a solution. Thanks JD |
 2015-02-10_1117_ZZ_SpS.png / V - Attached On 2015-02-10 16:25:11 UTC - Size: 16.97 KB - 403 views 2015-02-10_1114__ZZ_S&I.png / V - Attached On 2015-02-10 16:25:18 UTC - Size: 71.12 KB - 370 views 2015-02-10_1112__ZZ_S_Settings.png / V - Attached On 2015-02-10 16:25:24 UTC - Size: 68.31 KB - 389 views |
| [2015-02-10 17:00:13] |
| |
|
Do Not Output Subgraphs Set to Ignore is part of the Spreadsheet study. However, we see that Subgraph 1 from the Zig Zag study is being outputted. So you can look at the slope of the values in column DN. You have to write a formula to check for the slope.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: