Support Board
Date/Time: Fri, 31 Jan 2025 17:52:32 +0000
counting bars in condition formula?
View Count: 1421
| [2016-12-27 10:26:36] |
| User970210 - Posts: 99 |
|
Hi, is there count function that can be used to count number of bars in specific condition in alert formula? thanks |
| [2016-12-27 18:28:31] |
| |
|
What we are describing here is when using the Spreadsheet Study: http://www.sierrachart.com/index.php?page=doc/SpreadsheetStudy.html What we recommend doing is to use a formula column on the Sheet using the IF function which returns 1 when the specific condition is true. Then use the SUM function to count how many times that condition is true. Reference: http://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html 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 |
| [2019-05-23 18:28:30] |
| User871277 - Posts: 34 |
|
Seems to be exactly what I need, does anyone know if it works with SC 1880?
|
To post a message in this thread, you need to log in with your Sierra Chart account: