Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 9/26/2005 Posts: 49
|
I am trying to make a series of color coded columns. For example, the column would be green if MACD crossed up within the last three periods, red if MACD crossed down in last three periods and yellow otherwise. I can handle the colors with the properties. But how to make an indicator that is +1 under one condition, -1 under another, and zero otherwise. Any help would be appreciated.
|
|
![](/image.aspx?url=http%3a%2f%2fvideos.worden.com%2fforums%2favatars%2fbruceavatar.gif&width=100&height=100)
![](/images/ranks/WordenWing.gif) Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
One possible way to do so might be the following.
SGN(CountTrue(XUP(MACD, 0), 3) - CountTrue(XDOWN(MACD,0), 3))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 9/26/2005 Posts: 49
|
Very clever. Thanks.
I am assuming that I could do something similer with any indicator that has a function or Indicateor Formula Template but I would need to use a condition and two columns for things like PSAR or Ergodic.
Is that correct? If not correct how would I do something similer for PSAR or the Ergodic indicater? Currently I am using conditions and one column for up and one column for down crossings.
|
|
![](/image.aspx?url=http%3a%2f%2fvideos.worden.com%2fforums%2favatars%2fbruceavatar.gif&width=100&height=100)
![](/images/ranks/WordenWing.gif) Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You are correct that if you can make a formula for it, you can probably get three colors out of it.
If not, then you would probably need multiple WatchList Columns.
Note, that while PSAR is definitely problematic, some Ergodic indicators might not be.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |