Login Page - Create Account

Support Board


Date/Time: Fri, 26 Apr 2024 16:34:09 +0000



[User Discussion] - Color Bar Based On slope - states

View Count: 1223

[2014-01-02 02:49:24]
djcurcio - Posts: 236
I am using a Color Bar Based on Slope that has "Use +1 / -1 for Color Bar" set to "Yes". But it appears there are 3 states ,-1, 0, and +1. This shows when viewed in a spread sheet and causes complications for programming alerts and trade orders. How can I get this to emit only two states: +1, and -1. Thanks
[2014-01-03 05:31:29]
Sierra Chart Engineering - Posts: 104368
You will have to create your own custom study to do this.
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
[2014-01-03 13:35:24]
Sawtooth - Posts: 3976
If you use a spreadsheet study instead of the Color Bar Based On Slope study, you could use a formula like this:

=IF(AA3>AA4,1,IF(AA3<AA4,-1,Z4))

where:
-column AA is the line with slope
-the formula is in cell Z3

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account