Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sat, 11 May 2024 15:45:01 +0000

How to Post a Message for Support

Post From: Spreadsheet, formula including all session bars

[2024-02-18 13:09:47]
[Go To First Post]
User440951 - Posts: 40
Hi,

I would like to create a formula in a spreadsheet that gives me an alert when in the session, 10:00:00 p.m. to 9:59:59 p.m. for me, the price has touched two very specific levels. To keep it simple in this request, 1 will be true and 0 false.

I tried this :

=IF(AND(CROSSOVER(ID0.SG4, ID2.SG1), CROSSOVER(ID0.SG4, ID2.SG2)), 1, 0)
Or this
=IF(AND(AND(FRACTIME(J41)>=TIME(22, 00, 00, 750), FRACTIME(J41)<TIME(21, 59, 59, 250)), CROSSOVER(ID0.SG4, ID2.SG1), CROSSOVER(ID0.SG4, ID2.SG2)), 1, 0)

But it always returns false to me even though the conditions are met in the sessions.

I can't find the solution, could you help me?