Different Colors for Multiple Conditions

[forum]

[yahoo message 1981]

Oops, I didn't change the comparison operators on the second expression, but I am sure you get what I was trying to say!
---------------------------------
Regards,
Raymond Deux
NinjaTrading
"Stealth, patience and discipline always win"
www.ninjatrading.com
----- Original Message -----
From: Raymond Deux - Ninja Trading
To: neoticker@yahoogroups.com
Sent: Monday, May 20, 2002 9:18 AM
Subject: Re: [neoticker] Quote Window Formula Question


Dave,

I have different application but the same end result of coloring a cell. Here is what you need to do us an if statement and assign a value to each individual state. For example:

if(ROC(0,M5,10) > 0 AND ADX(M5,10) >= 20,1,0) +
if(ROC(0,M5,10) > 0 AND ADX(M5,10) >= 20,2,0)

This expression will show a value of either 0,1 or 2 in the cell. If the first condition is true, it will read 1 + 0 = 1. If the second condtion is true, it will read 0 + 2 = 2. If they both are not true, it will show 0 + 0 = 0.

You then Assign colors to the specific values in the colors tab on the column properties dialogue box.

This should get you started.

---------------------------------
Regards,
Raymond Deux
NinjaTrading
"Stealth, patience and discipline always win"
www.ninjatrading.com
----- Original Message -----
From: Dave Seremek
To: neoticker@yahoogroups.com
Sent: Monday, May 20, 2002 4:28 PM
Subject: [neoticker] Quote Window Formula Question


I have two quote pages. Each one has one formula with multiple time frames. One is roc(m5,10)>=0. The other is adx(m5,10)>=30.



I would like to combine these two expressions in each column of a single quote page and have the following happen:



If roc>0 and adx>=20 then the cell would be green.
If roc>0 and adx<= 20 then cell would be pale green.
If roc<=o and and<= 20 then pink
If roc<=0 and adx>=20 then the cell would be red.


Could someone advise me on how this could be done?



Thx,



Dave

[forum]

[Yahoo message 1982]

Not directly, but you can do it

Procedures
----------------

Create a formula column call roc. The formula will be roc(m5, 10) >= 0.

Create a formula column call adx. The formula will be adx(m5, 10) >= 30.

Create a formula column call adx2. The formula will be (adx + 1) * 2.

Create a formula column call sum. The formula will be roc + adx2

Color the column sum.
sum = 2 pink
sum = 3 pale green
sum = 4 red
sum = 5 green

Explanation
-----------------
The idea is if roc < 0, then roc column = 0, else roc column = 1.

If adx >= 30, then adx column = 0, else adx column = 1, and thus
adx2 = 2, else adx2 = 4.

So sum = roc + adx2 ranges from 2 to 5, representing the conditions:

2 - if roc < 0 and adx < 30
3 - if roc >= 0 and adx < 30
4 - if roc < 0 and adx >= 30
5 - if roc >= 0 and adx >= 30

-----------------
Louis Lin
TickQuest Inc www.tickquest.com

----- Original Message -----
From: Dave Seremek
To: neoticker@yahoogroups.com
Sent: Monday, May 20, 2002 6:28 PM
Subject: [neoticker] Quote Window Formula Question


I have two quote pages. Each one has one formula with multiple time frames. One is roc(m5,10)>=0. The other is adx(m5,10)>=30.



I would like to combine these two expressions in each column of a single quote page and have the following happen:



If roc>0 and adx>=20 then the cell would be green.
If roc>0 and adx<= 20 then cell would be pale green.
If roc<=o and and<= 20 then pink
If roc<=0 and adx>=20 then the cell would be red.


Could someone advise me on how this could be done?



Thx,



Dave