Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Fri, 03 May 2024 16:16:26 +0000
[User Discussion] - Need help for an Alert formula
View Count: 781
| [2018-03-02 18:51:02] |
| nicktrader - Posts: 665 |
|
For an Alert formula I use =AND(BARTIME>= TIME(9, 30, 0), BARTIME <= TIME(9, 30, 59)) I would like to extend the formula and "reduce" the Alert only for one day in a week (i.e. monday or friday...) Is that possible and if yes how? Many thanks |
| [2018-03-02 19:05:24] |
| Sawtooth - Posts: 3992 |
|
Try this: =AND(BARTIME>= TIME(9, 30, 0), BARTIME <= TIME(9, 30, 59),WEEKDAY(BARDATE)=2) https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#WEEKDAY_Function |
| [2018-03-03 04:24:17] |
| nicktrader - Posts: 665 |
|
@tomgilb Many thanks you for your prompt help |
To post a message in this thread, you need to log in with your Sierra Chart account: