Support Board
Date/Time: Wed, 27 Nov 2024 08:26:39 +0000
Help with New Spreadsheets for non-CLR (Iteration?)
View Count: 1184
| [2014-08-15 07:49:48] |
| User33803 - Posts: 40 |
|
Hi, I have a problem with the change from Old Spreadsheets to New Spreadsheets. I use a cell that is blocked to 1 when a first trigger cell has the value 1 and it is released to value 0 when a reset cell has the value 1. The Reset cell only sets to 1 if a second trigger is set to 1, the first trigger is set to 0 and the blocking cell value is 1. This works fine with the Old Spreadsheets but it doesn't work with the new Spreadsheets. Below is an example of this case: First Trigger Cell: AD120 Blocking Cell: AD121 Reset Cell: AD122 Second Trigger Cell: AD123 Cell AD120: switches from 0 to 1 and viceversa Formula in Cell AD121: =IF(AND(OR(AD120=1;AD121=1);AD122=0);1;0) Formula in Cell AD122: =IF(AND(AD120=0;AD121=1;AD123=1);1;0) Cell AD123: switches from 0 to 1 and viceversa Date Time Of Last Edit: 2014-08-15 07:51:03
|
| [2014-08-15 17:19:42] |
| |
|
You have a circular references and circular references are not supported in the new spreadsheets because there is not an accurate and efficient way to resolve them: Formula in Cell AD121: =IF(AND(OR(AD120=1;AD121=1);AD122=0);1;0) Formula in Cell AD122: =IF(AND(AD120=0;AD121=1;AD123=1);1;0) Do you have a an alternative to circular references that you can create for what you want to do? We do not understand your formulas well enough to suggest one. 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 Date Time Of Last Edit: 2014-08-15 17:20:06
|
| [2014-08-16 09:28:07] |
| User33803 - Posts: 40 |
|
When designing the spreadsheet, I had a problem that I solved with this circular/crossreference. With the Old Spreadsheets it worked just fine. What I needed was that cell AD122 sets to 1 just to force cell AD121 to return from 1 (blocked) to 0 (unblocked). Then, the cell AD122 should immediately return to 0. In other words, cell AD122 resets the blocked state (value=1) of cell AD121 and its value should be always 0 except for resetting (the value 1 for AD122 is a kind of "glitch"). The blocking of AD121 is governed by AD120 which contains different references to other cells in the spreadsheet. The reset (AD122) is governed by AD123 which contains different references to other cells in the spreadsheet. The release of the blocked state of AD121 can only be produced when AD120 (trigger condition to block AD121) is set to 0, the cell AD121 is blocked and the reset condition is met AD123=1. |
To post a message in this thread, you need to log in with your Sierra Chart account: