Hello, TC team

I want to create a simple indicator to sort my lists and possibly create a scan out of.  Price/ATR Ratio

Current Stock Price divided by ATR 40 (Daily Bars)

For example if stock price closed at $100 and had an ATR 40 of $2 I would get a result of  50

Thank You

Please try the following Indicator Formula.

C / ((AVGH40 - AVGL40) / 2 + (ABS(H - C1) + ABS(C1 - L) + ABS(H1 - C2) + ABS(C2 - L1) + ABS(H2 - C3) + ABS(C3 - L2) + ABS(H3 - C4) + ABS(C4 - L3) + ABS(H4 - C5) + ABS(C5 - L4) + ABS(H5 - C6) + ABS(C6 - L5) + ABS(H6 - C7) + ABS(C7 - L6) + ABS(H7 - C8) + ABS(C8 - L7) + ABS(H8 - C9) + ABS(C9 - L8) + ABS(H9 - C10) + ABS(C10 - L9) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13) + ABS(H14 - C15) + ABS(C15 - L14) + ABS(H15 - C16) + ABS(C16 - L15) + ABS(H16 - C17) + ABS(C17 - L16) + ABS(H17 - C18) + ABS(C18 - L17) + ABS(H18 - C19) + ABS(C19 - L18) + ABS(H19 - C20) + ABS(C20 - L19) + ABS(H20 - C21) + ABS(C21 - L20) + ABS(H21 - C22) + ABS(C22 - L21) + ABS(H22 - C23) + ABS(C23 - L22) + ABS(H23 - C24) + ABS(C24 - L23) + ABS(H24 - C25) + ABS(C25 - L24) + ABS(H25 - C26) + ABS(C26 - L25) + ABS(H26 - C27) + ABS(C27 - L26) + ABS(H27 - C28) + ABS(C28 - L27) + ABS(H28 - C29) + ABS(C29 - L28) + ABS(H29 - C30) + ABS(C30 - L29) + ABS(H30 - C31) + ABS(C31 - L30) + ABS(H31 - C32) + ABS(C32 - L31) + ABS(H32 - C33) + ABS(C33 - L32) + ABS(H33 - C34) + ABS(C34 - L33) + ABS(H34 - C35) + ABS(C35 - L34) + ABS(H35 - C36) + ABS(C36 - L35) + ABS(H36 - C37) + ABS(C37 - L36) + ABS(H37 - C38) + ABS(C38 - L37) + ABS(H38 - C39) + ABS(C39 - L38) + ABS(H39 - C40) + ABS(C40 - L39)) / 80)

Help with Morales / Kacher Gap-up ATR Test

Thanks for the fast response Bruce,

When I do the calculation by, hand Im coming up with different outcomes. For Example RMD closing price of 65.27/ATR 40 0n the daily chart coming out to 45.643 the formula you gave me comes up with 53.85. Is it calculating something different than I am.? When I used it the first time they were coming within decimal points of each other, than I shut the system down and restarted it and now it gives me completley different results.

Just the denominator of the formula matches the 40-period ATR on the chart exactly.

((AVGH40 - AVGL40) / 2 + (ABS(H - C1) + ABS(C1 - L) + ABS(H1 - C2) + ABS(C2 - L1) + ABS(H2 - C3) + ABS(C3 - L2) + ABS(H3 - C4) + ABS(C4 - L3) + ABS(H4 - C5) + ABS(C5 - L4) + ABS(H5 - C6) + ABS(C6 - L5) + ABS(H6 - C7) + ABS(C7 - L6) + ABS(H7 - C8) + ABS(C8 - L7) + ABS(H8 - C9) + ABS(C9 - L8) + ABS(H9 - C10) + ABS(C10 - L9) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13) + ABS(H14 - C15) + ABS(C15 - L14) + ABS(H15 - C16) + ABS(C16 - L15) + ABS(H16 - C17) + ABS(C17 - L16) + ABS(H17 - C18) + ABS(C18 - L17) + ABS(H18 - C19) + ABS(C19 - L18) + ABS(H19 - C20) + ABS(C20 - L19) + ABS(H20 - C21) + ABS(C21 - L20) + ABS(H21 - C22) + ABS(C22 - L21) + ABS(H22 - C23) + ABS(C23 - L22) + ABS(H23 - C24) + ABS(C24 - L23) + ABS(H24 - C25) + ABS(C25 - L24) + ABS(H25 - C26) + ABS(C26 - L25) + ABS(H26 - C27) + ABS(C27 - L26) + ABS(H27 - C28) + ABS(C28 - L27) + ABS(H28 - C29) + ABS(C29 - L28) + ABS(H29 - C30) + ABS(C30 - L29) + ABS(H30 - C31) + ABS(C31 - L30) + ABS(H31 - C32) + ABS(C32 - L31) + ABS(H32 - C33) + ABS(C33 - L32) + ABS(H33 - C34) + ABS(C34 - L33) + ABS(H34 - C35) + ABS(C35 - L34) + ABS(H35 - C36) + ABS(C36 - L35) + ABS(H36 - C37) + ABS(C37 - L36) + ABS(H37 - C38) + ABS(C38 - L37) + ABS(H38 - C39) + ABS(C39 - L38) + ABS(H39 - C40) + ABS(C40 - L39)) / 80)

And when I run the numbers by hand, everything seems to line up on the formula with the C / in the front of it as well.

For RMD I currently have 64.34 / 1.196 = 53.79598662207358 on my calculator while the chart is coming out at 53.79604.

Note that 65.27 is the close for February 25, 2015 while 64.34 is the close for February 27, 2015. You might just be looking at the wrong date or not have the chart scrolled all the way to the right.

Bruce,

Silly me, I had a 2day chart up instead of the daily when the system restarted, now the calc is coming out right, thank you for your help and fast service.

You're welcome.