Login Page - Create Account

Support Board


Date/Time: Fri, 29 Mar 2024 10:52:14 +0000



Spreadsheet study data does not update

View Count: 1073

[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:

Login

Login Page - Create Account