Support Board
Date/Time: Tue, 04 Feb 2025 00:02:15 +0000
[Programming Help] - Pulling Length of Zig Zag Input Data 27, and Time(input data 31)
View Count: 709
| [2019-12-18 02:18:44] |
| User227811 - Posts: 16 |
|
Hello, I am having trouble understanding how I can pull certain data from the Zig Zag Study into the SpreadSheet Study. I am specifically trying to pull "Display Length of Zig Zag Line(In:27)" and "Display Zig Zag Time Duration(In:31)".(shown in picture "focus" and "focus1") Both Inputs are displayed onto the chart via "Text Labels(SG2)"(Shown in Pictures "focus 3"). When I try to pull the subgraphs onto the spreadsheet, it isnt giving me the values being displayed onto the chart, yet just the amount of labels placed on the chart. Can you please tell me how I can correctly call for these values on the spreadsheet study? |
 Focus1.PNG / V - Attached On 2019-12-18 02:17:46 UTC - Size: 52.32 KB - 254 views Focus3.PNG / V - Attached On 2019-12-18 02:18:07 UTC - Size: 42.08 KB - 262 views |
| [2019-12-18 13:48:03] |
| Sawtooth - Posts: 4166 |
|
Set 'Additional Output for Spreadsheets' to Yes so that the Zigzag Line Length outputs SG4 to the spreadsheet. For the Zigzag Time Duration, you must use formulas in three Formula Columns to calculate it, one to create a persistent time of each leg, one to return the time difference at a new leg, and one to convert to the displayed minutes, e.g.: In P3: =IF(ID1.SG4@3<>0,A3,P4) In Q3: =IF(P3<>P4,P3-P4,Q4) In R3: =IF(ID1.SG4@3<>0,Q3*1440,0) where the ZZ study is ID1. |
To post a message in this thread, you need to log in with your Sierra Chart account: