Support Board
Date/Time: Sat, 30 Nov 2024 04:54:42 +0000
Number Bars and volume at threshold study
View Count: 798
| [2022-12-12 04:27:16] |
| usgvince - Posts: 23 |
|
My Number bar is set to volume profile and a text seems to have the correct volume. I set the volume percent and it colors everything fine. What I'm trying to do is set a percent range 0.6 to 0.8 and have a line or rectangle drawn to the right edge. Tried Volume at price threshold V2 and large trade studies and it doesn't do the trick. Any suggestions |
| [2022-12-12 17:37:57] |
| John - SC Support - Posts: 36350 |
|
The only way we can think to do this using the built-in functions is to use the Spreadsheet Formula and create a very long set of nested IF statements. Even then, this would not give you a way to create a line from that point, except for the most recent bar, if that is what you wanted. The best way to do this would be to create a custom study. But, the following will get you started if you want to see how this can be done: - Add the Spreadsheet Formula study to the chart. - Here is the start of the condition you would enter in the Spreadsheet Formula (this covers the first two levels of a bar from the low): =IF(AND(VAP(L, 0) > .6 * V, VAP(L, 0) < .8 * V), L, IF(AND(VAP(L + TICKSIZE, 0) > .6 * V, VAP(L + TICKSIZE, 0) < .8 * V), L + TICKSIZE, 0)) To see a square at the level to the left side of the candle, set the Draw Style for the Result subgraph to be Square Offset Left. You should also change the size to a value of about 10. Also, set the Spreadsheet Formula to not display zeros. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2022-12-19 16:00:58] |
| John - SC Support - Posts: 36350 |
|
We just copied and pasted it and it works correctly. Make sure you are entering this in the "Spreadsheet Formula" study, not on a Spreadsheet itself. The Spreadsheet Formula actually uses the Alert syntax, so this is different from what would be entered in a spreadsheet. 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: