Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Color coded columns Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
CGTrader
Posted : Wednesday, February 6, 2019 11:40:01 PM
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.

Bruce_L
Posted : Thursday, February 7, 2019 8:15:28 AM


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
CGTrader
Posted : Thursday, February 7, 2019 12:44:16 PM
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.

Bruce_L
Posted : Thursday, February 7, 2019 1:04:35 PM


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
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.