Greetings:

I'm trying to figure out how to express the idea of the PPO value today being less than any other PPO bar at a given interval, for example, 150 days. I've been trying to apply the "MAX ...(,150)" language, but it's not working for me.

I wonder if you can help me out with this.

The formula for PPO is:

(XAVCG9 - XAVGC26) / XAVGC26 > (XAVGC9 - XAVGC26) / XAVGC26

You really aren't going to be able to do this with a formula because it would be too long and slow.

What you can do instead is add a Donchian Channel to the Price Percent Oscillator (PPO) indicator with the Period set to 150 and the Offset set to 1.

How to add an indicator to a chart template
How to edit an Indicator

Then click on the Donchian Channels indicator and select Create Scan Condition to create a condition for Below Chan Bottom in the Price Percent Oscillator vs Donchian Channels section of the Condition drop-down menu in the Create Scan Condition window.

Create Conditions from Your Chart (5:25)

Hi Bruce,

That's super. Would the Donchian channel generally work that way also with other indics? I'm thinking of TSI (true strength).

Thanks

Al

It should work with most indicators including the True Strength Index (TSI) indicator.

Kind thanks.

You're welcome.