Login Page - Create Account

Support Board


Date/Time: Mon, 21 Apr 2025 13:23:38 +0000



[Programming Help] - Draw Horizontal Line at Bollinger Band High/Low at Specific Time

View Count: 115

[2025-03-14 22:47:40]
User303857 - Posts: 132
Searching for a way to draw horizontal lines for High & Low at specific times for Bollinger Bands.

The price is still far away from the high/low of the bands so there is no crossing of price yet.
Would need to capture the high or low of the bands and draw a horizontal line at those times.

Since the bands are drawing lines already is it possible to identify one of those value points in time and then draw the line
from that point?


Thanks
[2025-03-14 23:55:03]
Sawtooth - Posts: 4209
is it possible to identify one of those value points in time and then draw the line from that point?
You can do it with the Spreadsheet Formula study, with a formula like this in its Formula field:
=IF(BARTIME=TIME(9,30,0),ID4.SG1,ID5.SG1[-1])
where ID4.SG1 is the BB Top Band, and ID5 is this Spreadsheet Formula study.

Also, set the Chart Region to 1.
[2025-03-15 21:25:57]
User303857 - Posts: 132
I used the horizontal line at time , not sure it is as accurate as using a Spreadsheet Formula study.
I will see if I can get that going.
Which do you think is more accurate?

Thanks Sawtooth
Date Time Of Last Edit: 2025-03-15 21:26:59
imageNQH5.CME[M] 5 Min #1 2025-03-15 14_21_20.842.png / V - Attached On 2025-03-15 21:25:42 UTC - Size: 49.9 KB - 21 views
[2025-03-15 22:42:36]
Sawtooth - Posts: 4209
Which do you think is more accurate?
I would expect them to be the same.
[2025-03-16 16:49:23]
User303857 - Posts: 132
Is it possible to draw and extended rectangle from the same points on the bands?
Using the A1 for the high or top of the Extended rectangle & A2 anchor points for the low of the Extended rectangle?
[2025-03-16 19:24:38]
Sawtooth - Posts: 4209
Is it possible to draw and extended rectangle from the same points on the bands?
Using the A1 for the high or top of the Extended rectangle & A2 anchor points for the low of the Extended rectangle?
You can fill the area between the lines using the Study Subgraphs Reference study.

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

Login

Login Page - Create Account