Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sun, 05 May 2024 04:39:38 +0000

How to Post a Message for Support

Post From: Formula for buying at market close and selling at market open

[2015-11-26 22:05:02]
[Go To First Post]
Sawtooth - Posts: 3993
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.