Registered User
Joined: 2/14/2011
Posts: 59
|
Bruce for Gapps using the following PCF -1 * (L > H1) OR -2 * (H < L1)
How can I change the check mark to say Green or Red or Up or Down rather than just Check mark
also wrote a PCF - In & Out - for an Inside Day yesterday folled by a Outside Day today
(H1 * ABS(L2 <= L1 AND H1 <= H2)) AND (H * ABS(L1 >= L AND H >= H1)) Works Well
Now I plot on chart, 1.) However Dot does not show, because I also plot both Inside and Outside Days which work fine but will not change the conditonal Outside Day color to IN & Out.
My work around is not to plot on price so TRUE plots above chart and False has one heck of alot of dots at bottom of chart 2.) can the bottom dots be removed or a different color to match background so they are not obvious
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
A WatchList Column based on a condition can show two colors. One color will be for true and the other color will be for not true. There is no way to make it show one color for true for one formula, another color for true for another formula and nothing for not true for either formula.
We can work around this to some extent by using an indicator instead of a condition. A WatchList Column based on an indicator can show three colors. One for above zero, one for below zero and a third color for zero or can't be calculated (which displays ...)
So in the case of your gaps, we could use the following Condition Formula with green for above zero and red for below zero.
(H < L1) - (L > H1)
You would need to click on the name of the WatchList Column at the top of the WatchList to set the Positive Color and Negative Color. You might also want to change the Decimal Places setting to 0.
The Formula used for your inside day yesterday followed by outside day today should probably be as follows.
H * ABS(L <= H1 AND H1 <= H AND L2 <= L1 AND H1 <= H2)
You can't make the bottom dots a different color, but you can make them not plot altogether. Just change the * in the formula to a / instead. That way you are dividing by either 0 or 1 instead of multiplying by either 0 or 1. Division by zero creates an error so the dot doesn't plot.
H / ABS(L <= H1 AND H1 <= H AND L2 <= L1 AND H1 <= H2)
Note that the H at the beginning of the formula is where you want the dot to plot. So you could plot it at the midpoint of the bar using something like the following instead.
(H + L) / 2 / ABS(L <= H1 AND H1 <= H AND L2 <= L1 AND H1 <= H2)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|