Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sun, 05 May 2024 07:42:51 +0000
Post From: Formula for buying at market close and selling at market open
| [2015-11-26 23:30:34] |
| Sawtooth - Posts: 3993 |
|
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. |