Support Board
Date/Time: Tue, 26 Nov 2024 04:45:28 +0000
Spreadsheet cells not updating reliably for VbP study POC
View Count: 220
| [2023-12-25 05:00:18] |
| j4ytr4der_ - Posts: 938 |
|
I've run into a confusing issue that I believe I have finally confidently tracked down, relating to the VbP study and spreadsheet systems during a replay. Setting the VbP study to Multiple Profiles Based on Fixed Time, and setting the period length and type to 30 minutes. On a 5 minute chart, the 30m POC is correctly shown on screen, and other studies can reference it, and referencing any of the last 6 bars (when a new 30m period has begun) will return the correct, final POC for that period. But on a spreadsheet referencing that same study, this is not reliably the case. The POC is developing, bar by bar, and each cell of the spreadsheet in the study's column, will reflect the POC as it was at the close of that 5m bar. If the POC moves during the 30m period, then you will see different values in each cell - for some time. At a seemingly random interval (I can't detect any pattern to it anyway), the cells will in fact update to correctly display just the single, final 30m POC value for all of the bars during that period. This means that another cell on the sheet, can't reliably reference the prior period's POC since referencing IDx.SGy@9 (which should return the prior POC value during the entire current period), will not reliably contain the proper value. This does not appear to be a simple precedence issue as I have experimented with every precedence variation I can think of, and nothing ever behaves differently. This also is not helped by enabling Calculate Developing POC in the VbP study. I believe this is clear, but if not feel free to ask for more details or I can provide a chartbook, or even easier would be to provide a video demonstrating the issue. |
| [2023-12-28 22:14:28] |
| Sierra_Chart Engineering - Posts: 17179 |
|
Update to the latest release. We made a change, that may resolve this. Instructions: Software Download: Fast Update If you still have an issue use Volume Value Area Lines study. If you still have an issue, then we do not know what the situation is in your case and cannot help with it. We tested Volume Value Area Lines and this problem does not exist. 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, 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: