Hi,

How to write Price High for 6 weeks is below the zero line of 1,50,1 PPO.

Thanks!

I don't know of a way to check for price high for 6 weeks being below the zero line of the PPO because they are on different scales.

Checking for an exponential weekly PPO 1, 50 being below the zero line of the PPO for at least 6 weeks can be written as follows in TC2000 v17 (using a weekly time frame).

MAX(100 * (C / XAVGC50 - 1), 6) < 0

Or as follows:

100 * (MAX(C / XAVGC50, 6) - 1) < 0

Or as follows:

TrueInRow(C < XAVGC50, 6) = 6

This last version of the formula could be written as follows in earlier versions of TC2000, but converting the other forms would result in formulas which are too long and slow to be practical or post in the forums.

C < XAVGC50 AND C1 < XAVGC50.1 AND C2 <= XAVGC50.2 AND C3 < XAVGC50.3 AND C4 < XAVGC50.4 AND C5 < XAVGC50.5

If it is a daily time frame, then you would need to change the period used fro 6 to 30.

MAX(100 * (C / XAVGC50 - 1), 30) < 0

I didn't realize I created two topics!  But that worked like a charm.  Thanks Bruce!!

You're welcome.