Support Board
Date/Time: Fri, 28 Feb 2025 17:31:35 +0000
[Programming Help] - Chart doesn't update with new spreadsheet values
View Count: 1026
| [2021-08-14 15:47:28] |
| Botan626 - Posts: 294 |
|
Using SC v2296. Spreadsheet study outputs data from the Pivots Points Daily study on the source chart #2 to sheet #2 of 'Pivots' Spreadsheet. Then another Spreadsheet study on the destination chart #1 uses data from sheet #2 of 'Pivots' Spreadsheet to calculate formulas on sheet #1 of Pivots Spreadsheet. If I change date range on the source chart, pivot lines on the destination chart won't update, until I press Chart -> Recalculate. But the Spreadsheet always produces correct values for pivot lines, columns O-U. If I put a plain number in the K column in sheet #1 and draw the K line on the chart, line on the chart updates every time I update number in the K column. Maybe there is a calculation precedence issue, but even so, why pivot lines on the destination chart don't update every time, when values change in the formula columns? Date Time Of Last Edit: 2021-08-14 15:47:42
|
 02.Cht - Attached On 2021-08-14 15:46:17 UTC - Size: 12.75 KB - 272 views Pivots.scss - Attached On 2021-08-14 15:46:31 UTC - Size: 41.07 KB - 347 views |
| [2021-08-19 12:00:25] |
| Botan626 - Posts: 294 |
|
bump
|
| [2021-08-20 12:15:09] |
| Botan626 - Posts: 294 |
|
bump
|
| [2021-08-20 16:07:08] |
| |
|
This is the result of the calculation order and is explained here: Chart Studies: Study Calculation Precedence And Related Issues Maybe there is a calculation precedence issue, but even so, why pivot lines on the destination chart don't update every time, when values change in the formula columns?
This is too involved for us to look into, and is not within the scope of our support. The link above gives you all the information needed.
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, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2021-08-20 16:07:43
|
| [2021-08-20 17:02:46] |
| Botan626 - Posts: 294 |
|
Your link says: because the study values on a Spreadsheet are the values that existed, if they exist at all, at the moment in time the particular instance of the Spreadsheet Study was calculated
But as I said, the values in the spreadsheet are always correct. So my case is different. |
| [2021-08-20 17:16:33] |
| Botan626 - Posts: 294 |
|
This is too involved for us to look into, and is not within the scope of our support. The link above gives you all the information needed.
It's just 2 indicators overall, all you need to do is load it and change date range on the source chart. And again, why when I change number in the K column, chart line's value auto updates for it, but at the same time, when formulas give new numbers, then not? |
| [2021-09-10 14:17:54] |
| Botan626 - Posts: 294 |
|
bump
|
| [2021-09-20 15:47:00] |
| Botan626 - Posts: 294 |
|
bump
|
To post a message in this thread, you need to log in with your Sierra Chart account: