Note that the number in the square brackets eg  is a streamlined way of using an offset, so the  is the previous value, and  is the value 2 periods ago.
Using the IF statement, when the last pivot value V1 is the same as yesterday (V1 == V1) then set V2 to zero, but if it has changed use the value of V1.
The NONZERO function gives the last value when V1 wasn’t 0 ie. in our case, when the pivot last changed. In this example the watchlist columns show the values of the last 3 pivot highs, and the two Show Views plots V2 when the new pivot occurs (in red) and value of those pivot changes using the NONZERO function (in green).
This topic was modified 1 year, 1 month ago by Darren.
The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.