Support Board

Date/Time: Fri, 07 Feb 2025 21:24:54 +0000

Post From: J85 Allow Trading Only During Time Range

[2020-06-11 14:32:01] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4173
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")