Support Board

Date/Time: Tue, 04 Nov 2025 20:43:14 +0000

Post From: Flatten Time on Spreadsheet Trading Study

[2017-03-09 23:25:56] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4285
You can do what you want using cells J28 and J29: J28: =AND(J8=0,OR(J41-INT(J41)<TIMEVALUE("08:00:00"),J41-INT(J41)>TIMEVALUE("10:59:59"))) J29: =J41-INT(J41)>TIMEVALUE("14:00:00") The reference to J8 in J28 allows an exit, but no entries, after 10:59:59. So if you are still in a position at 14:00:00, J29 will flatten.