Login Page - Create Account

Support Board


Date/Time: Fri, 29 Mar 2024 00:26:06 +0000



[User Discussion] - Spreadsheet trading non trade time

View Count: 1930

[2013-09-08 07:37:59]
toews&kane - Posts: 209
Hi,

Is there a way to program a no trade override period for a certain time during the day?

[2013-09-08 13:49:39]
Sawtooth - Posts: 3952
If you are using the Spreadsheet System for Trading study, use cell J28 and the TIMEVALUE function:

=OR(J41-INT(J41)<TIMEVALUE("09:30:00"),J41-INT(J41)>TIMEVALUE("16:00:00"))

To also avoid a lunchtime trade:

=OR(OR(J41-INT(J41)<TIMEVALUE("09:30:00"),J41-INT(J41)>TIMEVALUE("16:00:00")),AND(J41-INT(J41)>TIMEVALUE("11:30:00"),J41-INT(J41)<TIMEVALUE("13:30:00")))

Edit the times between the quotes as needed.



[2013-09-09 00:02:26]
toews&kane - Posts: 209
thank you, can I use the same analogy in J29 for flattening any open postions before close at 15:15?
[2013-09-09 00:16:58]
Sawtooth - Posts: 3952
Yes, like this:
=J41-INT(J41)>TIMEVALUE("14:59:00")

Here are more formula examples that allow exits after the disable:
http://www.sawtoothtrade.com/example-4.html
Date Time Of Last Edit: 2015-08-14 01:44:15

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account