Login Page - Create Account

Support Board


Date/Time: Fri, 19 Apr 2024 13:07:43 +0000



[Programming Help] - Color Bar based on alert condition study

View Count: 1142

[2018-11-05 00:41:07]
User424077 - Posts: 38
I'm trying to color bar based on the day of the week.

This is the formula that I'm using:
=WEEKDAY(5)
The issue is that the alert study paints all bars in chart instead of just Friday.

Please advise
[2018-11-05 14:41:17]
Sawtooth - Posts: 3973
Try this:
=WEEKDAY(BARDATE)=6

Friday is the 6th day of the week.
Here's the documentation:
https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#WEEKDAY_Function
[2018-11-05 17:41:18]
User424077 - Posts: 38
Works thanks!

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

Login

Login Page - Create Account