Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sun, 19 May 2024 14:46:49 +0000
Post From: J85 Allow Trading Only During Time Range
| [2020-06-11 14:32:01] |
| Sawtooth - Posts: 4000 |
|
Instead of using J85/J86/J87, you could use this formula in J28: =AND(FRACTIME(J41)>TIMEVALUE("00:00:00"),FRACTIME(J41)<TIMEVALUE("15:50:00")) To allow exits after 15:50:00, but disallow entries, include a reference to J8: =AND(J8=0,FRACTIME(J41)>TIMEVALUE("00:00:00"),FRACTIME(J41)<TIMEVALUE("15:50:00")) Now you can flatten at a later time in J29: =FRACTIME(J41)>=TIMEVALUE("16:00:00") |