Support Board
Date/Time: Mon, 08 Dec 2025 07:05:47 +0000
[User Discussion] - Spreadsheet Automated Trading Time Parameters
View Count: 1694
| [2014-07-14 15:26:05] |
| User60737 - Posts: 6 |
|
In regards to spreadsheet automated trading, how do I set the time parameters I would like my system to trade on? For example, I would like it to only trade Monday - Friday 1 AM through 3:30 pm central time. Thanks for any assistance.
|
| [2014-07-14 15:30:16] |
| moonmist - Posts: 127 |
|
Hi, The following thread may be useful: Backtest within a peirod of time for each trading day via spreadsheet |
| [2014-07-14 15:41:43] |
| |
|
This can be done through the J28 spreadsheet cell: 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 |
| [2014-07-14 18:14:07] |
| User60737 - Posts: 6 |
|
Thanks that was helpful!
|
| [2014-07-14 22:20:36] |
| User021827 - Posts: 174 |
|
what does the minus sign do in this formula ? =(J41-INT(J41)) > TIMEVALUE("16:15:00") thanks shane |
| [2014-07-14 23:14:02] |
| Sawtooth - Posts: 4296 |
|
In your example, the Date is being subtracted from the DateTime, leaving only the Time. See this for more info on Excel time formats: http://www.sawtoothtrade.com/tip-4.html Date Time Of Last Edit: 2015-08-14 02:05:17
|
| [2014-07-14 23:57:54] |
| User021827 - Posts: 174 |
|
thanks Tom shane |
| [2014-07-15 00:01:08] |
| User021827 - Posts: 174 |
|
Tom Your website is very well put together both visually and the content. Nice work. Would converting a Multicharts automated signal to Sierra Charts be a big job? I like the Multicharts volatility expansion signal but I cant figure it out . thanks for the help shane |
| [2014-07-15 00:26:55] |
| vegasfoster - Posts: 444 |
|
Can you post the code?
|
| [2014-07-15 01:04:28] |
| User021827 - Posts: 174 |
|
thanks
Date Time Of Last Edit: 2014-07-15 20:31:45
|
| [2014-07-15 16:29:04] |
| vegasfoster - Posts: 444 |
|
Sorry, that's beyond me.
|
| [2014-07-15 18:06:07] |
| User021827 - Posts: 174 |
|
yes me too ! shane |
To post a message in this thread, you need to log in with your Sierra Chart account: