Support Board

Date/Time: Sat, 04 May 2024 00:34:36 +0000

Post From: Spreadsheet System for Trading - Flatten Positions And Cancel Orders At Set Time

[2019-11-22 20:24:30] Link To Thread - Link To Post [Go To First Post]
User695518 - Posts: 50
Hello tomgilb, I hope you are doing well and could help me once again here... I would like to use J29 to flatten/cancel on a particular date. For the following example: =AND((J41-INT(J41)) > TIMEVALUE("10:00:00"),J41-INT(J41)<TIMEVALUE("11:00:00")) How could I add a date check, so that the logic is only true an a particular date? This doesn't seem to be as straightforward as I think it ought to be, or I am over complicating it. Thanks again!