PMO Min or MAX??

8Asteroids8

I use MIN and MAX statements regularly in my formula. Today am trying to nail a formula to experiment with MIN or MAX for PMO LINE? I have no idea how to do it. I've tried variations but nothing works... Examples: "AND [PMO Line(35,20,10) MAX(40, ??) > 5]" where I've put all kinds of statements and integers where you see the "??". I've tried variations with just PMO but even then I have no idea what to put in place of my "??". How would I write, for example, "PMO Line MAX less in past 40 days of less than 8" ? Thanks in advance.

markd

You want the max of PMO Line for the last 40 days to be less than 8.

To get the max of anything, you would use the generic form of the max function, and then plug in the parameters.

So the general form is

max(nPeriods, expression)

(see the Chart School article on functions: https://stockcharts.com/docs/doku.php?id=scans:functions

So for nPeriods you want 40, and for expression you want PMO Line(35,20,10)

So if you put 40 and PMO Line(35,20,10) inside the max( ) parentheses, you get

max(40, PMO Line(35,20,10))

Notice how there are TWO parentheses at the end: one for max( ) and one for PMO Line( ).

Now you want that expression to be less than 8, so:

and [max(40, PMO Line(35,20,10)) < 8]

Hope that helps.

8Asteroids8

Markd: you are brilliant, but you likely already know that. What you don't know is that I plan to build a shrine to you and bow to you every day at noon. THANK YOU SO VERY MUCH. You rock.

markd

Thanks for the kind words

SCAlchemist

Many of us share 8Asteroids8 sentiment !

markd

Thanks, brother.