Support Board
Date/Time: Tue, 26 Nov 2024 13:53:27 +0000
version 1116 non CLR spreadsheet
View Count: 1463
| [2014-04-05 13:35:53] |
| Outlander - Posts: 91 |
|
My spreadsheet stopped working with ATCharts version 1116. I get #REF! Regards Outlander |
| [2014-04-06 21:36:43] |
| |
|
We are going to be releasing version 1117 a little later this evening. See if this resolves the problem. If not, can you let us know what particular formula gives this error so we can test it. The spreadsheets in the non-CLR version of Sierra Chart is still under active development and could have some problems from time to time until all of the development is finalized. 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 |
| [2014-04-07 17:29:38] |
| Outlander - Posts: 91 |
|
I have installed version 1117 but it did not help. almost every code get the same error #REF! They all worked in the past. Regards Outlander
|
Error.png| [2014-04-07 17:47:47] |
| |
|
We will check on this, but it would help us, if you let us know the particular formula you are using.
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 |
| [2014-04-07 17:54:38] |
| |
|
We cannot help with this without a formula.
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 |
| [2014-04-08 10:57:06] |
| Outlander - Posts: 91 |
|
=AND((U3-D3)>=(3*AI3),AZ4>AZ5,AJ3<100) =AND((C3-U3)>=(3*AI3),AZ4<AZ5,AJ3<100) =AND(AC3>0,AJ3<100) =AND(AE3>0,AJ3<100) =AJ3=100 Regards Outlander |
| [2014-04-08 19:06:29] |
| |
|
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 |
| [2014-04-08 20:48:10] |
| |
|
This is what we found in regards to this: All of the formulas the user posted are fine and do not give any errors in the current version. The #REF! errors must be coming from one of the referenced cells that is not visible, such as AJ3. Or there may be some circular reference among the given formulas, but I cannot tell without knowing where those formulas were located. I may need a copy of the whole spreadsheet to see where the error is coming from.
One thing we can let you know is circular references are not supported at all. Can you provide us a simplified example spreadsheet to demonstrate this #REF! error? 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-04-08 20:48:39
|
| [2014-04-09 05:12:49] |
| Outlander - Posts: 91 |
|
My spreadsheet stopped working after version 1114. If you give me an email adres I will mail you my sheet. Regards Outlander |
| [2014-04-09 18:12:31] |
| |
|
Send it to support AT Sierra Chart.com. Or you can privately attach it here following these instructions: https://www.sierrachart.com/index.php?l=PostingInformation.php#AttachFile 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-04-09 18:12:49
|
| [2014-04-10 18:55:14] |
| |
|
Please test the very latest prerelease of Sierra Chart. We tested your spreadsheet, and do not get any errors with it. 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 |
| [2014-04-11 06:03:45] |
| Outlander - Posts: 91 |
|
I have installed version 1118 but it did not help. Regards Outlander
|
| [2014-04-11 06:57:48] |
| |
|
We have tested this again and we see the problem. We are not sure why one of our programmers did not see it. We are going to be looking into it today.
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 |
| [2014-04-15 04:02:56] |
| |
|
We want to update you on this. It will not be until next week that this problem will be resolved. Unfortunately the programmer assigned to this, is out until next week.
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 |
| [2014-05-16 11:05:42] |
| Outlander - Posts: 91 |
|
Hi, I still have some problems with the Non-CLR spreadsheet. I have used TechTraders code in the past without any problems. But now I get this error code: #REF! It would be nice if you can fix it. Regards Outlander (ZigZag is in column AA) Column X =IF(AND(AA3<>AA4,AA3>0),SIGN(AA3-AA4),X4) Next, determine the last high point. Column Y =IF(AND(X4>0,X3<0),AA4,Y4) Finally, determine the last low point. Column Z =IF(AND(X4<0,X3>0),AA4,Z4) Columns Y and Z will plot horizontal lines of the last high/low until a new high/low is determined by your zigzag criteria. |
| [2014-05-16 16:22:54] |
| |
|
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 |
To post a message in this thread, you need to log in with your Sierra Chart account: