Support Board
Date/Time: Wed, 15 Jan 2025 19:47:38 +0000
Spreadsheet recalulate
View Count: 1162
| [2017-09-13 14:27:59] |
| User29926 - Posts: 92 |
|
Is there a way to force a spread sheet recalculation via a cell field change?
|
| [2017-09-13 16:28:59] |
| |
|
No, this is not supported. It is not something that we would add.
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-09-15 03:55:32] |
| User29926 - Posts: 92 |
|
ok. This is my issue. I have a cell that is locked to a value and the unlock/reset works if I just check one cell for a value change. But the locked cell won't reset if there are two or more cells being checked that might change to cause a reset of the locked cell value. The reset doesn't even happen when the position size "$J$8=0" goes back to zero. Without the reset,another trade order is placed as soon as $J$8=0 goes back to zero. I need the $H$62 cell to go back to zero when $J$8=0. My current code below: =AND(OR($H$62 =1, IF(AND($HF$90=0, SUM(ID65.SG1@3:ID65.SG1@4)>0),1,0)), OR($J$8=0, OR( $H$90= 0, OR($E$3 = $H$34, OR($E$3 = $H$88, $E$3 < ID17.SG6@3))) ) ) Date Time Of Last Edit: 2017-09-15 04:43:39
|
To post a message in this thread, you need to log in with your Sierra Chart account: