Home >> Support Board

Support Board

Date/Time: Wed, 15 May 2024 10:09:10 +0000

How to Post a Message for Support

Zig Zag Line Length in Percent in Spreadsheet Not Showing

View Count: 427

[2021-07-01 09:24:21] #1 [Go To First Post]
Craig90 - Posts: 2
Hello, I am trying to get the zig zag length to show in percent on the speadsheet study. On the chart I can make the zig zag length show as percent no problem, however on the speadsheet study it just shows the length in points and does not change to percent. Is there any way to fix this? Much appreciated.

[2021-07-01 15:10:29] #2 [Go To First Post]
John - SC Support - Posts: 31627
You would just have to make the conversion yourself in the spreadsheet. The Percentage is calculated by taking the length in price divided by the current price. The Length in Price is displayed in the Spreadsheet, so you would end up with a formula like the following: =AD3/$E$3 * 100 For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2021-07-02 12:08:46] #3 [Go To First Post]
Craig90 - Posts: 2
Ok no problem, thank you. When I do this however, the generated answer on my speadsheet does not match the percent shown on the zig zag study chart. Is there any reason why the simple formula does not align with the displayed values on the zig zag line chart? Date Time Of Last Edit: 2021-07-02 13:13:54

[2021-07-02 15:28:29] #4 [Go To First Post]
John - SC Support - Posts: 31627
It should just be a matter of the number of decimal places and rounding. Are you seeing something different from that? For the most reliable, advanced, and zero cost futures order routing, use 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: