Support Board
Date/Time: Thu, 13 Nov 2025 07:54:36 +0000
Post From: Question on Zig Zag codes for alert conditions
| [2025-09-25 19:55:07] |
| John - SC Support - Posts: 42965 |
|
You need to use the "Spreadsheet Study" to bring the most recent value of the Zig Zag Text Labels forward in time. To do this enter the following formula into one of the calculation columns row 3: =MOSTRECENTNONZEROVALUE(ID1.SG2@3:ID1.SG2@2000) This will look through the last 2000 bars and copy the value of the Text Label into each cell where it was previously zero. Then you can use this in your formula by checking the current bar to see if it has the text value you want. Refer to the following: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#MOSTRECENTNONZEROVALUE_Function For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |