Support Board
Date/Time: Wed, 05 Nov 2025 03:22:15 +0000
[Programming Help] - SYNTAX Error for change in slope.
View Count: 833
| [2020-01-03 11:53:56] |
| User785594 - Posts: 3 |
|
I am using the spreadsheet function for System Alert Study. I want to get an alert when the slope of a study changes. I used this in the spreadsheet. The formula is the one off the SC help site: =OR(AND(ID2.SG1@0>ID2.SG1@-1,ID2.SG1@-1<=ID2.SG1@-2),AND(ID2.SG1@0<ID2.SG1@-1,ID2.SG1@-1>=ID2.SG1@-2)) Why do I get a syntax error? what is written incorrectly? Thanks for your help. |
| [2020-01-06 16:58:35] |
| |
|
You are asking for programming help. We may have someone who can help you though. We will get back to you through a Direct Message. 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: 2020-01-06 16:59:01
|
| [2020-01-06 17:54:30] |
| Sawtooth - Posts: 4285 |
|
You need to use this formula in spreadsheet studies: Spreadsheet Example Formulas and Usage: Formula that Matches the Slope Coloring of a Study Subgraph Line Then to get an alert when it changes, use a formula like this in another Formula Column: =AND(Z4<>Z3) |
To post a message in this thread, you need to log in with your Sierra Chart account: