Support Board
Date/Time: Sun, 22 Dec 2024 17:18:38 +0000
Post From: Exit at certain time
[2015-02-12 22:47:04] |
Sawtooth - Posts: 4141 |
Try this: L3: =AND($J$8>0,$J$41-$J$42>TIMEVALUE("00:59:59"),$J$41-$J$42<TIMEVALUE("01:00:05")) N3: =AND($J$8<0,$J$41-$J$42>TIMEVALUE("00:59:59"),$J$41-$J$42<TIMEVALUE("01:00:05")) Column A is the bar open time. J41 is the chart update time; it is updated much more frequently. J42 is the time of the most recent entry. |