Hello, I'm new to TC2000. I am trying to setup a few PCF and not seeing the results I would expect.

For example, I am trying to set up a PCF for price above 30 week MA. I saw an example posted elsewhere but when I check the result against the chart it is incorrect.

That example was here: http://forums.worden.com/default.aspx?g=posts&t=36594

C <= .98 * (C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95 + C100 + C105 + C110 + C115 + C120 + C125 + C130 + C135 + C140 + C145) / 30

I changed it to C > (...) / 30. It didn't work

Anyhow, to simplify this I started looking at what the individual values return and checking them against the chart.

I tried (C + C1 + C2 + C3 + C4) / 5 and hit the "Test Formula" button, that returned 20.91. So I then changed the fomula to  (C + C1 + C2 + C3 + C4) / 5 = 20.91 and it returned False. Can you please explain this?

Thanks

A Personal Criteria Formula for Price being above its 30-Period Simple Moving Average on a Weekly Chart would be:

29 * C > C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95 + C100 + C105 + C110 + C115 + C120 + C125 + C130 + C135 + C140 + C145

Depending on where you are going to use this Indicator, you may not need a PCF.

You can add 30 period SMA to your chart, and then click on the little down arrow beside Moving Average 30. Look for Create Scan Crteia, and there will be options there, including Above (as well as Crossing etc.)

The formulas are designed for TC2000 version 7 where the weeks are based on 5 trading day rolling bars and where there is no way to set the time frame of a formula to anything besides daily.

These formulas will not match the weekly charts in TC2000 version 12.4 even when they are created using a daily time frame because the weekly bars in TC2000 version 12.4 are based on calendar weeks running from Monday through Friday.

In TC2000 version 12.4, you would generally just add the moving average to the chart and then click on Price History to select Create Scan Condition (as pointed out by bcochrane).

Adding and Moving Indicators (7:19)
Create Conditions from Your Chart (5:25)

But if you are going to create a Condition Formula, you would set the time frame of the Condition Formula to Weekly and use the built in syntax for a moving average.

C > AVGC30

PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!