Login Page - Create Account

Support Board


Date/Time: Thu, 28 Mar 2024 18:06:54 +0000



Spreadsheet Time Values

View Count: 992

[2014-01-30 08:34:52]
VF56082 - Posts: 1
Hello,
I'd like to auto trade between hours.
How do I refer only to an hour without the date?
For example, let's say I only want to trade until from 09:00 to 19:00.
Thanks ahead,
Roey.
[2014-01-30 10:46:33]
sbsierra - Posts: 71
hi,
you can use Cell J28 to disable autotrading

=OR(J41-INT(J41)<TIMEVALUE("09:25:00");J41-INT(J41)>TIMEVALUE("17:45:00");AND(J41-INT(J41)>TIMEVALUE("11:45:00");J41-INT(J41)<TIMEVALUE("14:00:00")))

This will enable from 9:25 till 17:45, but disable from 11:45 till 14:00

regards,

SB

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

Login

Login Page - Create Account