Support Board
Date/Time: Tue, 03 Dec 2024 17:54:07 +0000
Volume at price using PoC
View Count: 222
| [2024-10-28 22:24:45] |
| User273277 - Posts: 59 |
|
I am trying to see bid volume imbalances on a numbers bars chart, starting on the POC, and +1 level. The study "Volume At Price Threshold Alert V2" with 2 adjacent alerts is working to show volume imbalances on each bar at 2 levels (that fit my volume criteria), but the indicator can start anywhere on a bar. I want to start the indicator at the POC and show +1 adjacent alerts. I tried using the study "Color Bar Based On Alert Condition" to check if sg1 is true on the volume at price threshold alert v2, and tried combining it with the study "Volume Point of Control for Bars" to test for volume imbalance at poc. I also tried using a spreadshet formula, but I'm not sure what to use to get the volume at poc +1 levels. I am missing something here, and it's not working. Ideas? Date Time Of Last Edit: 2024-10-28 22:32:40
|
| [2024-10-29 15:14:28] |
| John - SC Support - Posts: 36426 |
|
You have the right idea. But you would need to test all the groups, since it is possible that you could have more than one group on bar and only one of them meets your criteria. To start, you would need to add the "Volume Point of Control for Bars" study to get the Point of Control location. You can hide this study, as you do not need to have it displayed (unless you want to). Refer to the following: Volume Point of Control for Bars Then your alert condition would look like the following: =OR(AND(ID1.SG50, ID1.SG49 = ID2.SG1), AND(ID1.SG52, ID1.SG51 = ID2.SG1), AND(ID1.SG54, ID1.SG53 = ID2.SG1), AND(ID1.SG56, ID1.SG55 = ID2.SG1), AND(ID1.SG58, ID1.SG57 = ID2.SG1)) Where ID1 is the ID of the "Volume at Price Threshold Alert V2", SG50 is the "Adjacent Alert Highlight Top 1" subgraph, SG49 is the "Adjacent Alert Highlight Bottom 1", SG51 is the "Adjacent Alert Highlight Bottom 2", etc., ID2 is the ID of the "Volume Point of Control for Bars", and SG1 is the "VPOC" subgraph. The reason you have to have both the bottom and the top is that sometimes a value is stored in one but not both and both have to be valid in order for there to be a group. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-10-30 05:39:00] |
| User273277 - Posts: 59 |
|
Thank you. This works to resolve my question _exactly_. Are each of the "Top 1/2/3/etc" levels indicating exactly the single price position, not all the intermediary levels? Not sure how the adjacent alert highlight top/bottom x works. I am trying variations of the alert to be "PoC, and =>(+/- 1)" price levels. ie. at least 3 price levels with poc at the center. The first part is your code with my id's, and that works where the poc and 1 price level above meet the criteria. The second part I added the reverse of your code, making the poc match the other price level. I thought this would add the poc and 1 price level below, and force a 'and' match between them. But this does not work. =AND(OR(AND(ID22.SG50, ID22.SG49 = ID23.SG1), AND(ID22.SG52, ID22.SG51 = ID23.SG1), AND(ID22.SG54, ID22.SG53 = ID23.SG1), AND(ID22.SG56, ID22.SG55 = ID23.SG1), AND(ID22.SG58, ID22.SG57 = ID23.SG1)), OR(AND(ID22.SG50 = ID23.SG1, ID22.SG49), AND(ID22.SG52 = ID23.SG1, ID22.SG51), AND(ID22.SG54 = ID23.SG1, ID22.SG53), AND(ID22.SG56 = ID23.SG1, ID22.SG55), AND(ID22.SG58 = ID23.SG1, ID22.SG57))) Date Time Of Last Edit: 2024-10-30 05:39:33
|
| [2024-10-30 15:31:13] |
| John - SC Support - Posts: 36426 |
|
The Bottom and Top subgraphs define the price levels at which the bottom of the grouping occurs and the top of the group occurs. When both subgraphs have a value, then the box is drawn around those levels. As mentioned previously, the reason you need to test to see if there is a "Top" subgraph set is that the "Bottom" subgraph is set when testing to see if there is a group that meets the criteria, but the "Top" is not set unless it actually occurs. If you want to test for a group of 3 and if the POC falls in the middle, then you would use a formula that looks like the following: =AND(ID22.SG50, ID22.SG49 + TICKSIZE = ID23.SG1) This looks checks to ensure that there is a group by looking at SG50, then looks at 1 tick up from the bottom subgraph to see if that matches the POC value. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-10-31 00:46:46] |
| User273277 - Posts: 59 |
|
This works perfectly. Thank you again. Related question. Is there a way to draw a rectangle around the 3 triggered price levels? Similar visually to how the POC outline box looks across both bid/ask, but drawn around these alerted price levels. |
| [2024-10-31 14:13:14] |
| John - SC Support - Posts: 36426 |
|
Try changing the Bottom and Top Draw Styles to "Box Bottom Center" and "Box Top Center". But there may be other items that you would prefer. Look through the Top/Bottom items to see if there is something that works better for what you want. Refer to the following: Chart Studies: Notes about Top and Bottom Draw Style Pairs For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-11-17 03:22:53] |
| User273277 - Posts: 59 |
|
Thank you. I'm just getting back to drawing the box now. Setting the Bottom/Top Draw Styles to Box Bottom/Top Center draws the correct style box, but this only works on the "Volume At Price Threshold Alert V2" study. And it draws the box around the entire range, not the subset that I am alerting on. I need to draw the box around the subset of price levels identified by the formula in "Color Bar Based On Alert Condition". Maybe something like using input data in another study from the color bar study to draw the rectangle? This isn't a standard 'drawing tool' drawing, so I'm not sure how this can be done. |
| [2024-11-18 15:20:36] |
| John - SC Support - Posts: 36426 |
|
You would need to use the Spreadsheet Study in order to identify the particular data points you want. Once you have the Top and the Bottom defined for a particular bar in two columns of the Spreadsheet, then you can use the Box Bottom/Top Draw Styles for those two columns to display where you want.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: