How to color bars by day/time?

August 5th, 2015, 04:02 PM

What would be the best / easiest way to color bars in SC based on day and time?

Here's an example of what I want from NT, with different colors for each globex session.

August 5th, 2015, 04:47 PM

I'm not sure if you can paint bars based on time. The only known option is to use Session Indicator study. It will show you a colored line at the bottom of the main price graph. And you can set only two sessions in Sierra Chart.

August 5th, 2015, 07:08 PM

You can color bars based on time with the Color Bar Based On Alert Condition study. You would need a separate instance of this study for each color, and a Simple Alert formula on the Alerts tab. Here is a link to the documentation:
Study/Chart Alerts And Scanning - Sierra Chart

There is no Identifier in Simple Alerts for day of the week. For this, you'd need to use the Spreadsheet Study study. However, you could alternate two colors based on odd/even of the serialdate.

If you need help with formulas, post here again.

August 6th, 2015, 01:12 PM

Thanks Tom, I had looked at the documentation for the simple alerts and color bar function, but realized it wouldn't do what I wanted - so it looks like the spreadsheet is the way to go.

I'll play with the spreadsheet and see what I come up with - would I need to use a separate sheet for each color?

I appreciate that you don't need to code in SC, but sometimes it seems a lot easier to whip up some code in Ninja to do these things....

August 6th, 2015, 02:33 PM

@futuretrader

Simpler is

From "Settings and Inputs " tab pick start and end time

August 6th, 2015, 03:17 PM

lemons

Simpler is

From "Settings and Inputs " tab pick start and end time

Thanks lemons, but as far as I can see that won't give different colors by day of week.

Might be useful for distinguishing day and overnight sessions in other charts, though.

August 6th, 2015, 06:19 PM

tomgilb

You can color bars based on time with the Color Bar Based On Alert Condition study. You would need a separate instance of this study for each color, and a Simple Alert formula on the Alerts tab. Here is a link to the documentation:
Study/Chart Alerts And Scanning - Sierra Chart

There is no Identifier in Simple Alerts for day of the week. For this, you'd need to use the Spreadsheet Study study. However, you could alternate two colors based on odd/even of the serialdate.

If you need help with formulas, post here again.

Actually, although it does not say so in the documentation, you can use WEEKDAY in an alert formula.

For example, =WEEKDAY(BARDATE)=3

So the full formula would be something like =AND(WEEKDAY(BARDATE)=3,BARTIME >= your start time, BARTIME <= your end time)

August 6th, 2015, 06:31 PM

Thanks swandro,
I saw your post as I was going to upload the same solution
In the documentation it says that any of the spreadsheet functions can be used, so i did it using 3 alerts.
Pretty straightforward once you know....

March 8th, 2017, 12:29 PM

@swandro
@futuretrader

Thank you

I noticed you can also use the following

=WEEKDAY(BARDATE)=MONDAY ........(Tuesday etc)

This perhaps can help with easy identification etc

-William

How to color bars by day/time?

Discussion in Sierra Chart

How to color bars by day/time?