Login Page - Create Account

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.