Support Board
Date/Time: Wed, 08 Jan 2025 17:40:31 +0000
Alert Result in Spreadsheet
View Count: 637
| [2016-07-20 18:21:52] |
| User787778 - Posts: 142 |
|
I use if statements in alert condition formulas. Currently my spreadsheet only shows a heading for the alerts, but no record of either "1" or "0". Is there any way to get these results into a spreadsheet. |
| [2016-07-20 18:30:27] |
| |
|
It is impossible for us to understand this without seeing the spreadsheet and what you are doing. Give us one of the formulas 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 Date Time Of Last Edit: 2016-07-20 18:30:38
|
| [2016-07-20 18:49:19] |
| User787778 - Posts: 142 |
|
I am using color background based on alert condition study. One of the formulas is"=if(and(c<o,(avap(h,0)<10)),1,0)". I would like to take the result into the spreadsheet. ie "0" or "1"
|
| [2016-07-20 22:12:49] |
| |
|
This will not make a difference, but you just need to use this formula: and(c<o,(avap(h,0)<10)) When using the Spreadsheet study, you need to consider Calculation Order/Precedence: https://www.sierrachart.com/index.php?page=doc/doc_ChartStudies.html#StudyCalculationPrecedence Make sure this Color Background study is at the top of the list of studies. 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: