Hello Bruce.

I made an indicator using "Create Condition" which is:

- The Fisher Transform (5 period) from the source below:

-  The SMI Ergodic Oscillator (7, 13, 5) which itself is sourced from:

-  The StochRSI (7, 7, 3)

I drew the 0 line for the Fisher but would like to create a histogram (+1 to -1) in order to be able to chart (a) when the Fisher crosses the 0 Line up (= +1 histo bar), and (b) when the Fisher crosses the 0 line down (-1), with no values in between. So this histogram is either at +1, 0 (if no cross) or -1.

Could you help me with the formula for charting this histogram for the existing (compound) indicator (Fisher, SMI Ergo, StochRSI)?

Thanks very much and kind regards,

Chris 

I cannot think of a way to write the formula which is not too long and slow to be practical or post in the forums.

OK, thanks,

Would it be possible to have the same type of histogramm indicator just for the 7-period Aroon Oscillator, whereby a +1 histo bar would symbolize an oscillator reading >+70 and a -1 histo bar would mean <-70.? In this case only these two states +1 and -1.

Kind regards,

Chris 

Please try the following indicator formula.

IIF(AROONUP7 - AROONDOWN7 > 70, 1, IIF(AROONUP7 - AROONDOWN7 < -70, -1, 0))

Many thanks Bruce - I'll give it a try.

I'm not sure about this, but wasn't there a way to make a condition (like the compound condition I created with the Fisher/SMI/StochRSI) into an indicator without re-writing it?

Kind regards,

Chris 

You can make a condition just by clicking on the indicator and selecting Create Condition. What you can't do is create an indicator which plots +1, 0, or -1 based on those conditions.

Thanks Bruce, for clariying. Have a nice weekend. Chris 

Hi Bruce,

I couldn't get this to work with "Create a Condition" on the chart. I would like to create Condition PCFs for:

1) The PMO(21,13,7) crossing up the PMO(35,20,10)

and another Condition PCF for:

2) The PMO(21,13,7) crossing down the PMO(35,20,10)

- I'm not using the EMA's (3rd parameter) here, just these formulas:

1000 * XAVG(XAVG(C / C1 - 1, 20), 12)

If I am understanding correctly, the crossup would be:

XUP(XAVG(XAVG(C / C1 - 1, 20), 12), XAVG(XAVG(C / C1 - 1, 34), 19))

And the crossdown would be:

XDOWN(XAVG(XAVG(C / C1 - 1, 20), 12), XAVG(XAVG(C / C1 - 1, 34), 19))

You would just replace all instances of X in the formulas with H instead to switch the moving averages from exponential to Hull.

Thanks very much, Bruce.

Wish you really good holidays. 

Hello Bruce,

I'm writing a Condition PCF and would like to add this filter:

- The scan results should not include stocks which have made 5 or more consecutive daily highs.

It would be good if I could change the number of daily highs myself later on.

Many thanks,

Chris 

Please try the following condition formula.

NOT(TrueInRow(H > H1, 5) = 5)

This could be shortened to the following.

TrueInRow(H > H1, 5) < 5

But if you want something to be not true, the easiest way is to just use the NOT() function.

Thanks very much Bruce - I appreciate your help.

Hi Bruce,

I have a PCF condition for checking whether two T3 Noving Averages have crossed (down) within the last 3 bars, as follows:

CountTrue(XDOWN(-4.235801 * XAVG(XAVG(XAVG(XAVG(XAVG(XAVGC4, 4), 4), 4), 4), 4) + 20.561175096* XAVG(XAVG(XAVG(XAVG(XAVGC4, 4), 4), 4), 4) - 33.268947 * XAVG(XAVG(XAVG(XAVGC4, 4), 4), 4) + 17.943573032* XAVG(XAVG(XAVGC4, 4), 4), -2.0580756 * XAVG(XAVG(XAVG(XAVG(XAVG(XAVGC6, 6), 6), 6), 6), 6) + 11.028179 * XAVG(XAVG(XAVG(XAVG(XAVGC6, 6), 6), 6), 6) - 19.698131 * XAVG(XAVG(XAVG(XAVGC6, 6), 6), 6) + 11.728028 * XAVG(XAVG(XAVGC6, 6), 6)), 3) >0

I would like to have a PCF condition that shows the exact opposite, namely that the T3-4-1.618 has NOT cross the T3-6-1.272 down within the last 3 bars.

Is there an easy way to adapt the existing formula? Many thanks !

Chris 

I didn't notive this ealier, but maybe if I change the " >0" at the end to " =0", that might do it.

Well in general, the easiest way to check for something not being true is to just put it inside of a NOT() function.

That said, in this case, I suspect changing the > 0 at the end to = 0 instead would work just as well.

