Support Board
Date/Time: Sun, 26 Jan 2025 10:40:18 +0000
Post From: alert condition kijun sen
| [2018-02-06 15:23:21] |
| Sawtooth - Posts: 4162 |
|
Add the Spreadsheet System/Alert study to your chart -Give it a name in the Spreadsheet Name field -Assign alerts to Column K and Column M -You may want to set 'Signal Only On Bar Close (Columns K,M)' to Yes. -On the Subgraphs tab, set the Draw Style of SG1 to your requirements -Press OK and OK -On the spreadsheet: Put this in cell Z3: =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))
Put this in cell K3:=AND(Z4=-1,Z3=1)
Put this in cell M3:=AND(Z4=1,Z3=-1)
The formula in Z3 assumes your Kijun-Sen study is ID1. If it is a different ID#, edit all 12 of the ID1s to the correct ID#.
|