Support Board

Date/Time: Mon, 29 Apr 2024 13:37:34 +0000

Post From: New SpreadSheets Subgraph Referencing user defined values on other sheet.

[2017-02-26 18:49:09] Link To Thread - Link To Post [Go To First Post]
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