Login Page - Create Account

Support Board


Date/Time: Wed, 08 May 2024 23:35:21 +0000



Disable auto Trading

View Count: 1060

[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: 3993
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: 3993
Oops. See edited post.
[2015-07-31 18:41:58]
Sierra Chart Engineering - Posts: 104368
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:

Login

Login Page - Create Account