Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Fri, 27 Sep 2024 03:55:13 +0000
Post From: Disable Trading Hours with Spreadsheet
| [2024-09-03 14:44:16] |
| alexo2022 - Posts: 46 |
|
I want to create a formula the limit the trading hours, for example trading only between 00:00-02:00 04:15-08:00 10:15-15:00 all other hours, disable the trade. this is the formula I use, and it's not working. =AND(J8 = 0, OR(OR(FRACTIME(J41) < TIMEVALUE("00:00:00"), FRACTIME(J41) > TIMEVALUE("23:59:00")), AND(FRACTIME(J41) > TIMEVALUE("04:15:00"), FRACTIME(J41) < TIMEVALUE("08:00")), AND(FRACTIME(J41) > TIMEVALUE("10:15:00"), FRACTIME(J41) < TIMEVALUE("15:00")) ))) Date Time Of Last Edit: 2024-09-03 14:45:44
|