Support Board
Date/Time: Thu, 26 Dec 2024 02:34:29 +0000
Post From: Formula for buying at market close and selling at market open
[2015-11-26 22:05:02] |
Sawtooth - Posts: 4143 |
Use an absolute reference to cell J41, and include a time range, like this: K3: =AND($J$41>=TIMEVALUE("16:14:58"),$J$41<TIMEVALUE("16:15:00")) This is a 2 second window before market close. L3: =AND($J$41>=TIMEVALUE("09:15:00"),$J$41<TIMEVALUE("09:15:02")) This is a 2 second window after 9:15 AM. |