Support Board
Date/Time: Wed, 29 Oct 2025 20:58:41 +0000
Post From: Formula for buying at market close and selling at market open
| [2015-11-26 22:05:02] |
| Sawtooth - Posts: 4281 |
|
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. |