Login Page - Create Account

Support Board


Date/Time: Sun, 08 Sep 2024 00:20:38 +0000



TRUE condition for MA Slope ?

View Count: 904

[2015-03-24 16:46:00]
User52239 - Posts: 13
Is it possible to use a true condition for a MA slope color ?
e.g. In a spreadsheet formula, I would like to identify a MA by it's slope. I have it set to paint green for up and red for down.
Can you use this with a true condition for being red or green ?

shane
[2015-03-24 17:10:03]
Sierra Chart Engineering - Posts: 104368
The formula has to be written based on the values of a study Subgraph, and not its color.
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
[2015-03-25 01:26:14]
Sawtooth - Posts: 4083
I use something like this, e.g. in X3:

=IF(AND(AA5>=AA4,AA3>AA4),"UP",IF(AND(AA5<=AA4,AA3<AA4),"DN",X4))
Where the MA is in column AA

Then in Y3, for an up arrow:
=IF(AND(X4="DN",X3="UP"),D3,0)

and in Z3, for a down arrow:
=IF(AND(X4="UP",X3="DN"),C3,0)

[2015-03-25 13:47:19]
User52239 - Posts: 13
thats great Tom

Thanks

shane

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

Login

Login Page - Create Account