Can you assist in helping me layout a PCF for the following Criteria:

1. TSV over 18 days is moving up slowly
2. TSV is within 5% of crossing it's 15day moving avg

Is the TSV Simple or Exponential?

What is the period of the TSV?

Is the Moving Average Simple or Exponential?

I have no idea what "moving up slowly" means. I know you are probably going to say, just like the Moving Up - Smart setting. But I don't know how that is calculated. I can check for a TSV to be up during the current bar when compared to 18-bars ago, but I can't check for "slowly".

It should probably also be noted that being within 5% of the Moving Average of TSV might be a fairly meaningless concept as both TSV and its Moving Average can cross through zero. I can probably create some math for it, but I'm not sure how useful it will be.

Thanks for the reply.

I am trying to find stock candidates where TSV is moving up and about to cross its EMA. I am a gold user using daily bars.

I am using the built in easy scan function to find candidates that have crossed its EMA. But these stocks have already broke out at this point. I am trying to find them a few days earlier.

Any suggestions.........................

The trainers can't give setting, interpretation or investment advice.

You could try checking for TSV and its Moving Average to be within 5% of each other where the percentage is of TSV's total range over some arbitrary period of time. That said, while the range of a Simple TSV can be calculated, the formula for the range of an Exponential TSV is too long to be practical.

I would still need to know your settings to be able to help you create a Condition Formula.

As stated in my previous reply, the formula for the range of an Exponential TSV is too long to be practical.

We could substitute the range of the Simple TSV 18 over the say the past 30 bars when calculating your 5%. If we did so, the formula for the 18-Period Exponential TSV being within 5% of the range of the 18-Period Simple TSV over the most recent 30-bars of its own 12-Period Exponential Moving Average could be written as:

11 * ABS(XAVG(TSV,12) - XAVG(TSV,18)) / 6 <= .05 * (MAX(TSV18,30) - MIN(TSV18,30))

If you specifically want the 18-Period Exponential TSV to be below its 12-Period Exponential Moving Average and moving up towards the 12-Period Exponenital Moving Average, the formula could be written as:

XAVG(TSV,12) < XAVG(TSV,18) AND XAVG(TSV,18) > XAVG(TSV1.1,18) AND 11 * ABS(XAVG(TSV,12) - XAVG(TSV,18)) / 6 <= .05 * (MAX(TSV18,30) - MIN(TSV18,30))

It should be noted that 5% of the total range is rather small. The TSV might move more than 5% when it crosses through its Moving Average. You might want to consider expanding this somewhat if you are not finding candidates before they cross.

For example, if you wanted 10% of the range instead of 5% of the range, you would change the .05 in the formula to a .1 instead.

We can only create Conditions for things that have happened. Not things that will happen.