Login Page - Create Account

Support Board


Date/Time: Sat, 30 May 2020 03:10:29 +0000



[User Discussion] - hourly opening range

[2015-09-10 08:59:32]
User63439 - Posts: 83 | Ending Date: 2017-06-18 [Expired]
hi there,

i wanted to ask if its possible for you to create an hourly opening range indicator?

please see attached picture how it should look like.

thanks in advance
imagehourly_or.png / V - Attached On 2015-09-10 08:59:08 UTC - Size: 25.3 KB - 630 views
[2015-09-10 09:26:34]
Sierra Chart Engineering - Posts: 85680 | Ending Date: 2020-06-09
This can be done with the High/low For Time Period-Extended study:
http://www.sierrachart.com/index.php?page=doc/doc_TechnicalStudiesReference.html#s246
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2015-09-10 09:36:37]
User63439 - Posts: 83 | Ending Date: 2017-06-18 [Expired]
but then the opening range will extend to the end of the day, not only till the end of the hour like in the picture
[2015-09-10 09:56:47]
Sierra Chart Engineering - Posts: 85680 | Ending Date: 2020-06-09
That picture does not show the shaded area extending until the end of the hour which they are based on.

However, there are many questions about that picture which are not totally certain.

Anyway, just use High/ Low for Time Period instead.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2015-09-10 10:04:10]
User63439 - Posts: 83 | Ending Date: 2017-06-18 [Expired]
i think your not getting the point.

if you have questions about the chart feel free to ask.

i want the range of the first 5 minutes of an hour extended till the end of that same hour.
[2015-09-10 10:16:20]
Sierra Chart Engineering - Posts: 85680 | Ending Date: 2020-06-09
No, we did not understand.

There is no built-in study to do exactly what you want.

You will have to program it.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2015-09-23 11:47:50]
User63439 - Posts: 83 | Ending Date: 2017-06-18 [Expired]
"You will have to program it."

if i could, why would i have asked you.

unfriendliest support ever
[2015-09-23 13:19:28]
tomgilb - Posts: 2512 | Ending Date: 2020-12-03
You could do this easily with the Spreadsheet Study study:

1) Add the High/low For Time Period-Extended study
-Move this study to the top of the Studies to Graph list
-Set the Start Time and End Time to your Opening Range requirements, e.g. 09:30:00 / 09:34:59
-Check 'Hide Study'
2) Add the Spreadsheet Study study
a) Settings and Inputs tab:
-Set the Chart Region to 1
-Check 'Draw Study Underneath Main Price Graph'
-Give it a name in the Spreadsheet Name field
b) Subgraphs tab:
-Set the Draw Style of SG2 to Fill Top and choose color
-Set the Draw Style of SG3 to Fill Bottom
-Set the Draw Style of all other subgraphs to Ignore
c) On the spreadsheet:
cell K1:
=M1*60/J36
cell L1:
OR display minutes ->
cell M1:
this is the duration of the displayed band, in minutes (60, per your example).
cell K3:
=IF(AND(AA4=0,AA3>0),1,K4+1)
cell L3:
=IF(AND(K3>=1,K3<=$K$1),AA3,0)
cell M3:
=IF(AND(K3>=1,K3<=$K$1),AB3,0)
[2015-09-23 18:01:23]
Sierra Chart Engineering - Posts: 85680 | Ending Date: 2020-06-09
"You will have to program it."

if i could, why would i have asked you.

unfriendliest support ever

We generally do not provide programming help, unless it is a simple straightforward question and we do not do custom programming for users. So your question is outside the scope of support to begin with.

Please understand that. Our support policy can be found here:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

It is not a matter of unfriendly support. Not at all. It is a matter of commonsense policies that you should clearly understand.


We also see, this was probably a feature request, but this is not an easily added feature, and most new feature requests at this time we are not taking.

The one piece of information we did not include was a link to the custom study interface:
https://www.sierrachart.com/index.php?page=doc/doc_CreatingDLLs.html
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
Date Time Of Last Edit: 2015-09-23 18:04:53
[2015-09-24 12:37:24]
User63439 - Posts: 83 | Ending Date: 2017-06-18 [Expired]
thank you tomgilb, works like a charme.

as i just did copy and paste, maybe you can point me in the right direction
how to get the hourly opening range for following hours.

hopefully i can then fill the whole day with hourly opening ranges by myself,
as this traded properly is a cash cow.

thanks again for your efforts
[2015-09-24 12:47:46]
User63439 - Posts: 83 | Ending Date: 2017-06-18 [Expired]
We also see, this was probably a feature request, but this is not an easily added feature, and most new feature requests at this time we are not taking.

it was a feature request, thought its easy for you guys. take the existing high low extended indi and cut it at the end of an hour. but as i have absolutely no programming skills, my thinking was maybe just to simple minded.

It is not a matter of unfriendly support. Not at all. It is a matter of commonsense policies that you should clearly understand.

of course i understand that. but maybe its because im a polite person that i wouldnt answer like you did. possibly someone of your SUPPORTERS got out of the bed on the wrong side?

We generally do not provide programming help, unless it is a simple straightforward question and we do not do custom programming for users. So your question is outside the scope of support to begin with.

thank god there are people like tomgilb

have a nice day
Date Time Of Last Edit: 2015-09-24 12:48:18
[2015-09-24 13:46:32]
tomgilb - Posts: 2512 | Ending Date: 2020-12-03
how to get the hourly opening range for following hours.
For this, you'd need to add another instance of the High/low For Time Period-Extended study for each new hour, then use the next three Formula Columns (N3,O3,P3) with modified versions of the same formulas used in K3,L3,M3.

Also, you'll probably need to increase the Number of Formula Columns setting, from the default 16, max of 60, to accommodate all of the hours of the day. Do this before you add any formulas because the study outputs will move to the right. You'll also need to edit K3,L3,M3 to reference the correct columns.
[2015-09-24 14:05:57]
User63439 - Posts: 83 | Ending Date: 2017-06-18 [Expired]
thanks for your fast reply.

For this, you'd need to add another instance of the High/low For Time Period-Extended study for each new hour

no prob

then use the next three Formula Columns (N3,O3,P3)

no prob

with modified versions of the same formulas used in K3,L3,M3

could you give an example how to modify for the following hour. hopefully i can see the connection to
modify the rest by myself, as the formulas itself are like hieroglyphics to me.

Also, you'll probably need to increase the Number of Formula Columns setting, from the default 16, max of 60, to accommodate all of the hours of the day. Do this before you add any formulas because the study outputs will move to the right.

sounds easy

You'll also need to edit K3,L3,M3 to reference the correct columns.

hmmm, maybe a last example?

thanks in advance
[2015-09-24 14:35:43]
tomgilb - Posts: 2512 | Ending Date: 2020-12-03
With the Number of Formula Columns set to 16, Formula Columns are K-Z. With the Number of Formula Columns set to 60, Formula Columns are K-BR. Or anything in between.

With the Number of Formula Columns set to 16, and with the High/low For Time Period-Extended study at the top of the Studies to Graphs list, the High/low For Time Period-Extended study outputs to columns AA and AB. Another instance of the High/low For Time Period-Extended study that is second from the top of the Studies to Graph list will output to columns AD and AE:
cell N3:
=IF(AND(AD4=0,AD3>0),1,N4+1)
cell O3:
=IF(AND(N3>=1,N3<=$K$1),AD3,0)
cell P3:
=IF(AND(N3>=1,N3<=$K$1),AE3,0)

The above applies if the Number of Formula Columns is 16. If you change this setting, the High/low For Time Period-Extended study's output will move to columns to the right. 16 columns would only give you enough Formula Columns for 5 range bands.

As an example, if the Number of Formula Columns is set to the max of 60, the High/low For Time Period-Extended study at the top of the Studies to Graph list will output to columns BS and BT:
cell K3:
=IF(AND(BS4=0,BS3>0),1,K4+1)
cell L3:
=IF(AND(K3>=1,K3<=$K$1),BS3,0)
cell M3:
=IF(AND(K3>=1,K3<=$K$1),BT3,0)

The band display duration for all range bands is still set in M1.
Date Time Of Last Edit: 2015-09-24 15:14:44
[2015-09-26 10:41:36]
User63439 - Posts: 83 | Ending Date: 2017-06-18 [Expired]
hey tomgilb,

i really appreciate your efforts, and with your help, i could fill the rest of the day with the opening ranges.

great support

wishing you all the best
Date Time Of Last Edit: 2015-09-26 10:43:28
[2015-10-11 05:13:24]
Sierra Chart Engineering - Posts: 85680 | Ending Date: 2020-06-09
The comments at post #11 have been noted. Thank you.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2017-09-29 11:57:05]
User541842 - Posts: 27 | Ending Date: 2020-05-31
wanted to do this for a 5 minute or for each 30 minutes.
does this formula changes

cell K1:
=M1*60/J36

so far nothing on the chart.

thanks for help
[2017-09-30 01:39:40]
tomgilb - Posts: 2512 | Ending Date: 2020-12-03
These are the requirements and limitations of the setup:
-The formula in K1 would not change. M1 is the only value to edit.
-The Bar Period must be time-based, and be less than the value in M1.
-The value in M1 must be greater than the Bar Period, and be a multiple of the Bar Period.
-The High/Low For Time Period-Extended study's Start Time must equal the timestamp of a Bar Period's bar.
-The High/Low For Time Period-Extended study's Start Time/End Time duration must match the Bar Period.

If you want a 30 min opening range on a 5 min chart, enter 30 in M1.
[2017-09-30 12:37:17]
User541842 - Posts: 27 | Ending Date: 2020-05-31
hi tomgilb,

what i want to achieve is an opening range of 5 minutes for every new 30 minutes.
should look like the attachement.
cant get it working
imageor.png / V - Attached On 2017-09-30 12:37:05 UTC - Size: 20.35 KB - 246 views
[2017-09-30 13:47:51]
tomgilb - Posts: 2512 | Ending Date: 2020-12-03
Follow the instructions in post #8, but enter 30 in M1.
Also, in the spreadsheet study's settings, set the Number of Formula Columns to 60.
Then follow the instructions in post #12, using the examples in post #14, to replicate for other 30min segments of the day.

With the Number of Formula Columns set to the max of 60, there will be a max of twenty 30min segments, and you'll need to use the K3,L3,M3 formulas at the bottom of post #14 instead of those in post #8.
[2017-09-30 15:53:21]
User541842 - Posts: 27 | Ending Date: 2020-05-31
not plotting the range. am i missing something? values are correct though
imageno_plot.png / V - Attached On 2017-09-30 15:52:17 UTC - Size: 147.46 KB - 273 views
[2017-09-30 16:01:26]
tomgilb - Posts: 2512 | Ending Date: 2020-12-03
You're on Sheet4. Go to the Sheet# that matches the chart #
[2017-09-30 16:09:12]
User541842 - Posts: 27 | Ending Date: 2020-05-31
matching the chart number
imagesheet14.png / V - Attached On 2017-09-30 16:09:07 UTC - Size: 100.08 KB - 212 views
[2017-09-30 20:58:01]
tomgilb - Posts: 2512 | Ending Date: 2020-12-03
Also, make sure the Formula Source Sheet Number is the same as the chart #14
[2017-10-01 11:52:21]
User541842 - Posts: 27 | Ending Date: 2020-05-31
thanks for your efforts tomgilb, but its not working.
no plot on the chart
Date Time Of Last Edit: 2017-10-01 11:52:36
[2017-10-01 13:11:51]
User541842 - Posts: 27 | Ending Date: 2020-05-31
got it working.
had to open a new chartbook AND it somehow does not want
to plot the first range of the day. but thats fine,
thanks tomgilb
[2017-10-01 14:56:27]
TechTrader - Posts: 116 | Ending Date: 2019-12-17 [Expired]
Ensure the Spreadsheet Study 'Settings and Inputs' > 'Number of Rows' is set large enough.
[2017-10-02 01:51:47]
tomgilb - Posts: 2512 | Ending Date: 2020-12-03
In hindsight, this can be done without a spreadsheet study, using only multiple instances of the High/Low For Time Period - Extended study.
You would use an instance for each time segment.
-Set the 'Start Time' and 'End Time' to the opening range duration of each segment.
e.g. With 5 min bars: 09:30:00 09:34:59
-Set 'Use Line Stop Time' to Yes.
-Set 'Line Stop Time' to the end time of the segment.
e.g. With 30 min segments: 09:59:59
-Set the Draw Styles of SG1 and SG2 to Fill Top and Fill Bottom, respectively.
-Repeat for subsequent segments, adjusting the times accordingly.

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

Login

Login Page - Create Account