Home >> Support Board

Support Board

Date/Time: Sat, 11 Jan 2025 22:57:00 +0000

How to Post a Message for Support

[User Discussion] - zig zag profile

View Count: 2480

[2017-01-06 00:13:05] #1 [Go To First Post]
User771416 - Posts: 47
Is it possible (and if so, how) to plot a histogram of the zig zag study SG4 (length of the line)?

[2017-01-06 04:53:30] #2 [Go To First Post]
Sawtooth - Posts: 4148
You can do it with the Spreadsheet Study study. In the Zigzag study settings, set the 'Additional Output For Spreadsheets' to Yes. Add the Spreadsheet Study study and give it a name in the Spreadsheet Name field. - Set the Draw Style of SG2 to Bar, set all other subgraph Draw Styles to Ignore. - On the spreadsheet: Put this in cell K3: =IF(ID1.SG1@3>0,ID1.SG1@3-ID1.SG1@4,0) Put this in cell L3: =IF(ID1.SG4@4<>0,K3,K3+L4) where ID1 is the Zigzag study; edit as needed. Date Time Of Last Edit: 2017-01-06 15:03:02


ZZ leg +- histogram.PNG / V - Attached On 2017-01-06 15:02:58 UTC - Size: 55.43 KB - 795 views

[2017-01-06 14:16:49] #3 [Go To First Post]
User771416 - Posts: 47
Thanks for that Tom. i was using excel to manually produce the histogram, but was curious to know if i could get it to appear at the bottom of my charts as a histogram.

[2017-01-06 14:26:32] #4 [Go To First Post]
User771416 - Posts: 47
Sorry, i wasn't very clear on that. I'm trying to produce a vertical histogram to show me graphically what my greatest rotation number is. I'm trying to produce a "profile" of rotations.

[2017-01-06 14:54:52] #5 [Go To First Post]
Sawtooth - Posts: 4148
To force the histogram to only be above zero, use this in L3 instead: =IF(ID1.SG4@4<>0,ABS(K3),ABS(K3)+L4) Date Time Of Last Edit: 2017-01-06 15:02:40


ZZ leg + histogram.PNG / V - Attached On 2017-01-06 15:02:28 UTC - Size: 56.72 KB - 854 views

[2017-01-06 14:57:36] #6 [Go To First Post]
User771416 - Posts: 47
Yes, but would that produce a vertical histogram?

[2017-01-06 15:04:56] #7 [Go To First Post]
Sawtooth - Posts: 4148
What is a vertical histogram? Look at the pics in post #2 and post #5. Is the pic in post #5 a vertical histogram?

[2017-01-06 15:28:10] #8 [Go To First Post]
User771416 - Posts: 47
No, they are not. A vertical histogram would be a "volume profile" (VbP), or a TPO profile.

[2017-01-06 15:50:07] #9 [Go To First Post]
Sawtooth - Posts: 4148
What you want to do would require a custom program using ACSIL. http://www.sierrachart.com/index.php?page=doc/SierraChartStudyAndSystemProgrammers.php

[2017-01-06 17:00:39] #10 [Go To First Post]
User771416 - Posts: 47
Thanks for the input, i appreciate it.

[2017-01-07 09:41:52] #11 [Go To First Post]
User560062 - Posts: 100
I happened to ask a similar question on a different thread. When looking at indicators, first thing I would look at is what are the outlier values and the volume histogram tells you that easily. Is this something difficult for sierra to implement on all studies? Other packages have this feature out of the box.

[2017-01-07 17:02:21] #12 [Go To First Post]
User771416 - Posts: 47
i agree. it would be a nice improvement.

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