Support Board
Date/Time: Sun, 22 Dec 2024 04:57:27 +0000
Spreadsheet study data does not update
View Count: 1158
[2015-07-17 07:57:04] |
User386687 - Posts: 53 |
I have attached a spreadsheet study to a chart and I receive the study quote to the Sheet1 without any problems (updates ok). But when I try to use the quotes from Sheet1 on another sheets the data does not update. Please see attached picture about the situation. In the given example the Calcs!B2 should contain the Sheet1!E3 value but it does not update it. It is showing the intial value when formula was created. I have checked the Autoupdate in the Spreadhseet menu. So what I am doing wrong ? Date Time Of Last Edit: 2015-07-17 07:59:11
|
Private File |
[2015-07-17 08:07:19] |
Sierra Chart Engineering - Posts: 104368 |
Update Sierra Chart to the latest release and see if this solves the problem. You can update with Help >> Download Current Version.
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 |
[2015-07-17 08:52:41] |
User386687 - Posts: 53 |
Now it does the update BUT now all the formulas which are using this value (except the cell where it is fetched) will give #REF! error (see attached pic).
|
Private File |
[2015-07-17 08:58:28] |
User386687 - Posts: 53 |
I did not change anything but restarted the SC manually and now it works ! No #REF! anymore. Thx. |
[2015-07-17 09:00:53] |
Sierra Chart Engineering - Posts: 104368 |
We are working on solving the #REF! error. We are putting out a new release in about an hour to solve this. 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 |
To post a message in this thread, you need to log in with your Sierra Chart account: