Support Board
Date/Time: Sun, 24 Nov 2024 22:43:51 +0000
Post From: Set timing for spreadsheet automated trading system
| [2013-12-07 14:54:21] |
| Sawtooth - Posts: 4120 |
|
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
|