Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Fri, 04 Jul 2025 19:19:40 +0000

How to Post a Message for Support

Post From: Disable Trading Time Formula

[2020-07-16 01:46:53]
[Go To First Post]
Sawtooth - Posts: 4232
Try this:

J28:
=AND(J8 = 0, OR(OR(FRACTIME(J41) < TIMEVALUE("00:00:00"), FRACTIME(J41) > TIMEVALUE("15:00:00")), AND(FRACTIME(J41) > TIMEVALUE("07:00:00"), FRACTIME(J41) < TIMEVALUE("09:00:00"))))

This is a modification of this example:
https://www.sierrachart.com/index.php?page=doc/SpreadsheetExampleFormulasAndUsage.php#DisableTradingOutsideOfRegularTradingHoursAnd2HoursMidday

H28:
=OR(AND(FRACTIME(J41) > TIMEVALUE("00:00:00"), FRACTIME(J41) < TIMEVALUE("07:00:00"),J52=0), AND(FRACTIME(J41) > TIMEVALUE("09:00:00"), FRACTIME(J41) < TIMEVALUE("15:00:00"),J52=1))

Reference $H$28 = 1 in your K3/M3 formulas.

Note: I didn't test this.