Support Board
Date/Time: Fri, 04 Jul 2025 19:34:48 +0000
Post From: Disable Trading Time Formula
[2020-07-26 21:44:40] |
User355030 - Posts: 163 |
Hey Tom this formula does not work, it fires off two trades from 09:00:00 -15:00:00 when there is no trade from 00:00:00 - 07:00:00 Try this in H28: =OR(AND(FRACTIME(J41) > TIMEVALUE("00:00:00"), FRACTIME(J41) < TIMEVALUE("07:00:00"),J52=0), IF(AND(FRACTIME(J41) > TIMEVALUE("09:00:00"), FRACTIME(J41) < TIMEVALUE("15:00:00"),J52=0),AND(FRACTIME(J41) > TIMEVALUE("09:00:00"), FRACTIME(J41) < TIMEVALUE("15:00:00"),J52=0),AND(FRACTIME(J41) > TIMEVALUE("09:00:00"), FRACTIME(J41) < TIMEVALUE("15:00:00"),J52=1))) |