Support Board
Date/Time: Mon, 27 Oct 2025 04:04:00 +0000
Post From: Using “color background based on alert condition” for the “zig zag” stud
| [2021-05-12 03:21:21] |
| Sawtooth - Posts: 4280 |
|
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
|