Support Board
Date/Time: Thu, 27 Feb 2025 09:00:17 +0000
Zig Zag Line Length in Percent in Spreadsheet Not Showing
View Count: 497
| [2021-07-01 09:24:21] |
| 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] |
| John - SC Support - Posts: 38222 |
|
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] |
| 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] |
| John - SC Support - Posts: 38222 |
|
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: