Login Page - Create Account

Support Board


Date/Time: Sat, 08 Feb 2025 08:35:04 +0000



Post From: ALERT Not Working

[2020-07-01 00:31:25]
Sawtooth - Posts: 4173
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.