Support Board
Date/Time: Tue, 26 Nov 2024 02:44:29 +0000
Display 1000 as 1 Using Number Bars, Calculated Values, and Volume Multiplier with Stocks
View Count: 1892
| [2021-07-02 01:11:24] |
| frozentundra - Posts: 91 |
|
I'm using Number Bars and Number Bars Calculated Values with stocks. To make the numbers more manageable to consume, I was using Volume/Open Int. Multiplier of `0.001` to represent 1,000 shares as `1`. Then I realized the inaccuracy of this method due to this: https://www.sierrachart.com/index.php?page=doc/ChartSettings.html&CAID=default#Volume_OpenInterestMultiplier ...in the case of Intraday chart data, When using a multiplier that is less than 1 since volume is stored as integers, this reduces the accuracy of volume and causes loss of volume because the portion of the volume shifted to the right of the decimal is completely lost.
This led me to try a Volume/Open Int. Multiplier of `0.01` which is significantly better in accuracy (good enough for what I'm needing). Using this method, the Number Bars and Number Bars Calculated Values will display 1,000 shares as `10`. Still seeking 1,000 shares as `1`, I then modified Volume Value Format to `0.1`. This makes Number Bars display 1,000 shares as `1`, however Number Bars Calculated Values continues to display `10`. The Volume Value Format doesn't appear to affect the Number Bars Calculated Values study. TLDR: I want to display volume of 1,000 shares as just `1` on Number Bars and Number Bars Calculated Values. What is the best way to accomplish that for equities? Thank you in advance. |
| [2021-07-02 14:49:50] |
| John - SC Support - Posts: 36286 |
|
Set the Input on the Numbers Bars Calculated Values for Use Default Number Formatting for All Subgraphs to Yes and then the values will use the Value Format that you have set. Refer to the information for this Input in this section: Numbers Bars: Numbers Bars Calculated Values Input Descriptions For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2021-07-02 14:59:48] |
| frozentundra - Posts: 91 |
|
Thanks John. It doesn't look like Volume - Ask Volume Bid Volume Total or Bar Delta - Ask Volume Vid Volume Difference are in the supported list for that setting: Numbers Bars: Calculated Values Number Format When I set Use Default Number Formatting for All Subgraphs to Yes, it has no effect on the Totals or the Delta per bar. Any other workaround you can think of? Date Time Of Last Edit: 2021-07-02 15:08:57
|
| [2021-07-02 16:47:37] |
| John - SC Support - Posts: 36286 |
|
The response we gave was based on the following: The Volume Value Format doesn't appear to affect the Number Bars Calculated Values study.
In order to get the Value Format to affect all the subgraphs in the Numbers Bars Calculated Values, you need to change that Input and then they will respect the value you enter for the Value Format. But, it sounds like this isn't really what you are looking for. This statement has us confused: Still seeking 1,000 shares as `1`, I then modified Volume Value Format to `0.1`.
This makes Number Bars display 1,000 shares as `1`, however Number Bars Calculated Values continues to display `10`. How does changing the Volume Value Format change the Numbers Bars display from 10 to 1? Can you please give us a screenshot of what you are seeing and/or trying to do? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2021-07-02 18:14:09] |
| frozentundra - Posts: 91 |
|
Can you please give us a screenshot of what you are seeing and/or trying to do?
spce_default.jpg - Here is a current 5min chart of SPCE, displaying Number Bars instead of candles. I've reset all volume settings to default. To use an easy to spot example, you see the 35.4K in red on the bid at the very bottom of the last bar? I would like to format this to display `35` or `35.4`. The 14.9K bid I'd like to display `15` or `14.9`, the 11.6K as `12` or `11.6`, the 2707 as `3` or `2.7`, etc... i.e. I want to display one thousand shares as a `1`. 10K shares would be `10`, and 100K shares to display as `100`, etc. spce_vol_mult_001.jpg - If I set the Volume/Open Int. Multiplier to 0.001, I get the numbers to display in the thousands like I want, but the values are inaccurate due to the rounding issue mentioned in the initial post. This setting is too inaccurate for my needs. Screenshot of this attached as well. In an ideal world, this is how I want the numbers to be displayed, but with more accuracy than this setting can provide. Is there a different way to achieve this display but with more accuracy? spce_vol_mult_01_vol_value_pt1.jpg - This screenshot shows a Vol Multiplier of 0.01 and Vol Value Format of 0.1, which gives the Number Bars values in thousands. 24.2 represents 24,200 shares. That is the display format I want. However, down below on the Number Bars Calculated Values, the display values are in a different format. The Delta 705 represents 70,500 shares. I want it to display as `70.5`. The Total Vol of 8567 represents 856,700 shares. I want it to display as `856.7` or even just `857`. Is there a way to achieve the above? |
 spce_default.jpg / V - Attached On 2021-07-02 17:55:16 UTC - Size: 514.9 KB - 284 views spce_vol_mult_001.jpg / V - Attached On 2021-07-02 18:04:36 UTC - Size: 395.01 KB - 283 views spce_vol_mult_01_vol_value_pt1.jpg / V - Attached On 2021-07-02 18:11:27 UTC - Size: 461.8 KB - 277 views |
| [2021-07-02 19:56:36] |
| John - SC Support - Posts: 36286 |
|
What you are trying to do is really not directly supported. The Volume Value Format is really intended for use only with symbols that supply volume data in fractional values (Cryptocurrencies in particular). We will try to take a look at this in a few weeks and see if we can find a way to do what you really are wanting, which would be to use the Volume/Open Interest Multiplier in combination with the Value Format for the Numbers Bars study. This way, the information will all be consistent. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2021-07-02 20:02:24] |
| frozentundra - Posts: 91 |
|
Thank you John, really appreciate it. I wonder if there is a way to retain the digits lost in the rounding when using Volume/Open Int Multiplier and somehow still display them, up to a certain point? Or improve the accuracy? Then I wouldn't need to use the Value Format setting at all. That would be the most ideal solution, for `0.001` on the multiplier to display a more accurate version of "thousands of shares". I'd bet I'm not the only equities trader interested in something like this? Appreciate all the help, have a great weekend. |
| [2021-07-12 16:32:52] |
| frozentundra - Posts: 91 |
|
After further consideration, I just wanted to confirm my ideal situation would be to use these settings: Volume/Open Int Multiplier - 0.001 Volume Value Format - 1 but with more accurate values. spce fp vol mult and value format.jpg - my current workaround using more accurate 0.01 vol/open int multiplier and 0.1 vol value format. spce fp vol mult preferred w inaccurate values.jpg - my preferred settings, but these yield inaccurate values that are too far off to be useful spce fp side by side.jpg - side by side comparison of same bar on both settings to more easily see the inaccuracy of the preferred settings. I realize this is a long shot but I figured I'd put out my ideal world situation for you guys in case there's a chance to work towards it. Thank you. |
| spce fp vol mult and value format.jpg / V - Attached On 2021-07-12 16:28:00 UTC - Size: 108.38 KB - 239 views spce fp vol mult preferred w inaccurate values.jpg / V - Attached On 2021-07-12 16:28:19 UTC - Size: 90.07 KB - 252 views spce fp side by side.jpg / V - Attached On 2021-07-12 16:30:32 UTC - Size: 173.38 KB - 267 views |
| [2021-07-12 18:02:09] |
| John - SC Support - Posts: 36286 |
|
We need some time to look into the Volume/Open Interest Multiplier and how it works with the Numbers Bars data. We can then determine how to come up with a solution. But, we are very busy with other things and can not get to this right away. We will look into it hopefully in a few weeks when we have the time.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2022-02-06 23:10:29] |
| frozentundra - Posts: 91 |
|
Testing the new NQTV feed this past week (thank you for that feature!) and this Volume Multiple rounding issue continues to be significant. I'm wondering if any headway was made on this since we last spoke in July of 2021? In these screenshots I'm testing a volume multiple of 1 versus a Vol Mult of 0.001. You can see the effect this has on the Number Bars. Hoping there is a way forward with this to reduce the loss of precision, as this is a pretty big pain point. |
| sc vol mult nqtv 01.jpg / V - Attached On 2022-02-06 23:08:06 UTC - Size: 140.88 KB - 233 views sc vol mult nqtv 02.jpg / V - Attached On 2022-02-06 23:08:11 UTC - Size: 107.5 KB - 235 views |
| [2022-02-07 18:12:07] |
| John - SC Support - Posts: 36286 |
|
We have not had a chance to spend any time on this.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2022-04-07 22:56:17] |
| John - SC Support - Posts: 36286 |
|
We finally had a chance to get to this and have added a new Input to the Numbers Bars and Numbers Bars Calculated Values studies for Volume Display Multiplier. With this Input, you will not use the Volume/Open Interest Multiplier or the Volume Value Format. Just use the new Input to adjust the number of digits that are displayed for the Volume data for the studies. The documentation for this Input is here: Numbers Bars: Volume Display Multiplier This change will be in the next Pre-Release - v 2380. When available, you can update using these instructions: Software Download: Fast Update For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2022-04-10 16:10:52] |
| frozentundra - Posts: 91 |
|
Thanks John and SC team -- this is great. Would I be able to manipulate the value of this input via ACSIL like any other Study's inputs? Is the input's datatype a float or a string? I'd like to set it via the SetChartStudyInput* functions. Thank you in advance. |
| [2022-04-11 15:43:15] |
| John - SC Support - Posts: 36286 |
|
Yes, you can access it like any other input. It is an Index where the entry of "1" is the 0th index. Internally the math is then performed by taking the volume divided by 10 to the power of the index (Volume / 10^IndexValue).
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-01-09 17:59:39] |
| User724532 - Posts: 8 |
|
Hi, would you consider to add post #12's "Volume Display Multiplier" input also to Volume By Price study? Thank you!
|
To post a message in this thread, you need to log in with your Sierra Chart account: