Support Board

Date/Time: Fri, 03 May 2024 14:41:55 +0000

Post From: ALERT FORMULA QUESTION

[2020-01-09 19:10:37] Link To Thread - Link To Post [Go To First Post]
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