Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Tue, 07 May 2024 01:31:04 +0000
Post From: Using “color background based on alert condition” for the “zig zag” stud
| [2021-05-12 03:21:21] |
| Sawtooth - Posts: 3993 |
|
The HH, LH, LL, HL values only occur at the ZZ leg; they are not persistent until the subsequent leg. Note: Also set 'Display HH,LH,LL,HL Labels (ln:23)' to Yes. To get the alert you want, use the Spreadsheet Formula study to make them persistent. - Add the Spreadsheet Formula study. - Use a formula like this in the Formula field: =IF(ID12.SG2=2,ID12.SG2,IF(ID12.SG2=1,ID12.SG2,ID13.SG1[-1])) where the Spreadsheet Formula study is ID13. Then use an alert formula like this, referencing the Spreadsheet Formula study: =AND(ID13.SG1=1,ID13.SG1[-1]=2) Date Time Of Last Edit: 2021-05-12 12:02:06
|