Support Board
Date/Time: Wed, 05 Nov 2025 04:51:52 +0000
Post From: Disable Trading Time Formula
| [2020-07-26 21:44:40] |
| User355030 - Posts: 167 |
|
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))) |
