Support Board
Date/Time: Sun, 26 Jan 2025 10:47:49 +0000
Post From: alert condition kijun sen
| [2018-02-05 13:54:17] |
| User494206 - Posts: 44 |
|
Dear, My programmer needs some help. Can you help me futher? Since the Kijun-Sen has some segments that are flat, you'll need to use the Spreadsheet System/Alert study so that you can create a persistent variable to 'remember' the direction through those flat segments. Try a formula like this, e.g. in cell Z3, where the Kijun-Sen is ID1: =IF(OR(ID1.SG1@3>ID1.SG1@4,AND(ID1.SG1@5>=ID1.SG1@4,ID1.SG1@3>ID1.SG1@4)),1,IF(OR(ID1.SG1@3<ID1.SG1@4,AND(ID1.SG1@5<=ID1.SG1@4,ID1.SG1@3<ID1.SG1@4)),-1,Z4)) It returns a 1 if the line is sloped up, or if the current segment is flat and the previous segment was up. It returns a -1 if the line is sloped down, or if the current segment is flat and the previous segment was down. You will then need to find the transitions using formulas in columns K and M: K3: =AND(Z4-1,Z3=1) M3: =AND(Z4=1,Z3=-1) Then assign an alert# to column K and column M. The code he gave doesn't work and for me it is to difficult what he means. Can you help me out? |