Support Board
Date/Time: Sun, 30 Nov 2025 01:32:22 +0000
[Programming Help] - "mostrecentnonzerovalue" formula
View Count: 1106
| [2017-04-10 22:57:38] |
| User175327 - Posts: 39 |
|
Hi- Attempting to code a spreadsheet system for trading study, having an issue getting signals to fire relative to zig-zag, specifically "buy" when most recent non zero vale is a "3" or HL.....I am attempting to add this to the end of a working formula....can't seem to get it correct. Any help would be great. =and($J$5=0,crossfrombelow(id6.sg1@3:id6.sg1@4,id6.sg3@3:id6.sg3@4),(id16.sg1@3>0),mostrecentnonzerovalue(id27.sg2@3:Id27.sg2@25=3)) Thanks |
| [2017-04-11 01:24:16] |
| |
|
This portion is not correct: mostrecentnonzerovalue(id27.sg2@3:Id27.sg2@25=3) Needs to be: mostrecentnonzerovalue(id27.sg2@3:Id27.sg2@25)=3 We tested this portion and it does work properly. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2017-04-11 03:10:44] |
| User175327 - Posts: 39 |
|
Thx! Works great.
|
To post a message in this thread, you need to log in with your Sierra Chart account: