Support Board

Date/Time: Sun, 05 May 2024 11:16:28 +0000

Post From: version 1116 non CLR spreadsheet

[2014-05-16 11:05:42] Link To Thread - Link To Post [Go To First Post]
Outlander - Posts: 91
Hi, I still have some problems with the Non-CLR spreadsheet. I have used TechTraders code in the past without any problems. But now I get this error code: #REF! It would be nice if you can fix it. Regards Outlander (ZigZag is in column AA) Column X =IF(AND(AA3<>AA4,AA3>0),SIGN(AA3-AA4),X4) Next, determine the last high point. Column Y =IF(AND(X4>0,X3<0),AA4,Y4) Finally, determine the last low point. Column Z =IF(AND(X4<0,X3>0),AA4,Z4) Columns Y and Z will plot horizontal lines of the last high/low until a new high/low is determined by your zigzag criteria.