Support Board
Date/Time: Sun, 22 Dec 2024 09:06:53 +0000
Disable auto Trading
View Count: 1155
| [2015-07-31 16:05:37] |
| User14682 - Posts: 83 |
|
How do I write a formula to disable auto trading via the spreadsheet? I would like to disable trading between 14:50 - 1:00 Thanks |
| [2015-07-31 16:37:38] |
| Sawtooth - Posts: 4141 |
|
Try this in cell J28: =OR(J41-INT(J41)<TIMEVALUE("01:00:00"),J41-INT(J41)>TIMEVALUE("14:50:00")) Date Time Of Last Edit: 2015-07-31 17:26:18
|
| [2015-07-31 16:41:53] |
| User14682 - Posts: 83 |
|
When I run the backtest it is still trading during the disabled times??
|
| [2015-07-31 16:52:15] |
| User14682 - Posts: 83 |
|
THIS WORKS =AND(J41-INT(J41)<TIMEVALUE("23:00:00"),J41-INT(J41)>TIMEVALUE("14:50:00")) |
| [2015-07-31 17:28:19] |
| Sawtooth - Posts: 4141 |
|
Oops. See edited post.
|
| [2015-07-31 18:41:58] |
| |
|
Here is the relevant documentation: https://www.sierrachart.com/index.php?page=doc/doc_SystemsAlerts.php#DisableAutoTrading Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: