Support Board
Date/Time: Fri, 09 May 2025 06:23:34 +0000
Post From: Set timing for spreadsheet automated trading system
| [2013-12-06 13:34:50] |
| Sawtooth - Posts: 4212 |
|
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. |