Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

ADR Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Quiktdr
Posted : Saturday, December 15, 2018 1:29:06 PM
Registered User
Joined: 10/7/2004
Posts: 794
I am  trying to get the 5 day adr of the highest high and lowest low for the last five days but when I run this scan starting with  (MAXH3 - MINL3) I am not getting the incorrect  numbers. What am I doing wrong?
 
((MAXH1 - MINL1)+ (MAXH2 - MINL2)+ (MAXH3 - MINL3)+ (MAXH4 - MINL4)+
(MAXH5 - MINL5))/5  
 
and is this the same for  Vs 18
 
I tried ((AVGH1 -AVGL1) + (AVGH2 -AVGL2) + (AVGH3 -AVGL3)+ (AVGH4 -AVGL4)+ (AVGH5 -AVGL5)) /5 and the same hapens.
 
Thanks
Quiktdr
Posted : Saturday, December 15, 2018 3:30:21 PM
Registered User
Joined: 10/7/2004
Posts: 794

Is anyone answering inquiries today?

bcochrane
Posted : Saturday, December 15, 2018 4:44:26 PM
Registered User
Joined: 9/17/2010
Posts: 484

The forum is resourced during regular working hours, Monday - Friday.

By ADR do you mean Average True Range ATR?

I'm not clear from your description what you are after. "Highest High" is the Highest of the 5 days, which would be MaxH5. so you would be looking for (MaxH5-MinL5)/.

On the other hand, the PCF suggests looking for the average Candle height across the 5 days. ATR standard equation is Current High less the current Low, so ATR5 should yield the result you might be looking for. Why not use the built in formula?

Your PCF is summing the 1 day Range (MAXH1 - MINL1), the 2 day range (MAXH2 - MINL2) etc rather than the average of the individual days MaxH2 is the higher high of the last two days, not the High of two days ago

 

http://forums.worden.com/default.aspx?g=posts&t=66280

Hope this helps

 

Quiktdr
Posted : Saturday, December 15, 2018 4:50:06 PM
Registered User
Joined: 10/7/2004
Posts: 794

THANK YOU

 

Quiktdr
Posted : Sunday, December 16, 2018 11:55:47 AM
Registered User
Joined: 10/7/2004
Posts: 794

I have used the above formulae but it doesn't generate the true results and I am experiencing a Senior moment. It is simple the adr Average Daily Range is the highest high minus the lowest low divided by the # of days

The  attached range for the stock BZUN has a range of over $2 every day but when I use the results from the above formulas they come out to 1.25 and 1.96 which are incorrect. 

i am looking for the average range for the last 5 days I even tried ((H1 +L1) +(H2 +L2) +(H3 +L3) +(H4 +L4) + (H5 +L5))/5

BZUN 12/14 H 38.30 LOW 35.80, 12/13 38.69 36.75 , 12/12 37.85   35.65,  12/11   35.29   34.16,               12/10 34.35   32.42

 I am in a fog and know I am mssing something but...? and then I want to get a percentage (.625) of that ADR so that I can work within the anticipated range for an issue

bcochrane
Posted : Sunday, December 16, 2018 12:54:50 PM
Registered User
Joined: 9/17/2010
Posts: 484

Why can't you use ATR 5 built in Formula?

There is a difference mathematically between

  • the highest High minus the lowest Low of the past 5 days [in TC2000 (MaxH5-MinL5)/5] and
  • an average range  over 5 days which is the average of the range each day, divided by the number of days which is [almost] )    (H-L) + (H1-L1) +(H2-L2) - (H3-L3) + (H4-L4))/ 5. This might be the ADR you are looking for.
  • I say almost because the formula actually used for ATR is a bit more complex to account for down days. I'm not sure which exact calculation Worden uses, but you can read about the math behind ATR here https://stockcharts.com/school/doku.php?id=chart_school:technical_indicators:average_true_range_atr
Quiktdr
Posted : Monday, December 17, 2018 11:06:44 AM
Registered User
Joined: 10/7/2004
Posts: 794

I have suffered a stroke and I am mending so my question my seem elementary I apologize but could you please look at it.

TY

Bruce_L
Posted : Monday, December 17, 2018 11:31:23 AM


Worden Trainer

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

I do not understand the question. The use of ADR would seem to mean Average Daily Range. Over the previous 5 bars this would be written as follows in TC2000 v7 for the most recent 5 days including today.

(AVGH5 - AVGL5) / 5

Or as follows if it is the 5 trading days ending 1 trading day ago (so excluding the current bar).

(AVGH5.1 - AVGL5.1) / 5

The long version of the above would seem to be what you were trying to write in your Sunday, December 16, 2018 11:55:47 AM ET post (only the first and last parentheses are actually necessary).

((H1 - L1) + (H2 - L2) + (H3 - L3) + (H4 - L4) + (H5 - L5)) / 5

But your use of MAX and MIN makes me wonder if you are interested in the total range instead.

MAXH5 - MINL5

Or the folllowing if the current day is not included.

MAXH5.1 - MINL5.1

Dividing this total range by 5 would not result in the average daily range because the range of each trading day could overlap and/or gap.

(MAXH5 - MINL5) / 5

Or:

(MAXH5.1 - MINL5.1) / 5



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Quiktdr
Posted : Monday, December 17, 2018 11:58:46 AM
Registered User
Joined: 10/7/2004
Posts: 794

Thank You

I'm sorry for the confusion

Quiktdr
Posted : Monday, December 17, 2018 12:28:40 PM
Registered User
Joined: 10/7/2004
Posts: 794

bcochrane  Thanks for your input

Bruce_L
Posted : Monday, December 17, 2018 12:39: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.