Support Board

Date/Time: Tue, 07 May 2024 05:04:42 +0000

Post From: Spreadsheet System: Flatten Positions at Set Time

[2020-06-26 02:42:08] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3993
How do I get this to work as desired? Use J28/J29 instead of J85-J89, with formulas like these: J28: =AND(J8=0,OR(FRACTIME(J41)<TIMEVALUE("10:31:00"),FRACTIME(J41)>TIMEVALUE("15:45:00"))) J29: =FRACTIME(J41)>=TIMEVALUE("15:49:00") Referencing J8=0 in J28 allows exits after the time window, but disallows entries after the time window, so that J29 can flatten after the time window. Date Time Of Last Edit: 2020-06-26 02:43:04