Login Page - Create Account

Support Board


Date/Time: Wed, 12 Mar 2025 16:12:55 +0000



Post From: Unable to auto-color text based on +/- when using Text Display for Study

[2022-05-11 14:23:37]
John - SC Support - Posts: 38612
You can not get the study to color using the Based On options. In the end, what is put on the screen is a drawing tool and therefore these items do not apply.

What you could do is use two instances of the Spreadsheet Formula where one outputs the value when it is positive (otherwise 0) and the other outputs the value when it is negative (otherwise 0). The formula for the positive situation would look like the following:
=IF(ID1.SG1 > 0, ID1.SG1, 0)

You would then use 2 instances of the Text Display for Study where one references the Positive Spreadsheet Formula and is the color you want for positive values and the other references the Negative Spreadsheet Formula and is the color you want for negative. You would have two items on the screen and one would always be showing 0.00, but you could get the coloring this way.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing