Login Page - Create Account

Support Board


Date/Time: Wed, 05 Feb 2025 08:40:50 +0000



Post From: Has Functionality for Identifying Zero Prints Been Established Yet?

[2024-12-30 22:09:54]
John - SC Support - Posts: 37728
If you want a different color, or different marker for a Zero Bid versus a Zero Ask, then you would need 2 copies of the Color Bar Based on Alert condition. If you do not need to separate Bid and Ask then the alert condition we gave you above would extend to be the following:
=OR(BVAP(L, 0) = 0, AVAP(L, 0) = 0, BVAP(L + TICKSIZE, 0) = 0, AVAP(L + TICKSIZE, 0) = 0)

But, there is a problem that you would need to deal with, which is that if you test for a value of zero outside the range of a bar, then you will get a true response, which is not what you really want. And there is not a good way to deal with this through the Alert Conditions. There are some ways you could work around this, but it would require a lot of Spreadsheet Formula studies to do it.

In the end, our recommendation would be to pay a programmer to create a custom study that finds the zeros. Refer to the following:
https://www.sierrachart.com/index.php?page=doc/SierraChartStudyAndSystemProgrammers.php
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing