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