Support Board
Date/Time: Sun, 22 Dec 2024 05:17:28 +0000
TRUE condition for MA Slope ?
View Count: 947
| [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] |
| |
|
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: 4141 |
|
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: