Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sun, 28 Apr 2024 04:20:23 +0000
[User Discussion] - hourly opening range
View Count: 5163
| [2015-09-10 08:59:32] |
| User63439 - Posts: 83 |
|
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 |
 hourly_or.png / V - Attached On 2015-09-10 08:59:08 UTC - Size: 25.3 KB - 1013 views |
| [2015-09-10 09:26:34] |
| |
|
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. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2015-09-10 09:36:37] |
| User63439 - Posts: 83 |
|
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] |
| |
|
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. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2015-09-10 10:04:10] |
| User63439 - Posts: 83 |
|
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] |
| |
|
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. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2015-09-23 11:47:50] |
| User63439 - Posts: 83 |
|
"You will have to program it." if i could, why would i have asked you. unfriendliest support ever |
| [2015-09-23 13:19:28] |
| Sawtooth - Posts: 3980 |
|
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] |
| |
|
"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. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2015-09-23 18:04:53
|
| [2015-09-24 12:37:24] |
| User63439 - Posts: 83 |
|
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 |
|
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] |
| Sawtooth - Posts: 3980 |
|
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 |
|
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] |
| Sawtooth - Posts: 3980 |
|
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 |
|
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] |
| |
|
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. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2017-09-29 11:57:05] |
| User541842 - Posts: 34 |
|
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] |
| Sawtooth - Posts: 3980 |
|
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: 34 |
|
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 |
| [2017-09-30 13:47:51] |
| Sawtooth - Posts: 3980 |
|
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: 34 |
|
not plotting the range. am i missing something? values are correct though
|
| no_plot.png / V - Attached On 2017-09-30 15:52:17 UTC - Size: 147.46 KB - 599 views |
| [2017-09-30 16:01:26] |
| Sawtooth - Posts: 3980 |
|
You're on Sheet4. Go to the Sheet# that matches the chart #
|
| [2017-09-30 16:09:12] |
| User541842 - Posts: 34 |
|
matching the chart number
|
| sheet14.png / V - Attached On 2017-09-30 16:09:07 UTC - Size: 100.08 KB - 526 views |
| [2017-09-30 20:58:01] |
| Sawtooth - Posts: 3980 |
|
Also, make sure the Formula Source Sheet Number is the same as the chart #14
|
| [2017-10-01 11:52:21] |
| User541842 - Posts: 34 |
|
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
|
To post a message in this thread, you need to log in with your Sierra Chart account: