Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sun, 11 May 2025 05:07:29 +0000

How to Post a Message for Support

Post From: Disable Trading Hours with Spreadsheet

[2024-09-03 14:44:16]
[Go To First Post]
alexo2022 - Posts: 49
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