Thanks very much Bruce. I tried it out on several samples, and it seems to work.. Kind regards, Chris 

Hi Bruce,

I have used this condition PCF for quite some time which filters one T3 Moving Average (T3-4-1.618) crossing down on another T3 (T3-6-1.272):

XDOWN(-4.235801 * XAVG(XAVG(XAVG(XAVG(XAVG(XAVGC4, 4), 4), 4), 4), 4) + 20.561175096* XAVG(XAVG(XAVG(XAVG(XAVGC4, 4), 4), 4), 4) - 33.268947 * XAVG(XAVG(XAVG(XAVGC4, 4), 4), 4) + 17.943573032* XAVG(XAVG(XAVGC4, 4), 4), -2.0580756 * AVG(XAVG(XAVG(XAVG(XAVG(XAVGC6, 6), 6), 6), 6), 6) + 11.028179 * XAVG(XAVG(XAVG(XAVG(XAVGC6, 6), 6), 6), 6) - 19.698131 * XAVG(XAVG(XAVG(XAVGC6, 6), 6), 6) + 11.728028 * XAVG(XAVG(XAVGC6, 6), 6))

What I would really like to do, is to have TC2000 draw a down arrow when this instance occurs.If that would not be possible, I could also use a histogram indicator panel which would only show the (sell) signals in this case.

Thanks much for your help. Kind regards,

Chris 

There isn't a way to plot arrows on the chart.

The easiest thing to do would just be to add a Custom PCF % True Indicator to the chart and use your condition formula as the Boolean Formula setting in the Custom PCF % True Indicator. This would normally plot spikes on teh chart when the Boolean Formula is true, but you can change the Plot Style to Histogram instead.

Another option if you want to plot something at a specific numeric value would be to use the IIF() function as part of the Formula in a Custom PCF Indicator (not the same as a Custom PCF % True Indicator). The first argument would be your condition formula, the second argument wolud be the value you want when the condition formula is true, and the third argument would be the value you want to return when the condition formula is false.

If you use the Dots Plot Style in your Custom PCF % True Indicator and 1 / 0 as the value to plot when the Boolean Formula is false, you will get dots plotted at the desired value when true and nothing plotted on the chart when the value is false.

So let's say you want to plot at dot at the closing price when true. You would use the following Boolean Formula in your Custom PCF Indicator with the Plot Styles set to Dots.

IIF(XDOWN(-4.235801 * XAVG(XAVG(XAVG(XAVG(XAVG(XAVGC4, 4), 4), 4), 4), 4) + 20.561175096* XAVG(XAVG(XAVG(XAVG(XAVGC4, 4), 4), 4), 4) - 33.268947 * XAVG(XAVG(XAVG(XAVGC4, 4), 4), 4) + 17.943573032* XAVG(XAVG(XAVGC4, 4), 4), -2.0580756 * AVG(XAVG(XAVG(XAVG(XAVG(XAVGC6, 6), 6), 6), 6), 6) + 11.028179 * XAVG(XAVG(XAVG(XAVG(XAVGC6, 6), 6), 6), 6) - 19.698131 * XAVG(XAVG(XAVG(XAVGC6, 6), 6), 6) + 11.728028 * XAVG(XAVG(XAVGC6, 6), 6)), C, 1 / 0)

Thanks so much for your detailed help, Bruce. I'll study this at length. Chris 

Hi Bruce,

For a scan, I'm looking to add some conditions which specify:

- 3 or more of the last 5 bars have lower highs (than the bar before respectively);

- The 10-bar EMA or the 20-bar EMA is crossing the current bar range (H-L) anywhere;

and also a volume related one:

- the current bar volume is less than the average volume of the last 10 bars.

Thanks for helping me out.

Chris 

Pleaes try the following condition formula.

CountTrue(L < L1, 5) >= 3 AND (ABS(H + L - 2 * XAVGC10) <= H - L OR ABS(H + L - 2 * XAVGC20) <= H - L) AND V < AVGV10.1

Thanks very much for your quick reply. Presumably, I could split this up into 3 segments, so as to be able to use combinations:

Yes you could. If you split it up, you don't need the parantheses around the second segment.

Hi Bruce,

How would I write a scan criteria that would include (both):

C > BBTOP(0.25, 20)

OR

C is in the upper half of this Bollinger Band?

Many thanks for your help.

Chris 

I may be misunderstanding the question, but I think it is just:

C >= AVGC20

Oh, of course - you're absolutely right. It was an easy one. Thanks much!

Using the EMA20, would I just write it like this?

C >= XAVGC20

(I ususally plot my Bollinger Bands using an EMA....)

Exactly. Just keep in mind you can't use the built in BBTOP() and BBBOT() functions if the centerline is exponential.

Thanks, Bruce. I appreciate your help as always. Chris 

You're welcome.