Support Board
Date/Time: Sat, 11 Jan 2025 19:53:19 +0000
[User Discussion] - IB break time
View Count: 1237
| [2017-01-05 13:48:38] |
| User560062 - Posts: 100 |
|
What's the best way to get the time that the IB high or low were broken please?
Date Time Of Last Edit: 2017-01-05 13:49:15
|
| [2017-01-05 18:44:31] |
| |
|
Visually look at the chart and use the Chart Values tool to determine this: http://www.sierrachart.com/index.php?page=doc/Tools.html#ChartValues We assumed by IB that you are referring to the Initial Balance study. There is no further information we can provide, so please do not follow-up if this is not the help you are looking for. 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: 2017-01-05 18:45:41
|
| [2017-01-05 20:41:18] |
| User560062 - Posts: 100 |
|
I was referring to a study that could be exported in a study not visually. That doesn't answer my question.i tried using the color bars above below study but I'd like to have a single signal when it was broken. Any help with this please about the best way to go about this
Date Time Of Last Edit: 2017-01-05 20:43:54
|
| [2017-01-06 03:47:15] |
| Sawtooth - Posts: 4148 |
|
The attached example chartbook shows how to use 2 instances of the Color Bar Based On Alert Condition study to create an alert and mark the bar of the first IB breach. In the formula in the first instance, the earlier time must be the same as the Initial Balance study's End Time, and the later time must be the end of the day. This instance will color all of the bars between the IB breach and the end of the day, except that the study is Hidden. The formula in the second instance looks for the first occurrence of the IB breach in the first instance. |
 IB first breach alert.cht - Attached On 2017-01-06 03:42:56 UTC - Size: 48.33 KB - 461 views  IB first breach alert.PNG / V - Attached On 2017-01-06 03:43:21 UTC - Size: 55.95 KB - 271 views Attachment Deleted. |
| [2017-01-06 06:27:18] |
| User560062 - Posts: 100 |
|
Hi Tom, first of all thanks for getting back. It is very much appreciated. Your replies in the forum are very much informative and provide ideas that are not obvious in Sierra. I have 3 questions if you don't mind me asking. 1) AND(BARTIME<=TIMEVALUE("16:00:00"),ID2.SG1[-1]=1) - Did you put the last condition because you want to color all bars up to end time if the previous bar broke the IB? 2) AND(ID2.SG1[-1]=0,ID2.SG1=1) - Is the logic behind this so that you break the pattern, ie you need a previous bar to not be coloured? I'm quite a bit confused. 3) Just to put the above question in context of what I'm trying to. I want to export this data on a tick chart to analyse if price is extending above the high of a timeframe so I created an overlay OHLC study of another timeframe e.g 30 min on a tick chart (see image 1). The problem is that when I check the timestamps of OHLC on tick data (see 2nd file) they are not lining up exactly to the 30 Min TF (the 30 Min timeframe Open and 68.25 yet but the Open of tick is 68.00? Why is this so? The open on tick is 16:28:39. The reason why I am saying this is that your example would not work if the time is fixed? Is this the right way to tackle this problem? What is the best way to see the exact tick timestamp that broke the IBH? Thank you so much for your time. Date Time Of Last Edit: 2017-01-06 06:34:20
|
| scsupporttick.png / V - Attached On 2017-01-06 06:11:06 UTC - Size: 5.43 KB - 255 views sctick2.png / V - Attached On 2017-01-06 06:27:53 UTC - Size: 9.11 KB - 271 views |
| [2017-01-06 07:44:36] |
| Sawtooth - Posts: 4148 |
|
1) Yes. All bars after the IB breach need to be colored so that the first breach becomes the only 'breach' for the day. 2) Yes. 3) I do not know why there is a misalignment between timeframes. At first I was seeing a misalignment on bars less than 2 min, but it is now working on a 1 sec chart. To find the exact timestamp, to the second, of the first IB breach, try this: -Set the Bar Period of the chart to 0-0-1 -Add the Spreadsheet Study study, and set the Draw Style of SG2 to Background (so you can see it more easily) -Put this in cell K3: =IF(OR(C3>ID1.SG7@3,D3<ID1.SG9@3),1,IF(A3-INT(A3)>=TIMEVALUE("16:00:00"),0,K4)) -Put this in cell L3: =AND(K4=0,K3=1) where the IB study is ID1. It doesn't seem to work on bars whose duration is less than 1 second. |
| [2017-01-07 10:24:41] |
| User560062 - Posts: 100 |
|
Hi Tom thanks for your reply. It is greatly appreciated. I am a bit lost to be honest. When I have done what you said, the previous color bar alerts are no longer working and I am seeing backgrounds in the spreadsheetstudy for each time it breaks the high or low. Am I correct in saying that what you are trying to do here is to have cell L3 display 1 when the candle breaks the IBH or IBL? Would appreciate if you explain why are you doing this for me to learn. What are you doing here ID1.SG7@3 with the @3? I'd like to be able to query the data in the spreadsheet to filter for a flag where I know which side of IB broke first not for everytime it gets broken. -update on my attempt- To identify which candle broke first ie, the high or low, is this the right way to do it? I created 2 additional Color Bar based on alert condition - 1 for high and 1 for low Low formula =AND(ID3.SG1=1, L < ID1.SG9) High formula =AND(ID3.SG1=1, H > ID1.SG7) Is this the right way to do it? Thank you so much. Date Time Of Last Edit: 2017-01-07 11:22:59
|
To post a message in this thread, you need to log in with your Sierra Chart account: