Support Board

Date/Time: Fri, 26 Apr 2024 03:52:51 +0000

Post From: Set timing for spreadsheet automated trading system

[2013-12-07 14:54:21] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3976
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