Support Board
Date/Time: Wed, 27 Nov 2024 07:35:11 +0000
NoCLR version gives alert formula errors
View Count: 920
| [2014-08-13 03:04:17] |
| rc7rader - Posts: 144 |
|
I updated to the NoCLR version #1173 from regular version #1166 and got an alert formula error message. My chartbook has 6 charts and each chart is using the same studies. Below is the error message which is the same for the 5 other charts. How do I fix this? Alert Formula Error - Chart: RAX 5 Min #1 | Study: Trade Alert | Error: #SYNTAX! | Formula: =OR( AND(C>=ID3.SG15-0.10, C<=ID3.SG15+0.10), AND(C>=ID3.SG16-0.10, C<=ID3.SG16+0.10), AND(C>=ID3.SG17-0.10, C<=ID3.SG17+0.10), AND(C>=ID3.SG18-0.10, C<=ID3.SG18+0.10) ) | 2014-08-12 22:59:46 |
| [2014-08-13 03:20:30] |
| rc7rader - Posts: 144 |
|
I understand the incompatibility. This is the only formula I use in my studies and I don't use spreadsheet studies. All I wanted to know is how to convert this formula to be compatible with the new NoCLR version so I can start using it if that's where we're heading anyway.
|
| [2014-08-13 03:36:30] |
| rc7rader - Posts: 144 |
|
Okay I fixed it. I checked the Non-CLR spreadsheet functions and my formula was okay, except in the old version I had it written out like this so I can easily read each criteria. =OR( AND(C>=ID3.SG15-0.10, C<=ID3.SG15+0.10), AND(C>=ID3.SG16-0.10, C<=ID3.SG16+0.10), AND(C>=ID3.SG17-0.10, C<=ID3.SG17+0.10), AND(C>=ID3.SG18-0.10, C<=ID3.SG18+0.10) ) In the non-CLR version, it has to be written out in one line. =OR(AND(C>=ID3.SG15-0.10, C<=ID3.SG15+0.10),AND(C>=ID3.SG16-0.10, C<=ID3.SG16+0.10),AND(C>=ID3.SG17-0.10, C<=ID3.SG17+0.10),AND(C>=ID3.SG18-0.10, C<=ID3.SG18+0.10)) |
| [2014-08-13 08:17:10] |
| |
|
We will solve this issue in the version supporting the new spreadsheets.
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: