Hi Bruce,

Please help me to write a PCF that I can use to scan as a colum on any of my watchlists.

I am using the TC 2000 -12.3 Beta program.

Here is what I am looking for: Using a 3Day timeframe, first I want MACD 12-26 crossing

below its -0- line sometime in the last 90 days and then move up sharply to cross its

EMA 9 in the last 6 or 9 days.

Thanks hheiden.

The following Condition Formula checks for the MACD to currently be above its signal line while being below its signal line 3-bars ago. It also checks for the MACD to be below zero 3-bars ago but above zero at some point during the 27-bars before that. You will need to set the Time Frame of the Condition Formula to 3-days.

XAVGC12 + XAVG(XAVGC26,9) > XAVGC26 + XAVG(XAVGC12,9) AND XAVGC12.3 + XAVG(XAVGC26.3,9) < XAVGC26.3 + XAVG(XAVGC12.3,9) AND XAVGC12.3 < XAVGC26.3 AND (XAVGC12.4 > XAVGC26.4 OR XAVGC12.5 > XAVGC26.5 OR XAVGC12.6 > XAVGC26.6 OR XAVGC12.7 > XAVGC26.7 OR XAVGC12.8 > XAVGC26.8 OR XAVGC12.9 > XAVGC26.9 OR XAVGC12.10 > XAVGC26.10 OR XAVGC12.11 > XAVGC26.11 OR XAVGC12.12 > XAVGC26.12 OR XAVGC12.13 > XAVGC26.13 OR XAVGC12.14 > XAVGC26.14 OR XAVGC12.15 > XAVGC26.15 OR XAVGC12.16 > XAVGC26.16 OR XAVGC12.17 > XAVGC26.17 OR XAVGC12.18 > XAVGC26.18 OR XAVGC12.19 > XAVGC26.19 OR XAVGC12.20 > XAVGC26.20 OR XAVGC12.21 > XAVGC26.21 OR XAVGC12.22 > XAVGC26.22 OR XAVGC12.23 > XAVGC26.23 OR XAVGC12.24 > XAVGC26.24 OR XAVGC12.25 > XAVGC26.25 OR XAVGC12.26 > XAVGC26.26 OR XAVGC12.27 > XAVGC26.27 OR XAVGC12.28 > XAVGC26.28 OR XAVGC12.29 > XAVGC26.29 OR XAVGC12.30 > XAVGC26.30)

Understanding MACD
Personal Criteria Formula Conditions
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!

Bruce, thanks for your quick responce. I will see if this give me the results I'm looking for.

Bruce, this PCF works like a charm on my first watchlist out of 200 ETFs 3 good looking

names came up.

Thanks again hheiden.

You're welcome.