Support Board
Date/Time: Tue, 26 Nov 2024 16:48:21 +0000
Post From: version 1116 non CLR spreadsheet
| [2014-05-16 11:05:42] |
| 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. |