Is this the best way to write a PCF where stock is not up 3 days in a row or not open more then 2% for last 3 days    MaxH3<1.02

Negative day or narrow range day < 2% 

MAXH3 < 1.02 would be checking for the highest price over the most recent three bars being less that $1.02.

Not up for at least three bars in a row would be:

TrueInRow(C <= C1, 3) = 3

Having a bar with a range of less than or equal to 2% for at least three bars in a row would be:

TrueInRow(H <= 1.02 * L, 3) = 3

Having a bar with a true range of less than or equal to 2% for at least three bars in a row would be:

TrueInRow(ATR1 <= .02 * LEAST(L, C1), 3) = 3

High of current bar is less than or equal to 2% above the previous close for at least 3 bars in a row

TrueInRow(H <= 1.02 * C1, 3) = 3

Thank you!

I am getting a Formula error    Error in Formula  Unmatched Parentheses At position 7

Bruce ,

I found my mistake I had to leave TrueInRow  as part of formula

TY again

You're welcome. I am happy to read you were able to figure it out on your own.

Hi

I'm trying to write a formula to compare EV vs capitalization.  Have gone through a lot of things online and can't find what symbols to use for these.

Basically want EV/Mkt Cap ratio as low as possible--down to 1 or even lower.

Thoughts?

thanks

Greg

There isn't a way to include fundamentals in formulas, but you could plot Enterprise Value and Capitalization in the same pane and scale on the charts. Then click on Enterprise Value and select Create Condition (or Create Scan Condition) to create a condition for the Enterprise Value being Below Capitalization.