Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sun, 28 Apr 2024 17:22:49 +0000
Post From: Spreadsheet trading non trade time
| [2013-09-08 13:49:39] |
| Sawtooth - Posts: 3980 |
|
If you are using the Spreadsheet System for Trading study, use cell J28 and the TIMEVALUE function: =OR(J41-INT(J41)<TIMEVALUE("09:30:00"),J41-INT(J41)>TIMEVALUE("16:00:00")) To also avoid a lunchtime trade: =OR(OR(J41-INT(J41)<TIMEVALUE("09:30:00"),J41-INT(J41)>TIMEVALUE("16:00:00")),AND(J41-INT(J41)>TIMEVALUE("11:30:00"),J41-INT(J41)<TIMEVALUE("13:30:00"))) Edit the times between the quotes as needed. |