Support Board

• Support Board |
• Search Board |
• Control Panel |
• View My Posts / Threads |
• Direct Messages

Date/Time: Tue, 26 Nov 2024 16:51:16 +0000

Inability to see Zig Zag Length in SpreadSheet

View Count: 377

[Page 1 of 1] First Page -- 1 -- Last Page

[2023-11-06 22:57:09] #1 [Go To First Post]
TajirUser - Posts: 3
Dear Sierra Staff, It is hoped that this finds you well. I am unable to access ZigZag length from a spreadsheet, its visuals are attached below (but briefly though there is a value for ZigZag, there are only zero values for ZigZag length) (Image 1). I, initially, wondered if it might be a case of the tick-size (2000) of the candle-sticks being too small for there to be no ZigZag transition in even 2000 rows but changing the tick-size of the candlesticks to 20,000 had no effect. I also tried turning on "Display HH,HL,LL,LH Labels" but that had the effect of turning the zeros to numbers representing swing structure (as intended) and no additional column being added for ZigZag length (Image 2). I have attached screenshots of the spreadsheet under both conditions, and those of my settings for the spreadsheet study (Image 3, could not access edit to take image). Your assistance in moving forwards is much appreciated (for I am rather lost). Kind Regards https://www.sierrachart.com/image.php?Image=1699311124343.png https://www.sierrachart.com/image.php?Image=169931122779.png
0x Thank you
Attachment Deleted. SpreadSheet_Study.png / V - Attached On 2023-11-06 22:55:05 UTC - Size: 228.04 KB - 63 views

[2023-11-07 01:06:19] #2 [Go To First Post]
Sawtooth - Posts: 4120
The Zigzag Line Length is SG4, but it isn't displayed on the spreadsheet unless 'Additional Outputs For Spreadsheets' is set to Yes. Also, 'Include In Spreadsheet' must be checked. These settings are in the Zigzag study.
0x Thank you

[2023-11-07 11:20:21] #3 [Go To First Post]
TajirUser - Posts: 3
Hi Sawtooth, I appreciate your taking the time to respond, I have previously already set "Additional Outputs For Spreadsheets" to yes and "Include in Spreadsheet" is checked for SG4, Zigzag Line Length. I have attached screenshots for reference. I have further turned on & off "Additional Outputs For Spreadsheets" and recalculating & reloading the chart, noting that there is no effect on the Spreadsheet at all (either way it only includes columns for SG1 and SG2). Completely confused. Date Time Of Last Edit: 2023-11-07 11:35:08
0x Thank you
ZigZag_Settings.png / V - Attached On 2023-11-07 11:18:59 UTC - Size: 87.81 KB - 60 views ZigZag_Subgraphs.png / V - Attached On 2023-11-07 11:19:15 UTC - Size: 69.99 KB - 61 views

[2023-11-07 12:05:19] #4 [Go To First Post]
TajirUser - Posts: 3
After more tinkering, I realized my potential mistake - perhaps the Spreadsheet study can only grab visible the values of visible sub-graphs and ZigZag Line Length's visibility was presently set to Ignore, setting it to Line resolved things. I would be grateful if it could be confirmed that the Spreadsheet study can only grab visible the values of visible sub-graphs (even if "Include in Spreadsheet" is checked) for future reference. Date Time Of Last Edit: 2023-11-07 12:06:43
0x Thank you

[2023-11-07 16:24:36] #5 [Go To First Post]
John - SC Support - Posts: 36300
Refer to the following Input for the Spreadsheet Study: Spreadsheet Study Inputs: Do Not Output Subgraphs Set To Ignore For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing
1x Thank you

[Page 1 of 1] First Page -- 1 -- Last Page