Login Page - Create Account

Support Board


Date/Time: Fri, 03 May 2024 14:07:46 +0000



Post From: Disable Auto Trading

[2016-05-05 15:18:35]
JamesP - Posts: 89
Hello,
I'm trying to use two separate formulas in cell J28(disable auto trading). Both of the formulas work fine on their own, I'm just not sure how to use both.
The first formula below disables trading around cash close(ES) until 12am.
=OR(J41-INT(J41)<TIMEVALUE("00:00:00"),J41-INT(J41) >TIMEVALUE("15:50:00"))

I need the second formula below to disable auto trading around news events
=AND(J41-INT(J41)<TIMEVALUE("14:00:00"),J41-INT(J41)>TIMEVALUE("13:40:00"))

I've tested them on their own and they work fine. How would I use both in cell J28 when they are performing separate tasks and not conditional on one another.
Thanks in advance.