Login Page - Create Account

Support Board


Date/Time: Fri, 29 Mar 2024 05:47:14 +0000



New SpreadSheets Subgraph Referencing user defined values on other sheet.

View Count: 779

[2017-02-26 07:16:47]
enemyspy - Posts: 304
Hi,

There seems to be a Problem with the spreadsheet subgraphs updating values sourced from cells on a seperate sheet that are manually inputted/ changed via typing Value into the referenced cell:

Using 2 spreadsheets - Sheet1 with subgraph outputs, the other is a blank sheet were user defined values are entered. It is Meant To be a Parameter array for an ACSIL study like sc.Input.

The subgraph sheet has an addressing formula To Order The user defined values on the blank sheet correctly:

=Indirect(Address(P3+8*R3+R3,Q3,1,1,"SigExitParams")) - In the photo(if it is needed) I included an additional column with indirect() removed so you can see that the cell references are correct and ordered Properly.


When I Change A user Defined Value on the blank Sheet "SigExitParams", and Recalculate the Chart - It is not always updating the Spread Sheet Subgraph with the new values.
Date Time Of Last Edit: 2017-02-26 07:41:35
imageSpread Sheet Views.PNG / V - Attached On 2017-02-26 07:15:25 UTC - Size: 88.55 KB - 245 views
[2017-02-26 08:56:25]
Sierra Chart Engineering - Posts: 104368
There is no way we can clearly understand this unless you provide us a step-by-step procedure to duplicate the issue. All of this comes across as very vague and confusing.

You can also give us a simple Spreadsheet to work with. If it is associated with the Spreadsheet Study, then also provide us the Chartbook. This Chartbook must contain only a single chart.

If you provide a spreadsheet file, we also need step-by-step instructions to work with and to duplicate the issue.

You need to keep this very simple and orderly.
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
[2017-02-26 18:49:09]
enemyspy - Posts: 304
Ok,
I have included a chart book and spreadsheet file adhering to the outlined specs above.

Description Of Spreadsheet/ChartBook:

-There are a couple custom studies that are on my version. With the custom studies the only factor that may have an impact is sc.EarliestUpdateIndex is set to sc.ArraySize-50 in one of the studies when !sc.IsFullRecalculation.

-There Are 2 sheets int the spreadsheet study "DayStats" to concern yourself with:
1. SigExitParams: sheet that is not for Chart Data input, and is not an output. It simply is a place to enter settings.
2. Sheet1: -Subgraph Columns N-R are the columns to concern yourself with.
-Column O is the only column used for Output and contains ordered Cell Refs to "SigExitParams" sheet.
-the rest are helper columns That are used to Help O get the correct Cell Ref to sheet "SigExitParams".

Steps to Duplicate Problem:
1. Open The Chart Book.
2. Compare the Values in 'Sheet1' O3:O10 to the Values in 'SigExitParams' B3:B10. They will Identical in descending Order.
3. Change one or some of the cell values in 'SigExitParams' B3:B10.
4. Go to the Chart and Hit Recalculate.
5. Repeat step 2 - The Values in both arrays are supposed to remain Identicel but 'Sheet1' O3:O10 is not reflecting the new values.
Private File
Private File
[2017-02-27 03:49:22]
Sierra Chart Engineering - Posts: 104368
We will be looking this over, this week. If we have further questions we will let you know.
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
[2017-03-01 23:22:53]
Sierra Chart Engineering - Posts: 104368
We have reproduced the problem and resolved it. We will have a new release out either today or tomorrow.
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