Support Board
Date/Time: Thu, 28 Mar 2024 08:16:33 +0000
[User Discussion] - SC code to define time period during which a spreadsheet alert i
View Count: 1654
[2013-05-16 04:41:57] |
Sawtooth - Posts: 3952 |
Try something like this: =AND(YourAlertConditions,OR(J41-INT(J41)>TIMEVALUE("07:45:00"),J41-INT(J41)<TIMEVALUE("14:00:00"))) |
[2013-05-18 18:08:16] |
Sawtooth - Posts: 3952 |
If you are using this formula in columns K-AX, you need to use the absolute value of J41, like this: =AND(YourAlertConditions,OR($J$41-INT($J$41)>TIMEVALUE("07:45:00"),$J$41-INT($J$41)<TIMEVALUE("14:00:00"))) Using J41 is preferred to A3 because J41 is updated many times intrabar, whereas A3 is only updated at bar open. This is particularly true if your bars are a long duration. Date Time Of Last Edit: 2013-05-18 18:30:24
|
To post a message in this thread, you need to log in with your Sierra Chart account: