Login Page - Create Account

Support Board


Date/Time: Fri, 29 Mar 2024 04:49:01 +0000



Post From: ALERT Not Working

[2020-07-01 00:31:25]
Sawtooth - Posts: 3952
I'm sorry, again. If this is for a spreadsheet study spreadsheet, use 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,B3>E3,FRACTIME($J$41)-(HOUR(FRACTIME($J$41))/24)>=55/1440,FRACTIME($J$41)-(HOUR(FRACTIME($J$41))/24)<60/1440),0)

The current bar's Open is cell B3, the current bar's Last/Close is cell E3.
Note: I did not test this.