Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

ATR (x) divided by ATR (y) quotient value displayed in watchlist Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Trittrot
Posted : Tuesday, November 1, 2016 11:11:46 AM
Registered User
Joined: 10/28/2012
Posts: 6

is it possible to have the quotient of slow moving ATR divided by fast moving ATR displayed in a watchlist? I fully appreciate its perfectly straightforward to show individual ATR values in a watchlist, but is my specific request possible?

Any help appreciated

Thxs.

Bruce_L
Posted : Tuesday, November 1, 2016 11:35:31 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

What periods do you want to use and is this question actually about StockFinder or are you interested in doing this in TC2000?



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Trittrot
Posted : Tuesday, November 1, 2016 11:43:02 AM
Registered User
Joined: 10/28/2012
Posts: 6

Firstly I posted my question to the wrong forum as I'm looking to do this in TC 2000.  The periods  I'm interested in are 5 and 40

thxs

Bruce_L
Posted : Tuesday, November 1, 2016 12:14:44 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

The ratio of the 40 period to 5 period ATR can be written as follows.

((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) / ((AVGH5 - AVGL5) / 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)) / 10)

Create PCF Formula
5 day Average True Range



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Trittrot
Posted : Tuesday, November 1, 2016 12:29:22 PM
Registered User
Joined: 10/28/2012
Posts: 6

Just the job, works perfectly thankyou Bruce, much appreciated

Bruce_L
Posted : Tuesday, November 1, 2016 12:31:15 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.