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