Login Page - Create Account

Support Board


Date/Time: Thu, 28 Mar 2024 12:24:49 +0000



[User Discussion] - Spread Sheet Entry

View Count: 1388

[2013-09-05 13:39:01]
apollofl - Posts: 95
Buy/Sell placed at a Specific Time only...Can someone point me in the right direction Please.


Thanks


[2013-09-05 15:21:26]
Sawtooth - Posts: 3952
Try using the TIMEVALUE function, and cell J41.

Maybe like this:

=AND($J$41-INT($J$41)>TIMEVALUE("09:29:59"),$J$41-INT($J$41)<TIMEVALUE("09:30:02"))
[2013-09-05 20:56:53]
apollofl - Posts: 95
Thanks Tom. still having some issue with it.
[2013-09-05 21:26:14]
Sawtooth - Posts: 3952
What symbol are you trading? It's possible in a slow market that J41 might not update during those 3 seconds.

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account