Support Board
Date/Time: Sun, 12 Jan 2025 18:38:28 +0000
New SpreadSheets Subgraph Referencing user defined values on other sheet.
View Count: 885
| [2017-02-26 07:16:47] |
| enemyspy - Posts: 306 |
|
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
|
 Spread Sheet Views.PNG / V - Attached On 2017-02-26 07:15:25 UTC - Size: 88.55 KB - 276 views |
| [2017-02-26 08:56:25] |
| |
|
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: 306 |
|
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] |
| |
|
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] |
| |
|
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: