Support Board
Date/Time: Tue, 26 Nov 2024 06:25:14 +0000
Post From: Spreadsheet cells not updating reliably for VbP study POC
| [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. |