Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Fri, 26 Apr 2024 02:54:24 +0000

How to Post a Message for Support

Post From: ALERT Not Working

[2020-06-29 17:58:29]
[Go To First Post]
Sawtooth - Posts: 3976
Just to be clear, I'm only a user; I'm not SC support.
Also, it would be helpful if you post followup question in the same thread.

To replicate the formula, but with different conditions, try this:
=IF(ROW()=3,AND(ID15.SG1@4>ID15.SG1@3,ID15.SG2@4>ID15.SG2@3,ID13.SG1@4>ID13.SG1@3,ID14.SG1@4>ID14.SG1@3,O<C,FRACTIME($J$41)-(HOUR(FRACTIME($J$41))/24)>=55/1440,FRACTIME($J$41)-(HOUR(FRACTIME($J$41))/24)<60/1440),0)

This is the portion that finds the 5 minutes before the bar close:
FRACTIME($J$41)-(HOUR(FRACTIME($J$41))/24)>=55/1440,FRACTIME($J$41)-(HOUR(FRACTIME($J$41))/24)<60/1440
This limits the alert to only the current bar:
=IF(ROW()=3,AllConditions,0)
Date Time Of Last Edit: 2020-06-29 20:45:55