Support Board
Date/Time: Mon, 03 Feb 2025 17:19:34 +0000
Post From: Spreadsheet System for Trading - Flatten Positions And Cancel Orders At Set Time
| [2019-11-22 20:24:30] |
| User695518 - Posts: 53 |
|
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! |