Support Board
Date/Time: Sat, 28 Dec 2024 05:03:36 +0000
New spreadsheets not calculating properly?
View Count: 829
| [2015-12-22 17:48:12] |
| heavyhucks - Posts: 18 |
|
I have the following formula in cell x3: =if(u3<>"","",if(and(v3<>"",v4=""),small(d3:d33,1),if(x4<>"",x4,""))) Sometimes it fails to calculate, both on LIVE and on REPLAY (accurate mode or not). Now granted this is not the best bit of code, but I have never had problems with it in excel. I have tried substituting <>"" with the actual values I am looking for such as u3="short signal", but it still fails to calculate. The strange thing is, that if I click into the cell and then press enter, it will then calculate. However, Spreadsheet auto-calculate is ON! I have also tried altering the "on bar close" options to see if that was causing it to not calculate. Any ideas would be much appreciated. |
| [2015-12-22 18:20:35] |
| |
|
We will test this. Do you ever notice an error value returned from this formula? Errors are documented here: https://www.sierrachart.com/index.php?page=doc/doc_Spreadsheets.html#SpreadsheetErrorCodes 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: 2015-12-22 18:21:42
|
| [2015-12-22 18:37:03] |
| heavyhucks - Posts: 18 |
|
Thank you for getting back. No I have never got an error, just seems unwilling to calculate automatically.
|
| [2015-12-22 18:50:34] |
| |
|
OK we will check on this.
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 |
| [2016-01-11 06:24:29] |
| |
|
We apologize for the delay. We require the Spreadsheet file so we can test this. Attach it here. Here are instructions: https://www.sierrachart.com/index.php?page=PostingInformation.php#AttachFile It can be privately attached. 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: