Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 20 Apr 2024 00:20:08 +0000
Disable Auto Trading
View Count: 860
| [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. |
| [2016-05-05 16:55:02] |
| Sawtooth - Posts: 3975 |
|
Combine them with another OR statement: =OR(OR(J41-INT(J41)<TIMEVALUE("00:00:00"),J41-INT(J41)>TIMEVALUE("15:50:00")),AND(J41-INT(J41)<TIMEVALUE("14:00:00"),J41-INT(J41)>TIMEVALUE("13:40:00"))) |
| [2016-05-05 18:46:11] |
| JamesP - Posts: 89 |
|
When I tried this it wouldn't work, you have the magic touch Tom, thanks for all the help.
|
To post a message in this thread, you need to log in with your Sierra Chart account: