Login Page - Create Account

Support Board


Date/Time: Sun, 05 May 2024 12:55:25 +0000



counting bars in condition formula?

View Count: 1345

[2016-12-27 10:26:36]
User970210 - Posts: 83
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]
Sierra Chart Engineering - Posts: 104368
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:

Login

Login Page - Create Account