Support Board
Date/Time: Sat, 01 Nov 2025 01:19:00 +0000
[User Discussion] - Need help for an Alert formula
View Count: 961
| [2018-03-02 18:51:02] |
| nicktrader - Posts: 780 |
|
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: 4281 |
|
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: 780 |
|
@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: