## New version 18 available now

Subscription & data-feed pricing Class schedule

Margin rates Stock & option commissions

 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,759

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

Joined: 10/7/2004
Posts: 783

# 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.

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

Joined: 10/7/2004
Posts: 783

Did I miss the response to my quiry?

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

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

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

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

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

Joined: 10/7/2004
Posts: 783

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

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

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

Updated previous post.

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

Joined: 10/7/2004
Posts: 783

Thank you for your prompt response!

Users browsing this topic
Guest-1

 Forum Jump Customer Training & Support - Ask a Trainer - TC2000 version 12/18 - Ask a Trainer - TC2000 version 7 - Ask a Trainer - StockFinder 5.0 - PCFs, EasyScan and Custom Indicators General Discussions - Stock and Market Talk - TC2000 version 12 or 18 - TC2000 version 7 - StockFinder 5.0 - RealCode for StockFinder 5.0 Tutorial Videos - TC2000 version 12 tutorial videos - TC2000 version 7 tutorial videos 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.