Login Page - Create Account

Support Board


Date/Time: Thu, 28 Mar 2024 22:03:06 +0000



[User Discussion] - Set timing for spreadsheet automated trading system

View Count: 2277

[2013-12-06 10:42:45]
batman_ - Posts: 190
(a) How do i set timing for spreadsheet automated trading system?
For example, i want to start from 0830 to 1600 Chicago time zone, from Monday to Friday.

(b) If i back testing, would it back test according to the time i set at (a)?
[2013-12-06 13:34:50]
Sawtooth - Posts: 3952
You can do this using cell J28:

=AND(J8=0,OR(J41-INT(J41)<TIMEVALUE("08:30:00"),J41-INT(J41)>TIMEVALUE("16:00:00")))

J41 is the chart time, which matches the timezone set in Global Settings >> Data/Trade Service Settings, so it will work both live and in replay.
[2013-12-07 07:47:59]
batman_ - Posts: 190
Hi tomgilb

Thank you for your code. I tried to back testing today and it did started from 0830 chicago time zone according to data trading service setting BUT it didn't stop at 1600.

The back testing processes keep continue until over night time.

Please advice what could went wrong?

TQ
[2013-12-07 11:15:03]
batman_ - Posts: 190
SC,

This is the first time i am back testing using SC Historical Intraday Futures with the latest version.

After the back testing, there were no Trade Activity Log nor Trade Orders and Positions' records.

Please advice accordingly.

TQ.
[2013-12-07 14:54:21]
Sawtooth - Posts: 3952
Thank you for your code. I tried to back testing today and it did started from 0830 chicago time zone according to data trading service setting BUT it didn't stop at 1600.
The back testing processes keep continue until over night time.
Please advice what could went wrong?

The reference to J8=0 allows an exit after 16:00, but not an entry. Are you getting entries after 16:00?

If you want no autotrading activity after 16:00, use this instead:
=OR(J41-INT(J41)<TIMEVALUE("08:30:00"),J41-INT(J41)>TIMEVALUE("16:00:00"))

If you want to flatten before market close, put this in J29:
=J41-INT(J41)>TIMEVALUE("15:59:00")

If you are using reversals, there are other things to consider. Here is a link to more examples:
http://www.sawtoothtrade.com/example-4.html
Date Time Of Last Edit: 2015-08-14 01:48:10

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

Login

Login Page - Create Account