Support Board
Date/Time: Sun, 21 Dec 2025 03:19:20 +0000
Post From: ALERT FORMULA QUESTION
| [2020-01-09 19:10:37] |
| Aaz86 - Posts: 6 |
|
I HAVE AN ALERT FORMULA WHICH I'VE CREATED FOR THE SPREADSHEET ALERTS STUDY AND IT LOOKS LIKE THIS - AND (CG[-1]<>0, CI[-1]<>0, BX[-1]<0, CB[-1]>0, AB[-1]<>0) I'VE NEVER DONE THIS BEFORE BUT AM I RIGHT IN THINKING THAT IF ALL THE FIVE CONDITIONS IN THE FORMULA TURN TRUE ON THE PREVIOUS BAR THAT THIS WILL ALERT ME?? MY NEXT QUESTION IS - IS THERE A WAY TO HAVE THE 5 SEPERATE CONDITIONS IN THE FORMULA ANALYSED SO THAT IF THEY TURN TRUE WITHIN A NUMBER OF BARS (SAY WITHIN THE LAST 3BARS) INSTEAD OF ON JUST 1 SPECIFIC BAR I WILL GET AN ALERT? THANKS IN ADVANCE FOR ANY HELP |