Support Board
Date/Time: Mon, 13 Jan 2025 09:07:59 +0000
Post From: "mostrecentnonzerovalue" formula
| [2017-04-10 22:57:38] |
| User175327 - Posts: 36 |
|
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 |