Please help me set the following condition within a scan:

Exp Moving Average 50 of price history above Exp Mov Avg 100 of price history every day during the last X number of days.

I thought this is straight foward by using True within the last X bars in the Edit Condition window, but I get results that do not verify the condition. 

Thank you,

Corto

Try using the new PCF syntax in version 17:

TrueInRow(XAVGC50 > XAVGC100,50) = 50

Just set 50 and = 50 to X number of days.

I tried setting a new Condition (PCF) Formula and entered your formula but i keeps asking me to enter a formula. I'm doing something wrong. Please help.

Please try copying and pasting the formula into a text editor (such a Notepad and not a word processor like Word). Then copy and paste from the text editor into TC2000 instead of copying and pasting directly from the forums.

This was the trick. Thank you!

I seached and found where this TrueInRow syntax is explained and I realized what I wanted was my condition to be true for at least X number o days. In this case I can't figure out the formula. Please help again.

See the two 50s near the end of the formula in bold? Change those to different numbers to change X to something besides 50.

You want the first first formula.

TrueInRow(XAVGC50 > XAVGC100,75) = 75

The second formula would never return true because TrueInRow(XAVGC50 > XAVGC100, 75) returns an interegr between 0 and 75. So it can't be greater than 75.

TrueInRow(XAVGC50 > XAVGC100, 75) checks the most recent 75 bars and returns how many bars in a row this was true starting with the current bar. So if the current bar isn't true it will return 0. If the most recent 10 bars (including the current bar) are true but the 11th bar is not, then it would return 10.

So if you wanted to check for exactly 75 bars in a row, you would use the following.

TrueInRow(XAVGC50 > XAVGC100, 76) = 75

Because this would return an integer between 0 and 76 and if more than 75 bars in a row were true, then the formula would be false and if less that 75 bars in a row were true the formulas would also be false.

Still confused.

I need the condition satisfied for 75 or more days in a row in the past. 

You want the first first formula from your Friday, January 19, 2018 12:29:54 PM ET post.

TrueInRow(XAVGC50 > XAVGC100,75) = 75

Will this also bring the stock that satisfied the condition for the past 100 consecutice days?

Yes, it will. The formula has no idea what happened on bars 26 through 100. It is only checking for what happened during bars 1 through 75 (with 1 being current bar).

So as long as it was true 75 bars in a row, it doesn't matter if it was true exactly 75 bars in a row or 200 bars in a row, it will still return true.

Finally got it. Thanks a lot and sorry for all the hassle.

You're welcome.