There is significantly improved syntax available in TC2000 v17.

Version 17 PCF Capabilities

Personal Criteria Formula Syntax

Indicators:

AVGCx.z -> Simple Moving Average of Close/Last Price
AVGHx.z -> Simple Moving Average of High Price
AVGLx.z -> Simple Moving Average of Low Price
AVGOx.z -> Simple Moving Average of Open Price
AVGVx.z -> Simple Moving Average of Volume
BOPy.z -> Balance of Power (Green>30,Red<-30,Yellow30to–30)
Cz -> Close/Last Price
Hz -> High Price
Lz -> Low Price
MAXCx.z -> Maximum of Close/Last Price
MAXHx.z -> Maximum of High Price
MAXLx.z -> Maximum of Low Price
MAXOx.z -> Maximum of Open Price
MAXVx.z -> Maximum of Volume
MINCx.z -> Minimum of Close/Last Price
MINHx.z -> Minimum of High Price
MINLx.z -> Minimum of Low Price
MINOx.z -> Minimum of Open Price
MINVx.z -> Minimum of Volume
MSy.z -> Cumulative MoneyStream
Oz -> Open Price
OBVy.z -> On Balance Volume
RSIx.y.z -> RSI (not Wilder's Smoothed)
STOCx.y.z -> Simple Stochastic
TSVy.z -> Time Segmented Volume
Vz -> Volume
XAVGCx.z -> Exponential Moving Average of Close/Last Price
XAVGHx.z -> Exponential Moving Average of High Price
XAVGLx.z -> Exponential Moving Average of Low Price
XAVGOx.z -> Exponential Moving Average of Open Price
XAVGVx.z -> Exponential Moving Average of Volume

Functions:

ABS(w ) -> Absolute Value
AVG(w,x) -> Simple Moving Average
EXP(w ) -> Natural Exponent
LOG(w ) -> Natural Log
MAX(w,x) -> Maximum
MIN(w,x) -> Minimum
SGN(w ) -> Sign (-1, 0 or 1)
SQR(w ) -> Square Root
XAVG(w,x) -> Exponential moving Average

Functions (unsupported):

ATN(w ) -> Arctangent
COS(w ) -> Cosine
COT(w ) -> Cotangent
CSC(w ) -> Cosecant
NOT(w ) -> Not (Boolean)
SEC(w ) -> Secant
SIN(w ) -> Sine
SINH(w ) -> Hyperbolic Sine
TAN(w ) -> Tangent
TANH(w ) -> Hyperbolic Tangent

Where w is the Number or Indicator to which a Function is applied.
- w cannot be a formula or function for AVG(), MAX(), MIN(), XAVG()
Where x is the Period of the Indicator or Function.
Where y is a the Period of an additional Simple Moving Average.
Where z is the number of Periods Ago.
- z can also be a date. May 3, 2007 would be (single quotes required): '05/03/07'

The arguments in indicators are separated by periods while the arguments in functions are separated by commas.

Operators:

* -> Multiply
/ -> Divide or Ratio
+ -> Add
- -> Subtract or Difference
> -> Greater Than (Boolean)
>= -> Greater Than or Equal To (Boolean)
< -> Less Than (Boolean)
<= -> Less Than or Equal To (Boolean)
= -> Equal To (Boolean)
<> -> Not Equal To (Boolean)
OR -> Or (Boolean)
AND -> And (Boolean)

Operators (unsupported):

\ -> Integer Divide
^ -> Power
MOD -> Modulo

Order of operations:

*,/
+,-
>,>=,<,<=,=,<>
OR
AND

() -> Parentheses will force an operation to perform earlier in the order.

Booleans in Value based Formulas (unsupported):

Placing a Boolean expression inside parentheses will return -1 for True or 0 for False when it is part of a larger value based formula.
Placing a Boolean expression inside an ABS() function will return 1 for True or 0 for False when it is part of a larger value based formula.

You may wish to review the following:

How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!

Hi, i'm still quite new to PCF's, i've watched all the videos. i have written a PCF for price closing below the 50 sma and above the 200sma. i also want the scan to indicate a stochastic of 3,2,3 crossing down through 20

so far i have C < AVGC50 AND C1 > AVGC50.1 AND C > AVGC200 AND STOC3.2.1 > 20 AND STOC3.2 <=20

not sure if i'm stringing it all together.

i would also like to be able to produce a formula for the day's low crossing below the 50sma and closing above (effectively a hammer)

any pointers?? kind regards. James

hi i am hassan and i am writting an expert.
please help me.
i wrote function to find candle stick patterns and return those code to program.
my problem is:

   //----------}}}}} Test for Bullish RISING THREE METHODS pattern.

   double AVGH21_4=iMA(Active_Symbol,0,21,0,MODE_SMA,PRICE_HIGH,4);
   double AVGL21_4=iMA(Active_Symbol,0,21,0,MODE_SMA,PRICE_LOW,4);

   double AVGH21_0=iMA(Active_Symbol,0,21,0,MODE_SMA,PRICE_HIGH,0);
   double AVGL21_0=iMA(Active_Symbol,0,21,0,MODE_SMA,PRICE_LOW,0);

   if ((C4>O4) && (H4_-L4)>(AVGH21_4-AVGL21_4) && C2<C3 && C1<C2 && C3<H4_
        && C3>L4 && C2<H4_ && C2>L4 && C1<H4_ && C1>L4 && MathAbs(C3-O3)<=MathAbs(C4-O4)*0.75
        && MathAbs(C2-O2)<= MathAbs(C4-O4)*0.75 && MathAbs(C2-O2)<= MathAbs(C4-O4)*0.75 && C>O &&
        (H_-L)>(AVGH21_0-AVGL21_0) && C>C4)
      {
         code=853;
      }

is my code correct ?
i use ima to calculate AVGx pcs in mq4 , is this correct?
please help me.
tnx yo a lot.
hassan

I am not familiar with the language used in mq4 and can only guess at the intent of of the supplied code. My best guess at a Condition Formula in TC2000 would be:

L4 < C1 AND C1 < C2 AND C2 < C3 AND C3 < H4 AND O4 < C4 AND C4 < C AND O < C AND ABS(C3 - O3) <= (C4 - O4) * .75 AND ABS(C2 - O2) <= C4 - O4 * .75 AND H - L > AVGH21 - AVGL21 AND H4 - L4 > AVGH21.4 - AVGL21.4

Boolean PCFs for Candlestick Patterns

AVGCx.z -> Simple Moving Average of Close/Last Price
 

does the     dot(AVGCx.z) extend periods like such   c1.c59 would indicate close/last of yesterday to 60 days ago?

c1.c59 doesn't mean anything.

C1 would be the close of 1-bars ago.

C59 would be the close of 59-bars ago.

C60 would be the close of 60-bars ago.

AVGC1.59 would be the 1-period simple moving average of 59-bars ago (the same as C59).

AVGC10.60 would be the 10-period simple moving average of 60-bars ago.

Bruce,

How do I generate ' the Minimum of the average of a parameter' or ' the Maximum of the average of a parameter'?

Thanks

There is no built in way of doing so unless the moving average is built into whatever is being averaged. This is because the MIN() and MAX() functions cannot accept compound formulas as arguments.

So you can calculate the 4-period minimum of the 3-period simple moving average of TSV for example:

MIN(TSV3,4)

But there is no built in way to do the same for a 3-period exponential moving average because the following syntax is not valid:

MIN(XAVG(TSV,3),4)

If the period is 32 or less, you can use the techniques in the Min Max PCFs topic for this however.

(XAVG(TSV,3) + XAVG(TSV1.1,3) - ABS(XAVG(TSV,3) - (XAVG(TSV1.1,3))) + XAVG(TSV1.2,3) + XAVG(TSV1.3,3) - ABS(XAVG(TSV1.2,3) - (XAVG(TSV1.3,3))) - ABS(XAVG(TSV,3) + XAVG(TSV1.1,3) - ABS(XAVG(TSV,3) - (XAVG(TSV1.1,3))) - (XAVG(TSV1.2,3)) - (XAVG(TSV1.3,3)) + ABS(XAVG(TSV1.2,3) - (XAVG(TSV1.3,3))))) / 4

Hi Bruce,

Is there any sequencing as to look for things involving DATES ie specific days of the year.? 

thanx

The date replaces the bars ago parameter (z in the list of syntax in the first post). If there is a . in the syntax, it is required, but you shouldn't put a . in if it isn't part of the syntax. For example:

C'12/09/2013'

Would access the closing price on December 9, 2013 and doesn't have a . in it, but:

MAXH7.'12/09/2013'

Does have a period in it because there is normally a . in between the period of the maximum high and its bars ago parameter.

Bruce,

How can I create a PCF of the Average Trading Range over 14 days?

Thanks,

Brian

If you just want the average range of each trading day.

AVGH14 - AVGL14

But if you want Average True Range (which includes the close of the previous bar in the range to account for gaps), you would want to use the 14-Period Simple Moving Average of True Range from the following topic.

Please provide a description and PCF for calculating an ATR value to be used as a stop loss value

How to write a PCF that will draw a line 6% below the closing price?

Add a Custom PCF Indicator to the chart with the following settings:

- Period: 1
- Average Type: Simple
- Formula: 0.94 * C

How do I add the custom PCF to the top price window, so that I see the equation line, the 94% line, with the price chart?

I'm actually in vs. 12.4

You can click on Price History (the symbol and company name at the top of the pane where price is plotted) and select Add Plot Here... to add a plot to price pane directly.

You could also just select Add Plot to Chart (the green + in the upper left of the chart) and select Custom PCF Indicator to add it in its own pane. Then click on the move icon (an arrow pointing both up and down) to the left of the indicator and select Overlay & Scale With in the price pane.

Indicator Scaling (2:38)
Price Scaling (5:46)
Adding and Moving Indicators (7:19)

Hi,

Is it possible to get the number of candles since the open of the day (in any timeframe)

or to get the duration since the open, or simply the actualy time ?

Thanks for advance.

No, there is no way to determine either thing in a PCF currently.

Hey folks

is that the right PCF for 3-6MACD<3-6MACD 1 bar ago ?

XAVGC3-XAVGC6<XAVGC3.1-XAVGC6.1

Thanks, 

Boyko

Yes, it is the correct formula. There is a slightly shorter way to write this in the TC2000 v17 beta.

MACD3.6 < MACD3.6.1