Support Board
Date/Time: Sun, 24 Nov 2024 05:06:56 +0000
[User Discussion] - Spreadsheet trading non trade time
View Count: 2080
| [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: 4118 |
|
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: 4118 |
|
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: