Home >> Support Board

Support Board

Date/Time: Mon, 25 Nov 2024 11:33:56 +0000

How to Post a Message for Support

Spreadsheet Time Values

View Count: 1102

[2014-01-30 08:34:52] #1 [Go To First Post]
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] #2 [Go To First Post]
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: