New version 18 available now


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


New account application Trading resources
Margin rates Stock & option commissions

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

Average Daily Stock Range Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
alsbythelake
Posted : Friday, March 09, 2012 4:40:39 PM
Registered User
Joined: 2/9/2010
Posts: 46
Can you please help me with the formula for the following:--the 10 day average range of a stock is > .50 centsThank you,Al
Bruce_L
Posted : Friday, March 09, 2012 4:48:03 PM


Worden Trainer

Joined: 10/7/2004
Posts: 64,136
Please try the following:

AVGH10 - AVGL10 > .5

Indicators, Sorting & Scanning
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
alsbythelake
Posted : Friday, March 09, 2012 7:44:48 PM
Registered User
Joined: 2/9/2010
Posts: 46
Thank you Bruce.
Quiktdr
Posted : Tuesday, April 24, 2018 9:22:58 AM
Platinum Customer Platinum Customer

Joined: 10/7/2004
Posts: 759

 

How to best replicate this formula?  Does it start with (H-L)/2    etc  or do you use  ABS (H-L1)/2

 

Take any given stock and look at all the daily bars for the past 10 days. Next subt-act all the highs from all the lows to get all the daily ranges for each of the 10 daily bars and then calculate the average range for those ten days. Let's call this AVERAGE DAILY RANGE. Next divide each daily range by two to get the midpoint for each day. Now find the average midpoint for the 10 days. Let's call this AVERAGE MIDPOINT. Next take 125 % of the AVERAGE DAILY RANGE and add it to the AVERAGE MIDPOINT and that becomes our trading signal to buy tomorrow.

Thus we have created a signal using only two parameters, AVERAGE DAILY RANGE and AVERAGE MIDPOINT.

Thank you in advance!

Quiktdr
Posted : Tuesday, April 24, 2018 11:32:39 AM
Platinum Customer Platinum Customer

Joined: 10/7/2004
Posts: 759

Did I miss the response to my quiry?

StockGuy
Posted : Tuesday, April 24, 2018 11:33:47 AM

Administration

Joined: 9/30/2004
Posts: 9,129

No, you just posted about 2 hours ago so it hasn't been answered yet.

StockGuy
Posted : Tuesday, April 24, 2018 11:40:43 AM

Administration

Joined: 9/30/2004
Posts: 9,129

Average Daily Range: AVG(H-L,10)

Average Midpoint: AVG((H+L)/2,10)

Range * 1.25 + Midpoint: AVG((H+L)/2,10) + (AVG(H-L,10) * 1.25)

For version 7 you'll have to use: ((AVGH10+AVGL10) / 2) + ((AVGH10 - AVGL10) * 1.25)

Quiktdr
Posted : Tuesday, April 24, 2018 11:54:36 AM
Platinum Customer Platinum Customer

Joined: 10/7/2004
Posts: 759

Thank you Stock Guy how would this be presented for version 7  ?

 

 

StockGuy
Posted : Tuesday, April 24, 2018 12:00:38 PM

Administration

Joined: 9/30/2004
Posts: 9,129

Updated previous post.

Quiktdr
Posted : Tuesday, April 24, 2018 12:09:44 PM
Platinum Customer Platinum Customer

Joined: 10/7/2004
Posts: 759

Thank you for your prompt response!

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.