Support Board
Date/Time: Fri, 29 Nov 2024 21:49:33 +0000
Post From: Measuring percent move on daily basis?
| [2023-01-13 22:58:32] |
| John - SC Support - Posts: 36350 |
|
To do what you want you need to use the Spreadsheet Study. You can then get rid of the Spreadsheet Formula study and put the formula into one of the calculation columns for the spreadsheet. Note that the formatting is different between the Spreadsheet Formula and the Spreadsheet - the Spreadsheet Formula uses the Alert Syntax, which is different from the Spreadsheet Syntax. The formula you would enter in the Spreadsheet to calculate the values is the following: =(ID1.SG2@3 - ID1.SG3@3) / ID0.SG4@3 Then on the Zig Zag study be sure you select Yes for the Input that states Additional Output for Spreadsheets. Then in the Spreadsheet you will see the Zig Zag information starting around column AA (depending on what other studies you have on your chart). You will then need to create an IF() statement in one of the calculation columns that checks when an inflection occurs and then writes out the value of the formula or a 0 otherwise. Refer to the information for spreadsheet functions at the following link: Spreadsheet Functions Then you would want to use a Draw Style for that column of Value on High or one of the options like it to get the value displayed. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |