Support Board

Date/Time: Thu, 26 Dec 2024 02:21:36 +0000

Post From: Formula for buying at market close and selling at market open

[2015-11-26 23:30:34] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4143
In a slow market, there might not be a trade within the 2 second window. Here's another way to do it, if you are using time based bars of an interval that meets 15 min: K3: =AND(A3-INT(A3)>TIMEVALUE("16:14:59"),A3-INT(A3)<TIMEVALUE("16:15:01")) L3: =AND(A3-INT(A3)>TIMEVALUE("09:14:59"),A3-INT(A3)<TIMEVALUE("09:15:01")) These 2 second windows will catch the bar timestamp within the floating point errors.