Hi Bruce,

Can you please provide a pcf for price above 8 EMA for more than 1 % from the 34 EMA for a minimum of 4 days to  max of 9 day period.

Can we also create a second scan such that the above criteria is about 1% below a 50 DMA.

Thanks,

MK

The first formula is fairly straightforward is TC2000 v18.

ABS(TrueInRow(C > XAVGC8 AND ABS(C / XAVGC34 - 1) > .01, 10) - 6.5) < 3

But a bit more complicated in TC2000 v12.5.

C > XAVGC8 AND ABS(C / XAVGC34 - 1) > .01 AND C1 > XAVGC8.1 AND ABS(C1 / XAVGC34.1 - 1) > .01 AND C2 > XAVGC8.2 AND ABS(C2 / XAVGC34.2 - 1) > .01 AND C3 > XAVGC8.3 AND ABS(C3 / XAVGC34.3 - 1) > .01 AND NOT(C4 > XAVGC8.4 AND ABS(C4 / XAVGC34.4 - 1) > .01 AND C5 > XAVGC8.5 AND ABS(C5 / XAVGC34.5 - 1) > .01 AND C6 > XAVGC8.6 AND ABS(C6 / XAVGC34.6 - 1) > .01 AND C7 > XAVGC8.7 AND ABS(C7 / XAVGC34.7 - 1) > .01 AND C8 > XAVGC8.8 AND ABS(C8 / XAVGC34.8 - 1) > .01 AND C9 > XAVGC8.9 AND ABS(C9 / XAVGC34.9 - 1) > .01)

Adding the criteria of price being at least 1% below the 50 period simple moving average results in the following for TC2000 v18.

ABS(TrueInRow(C > XAVGC8 AND ABS(C / XAVGC34 - 1) > .01 AND C <= .99 * AVGC50, 10) - 6.5) < 3

And the following for TC2000 v12.5.

C > XAVGC8 AND ABS(C / XAVGC34 - 1) > .01 AND C <= .99 * AVGC50 AND C1 > XAVGC8.1 AND ABS(C1 / XAVGC34.1 - 1) > .01 AND C1 <= .99 * AVGC50.1 AND C2 > XAVGC8.2 AND ABS(C2 / XAVGC34.2 - 1) > .01 AND C2 <= .99 * AVGC50.2 AND C3 > XAVGC8.3 AND ABS(C3 / XAVGC34.3 - 1) > .01 AND C3 <= .99 * AVGC50.3 AND NOT(C4 > XAVGC8.4 AND ABS(C4 / XAVGC34.4 - 1) > .01 AND C4 <= .99 * AVGC50.4 AND C5 > XAVGC8.5 AND ABS(C5 / XAVGC34.5 - 1) > .01 AND C5 <= .99 * AVGC50.5 AND C6 > XAVGC8.6 AND ABS(C6 / XAVGC34.6 - 1) > .01 AND C6 <= .99 * AVGC50.6 AND C7 > XAVGC8.7 AND ABS(C7 / XAVGC34.7 - 1) > .01 AND C7 <= .99 * AVGC50.7 AND C8 > XAVGC8.8 AND ABS(C8 / XAVGC34.8 - 1) > .01 AND C8 <= .99 * AVGC50.8 AND C9 > XAVGC8.9 AND ABS(C9 / XAVGC34.9 - 1) > .01 AND C9 <= .99 * AVGC50.9)

Thanks Bruce. Now with the first formula  for price above 8 EMA for more than 1 % from the 34 EMA for a minimum of 4 days to  max of 9 day period.can you create a scan with these conditions that it is 1-3% above 50 EMA and the 50 EMA is 1-3 % above 150 EMA.

Not sure if this can be done. Adding a critero of volume 1.4 times MA60 in the past month before price conolidating with the 8 EMA criteria with 34 EMA.

Thanks,

MK

Please try the following.

ABS(TrueInRow(C > 1.01 * XAVGC8 AND ABS(XAVGC8 / XAVGC50 - 1.02) <= .01 AND ABS(XAVGC50 / XAVGC150 - 1.02) <= .01, 10) - 6.5) < 3

I do not know what is being requested in the second paragraph.

Thanks Bruce. For the above request, what I was looking for is that price is above 8 EMA for more than 1 % from the 34 EMA for a minimum of 4 days to  max of 9 day period and this criteria

1.1-3% above 50 EMA and the 50 EMA is 1-3 % above 150 EMA

2. Volume was about 1.4 times average MA60 in any of the past 30 days

Not sure if the second criteria can be written along with the first one.

Regards,

MK

Please try the following condition formula.

ABS(TrueInRow(C > 1.01 * XAVGC8 <= .01, 10) - 6.5) < 3 AND ABS(XAVGC8 / XAVGC50 - 1.02) <= .01 AND ABS(XAVGC50 / XAVGC150 - 1.02) <= .01 AND CountTrue(V >= 1.4 * AVGV60, 30) > 0

Thanks Bruce. It generates a formula error when I try to create a new condition.

Regards,

Mk

I have eliminated a space in the syntax near the end of the formula. Please try the new version (as corrected above).

Thanks Bruce. So far it gives me 0 results. Let me work on it and get back to you.

Regards,

Mk

You're welcome.