Support Board
Date/Time: Sun, 22 Dec 2024 11:09:19 +0000
Alert formula error
View Count: 1541
| [2014-11-25 04:40:03] |
| nicktrader - Posts: 715 |
|
I got the following error message: Alert Formula Error - Chart: F.US.DDZ14 15 Min #3 | Study: EMA200 | Error: #SYNTAX! | Formula: =AND(SG1 <= H, SG1 >= L) Intention ==>> an alert if touched What is the problem? I am using version 1205 |
| [2014-11-25 04:44:40] |
| |
|
How do you have Global Settings >> Spreadsheet Settings >>Decimal and Function Delimiter set?
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-11-25 05:28:13] |
| nicktrader - Posts: 715 |
|
see attached file
|
 Spreadsheet settings.jpg / V - Attached On 2014-11-25 05:27:11 UTC - Size: 52.63 KB - 362 views |
| [2014-11-25 05:38:59] |
| nicktrader - Posts: 715 |
|
I changed the Spreadsheet settings in "Use full stop..." and I do not get an alert formula error message. How should this formula (AND(SG1 <= H, SG1 >= L)) be amended to add the condition "+/- 3 pips". |
| [2014-11-25 08:19:53] |
| |
|
In our testing that we did later on, the Decimal and Function Delimiter setting did not have an effect upon Simple Alerts. Do you know if you are running Sierra Chart with New Spreadsheets or Old Spreadsheets? In any case we recommend updating to the current version. We know you are no longer having the problem, but we just want to have a better understanding of why this even happened to begin with. Formula writing help is not within the scope of our support. However, you may be interested in using the TICKSIZE variable within your 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 Date Time Of Last Edit: 2014-11-25 08:20:27
|
| [2014-11-25 11:03:17] |
| nicktrader - Posts: 715 |
|
I am sorry but I do not know if new or old spreadsheets. I downloaded version1205 3 weeks ago.
|
| [2014-11-25 17:46:42] |
| |
|
If you are not using Spreadsheets within Sierra Chart, then we recommend installing the version with New Spreadsheets. You can update with Help >> Download Current Version (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: