Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
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
|
|
Registered User Joined: 2/9/2010 Posts: 46
|
Thank you Bruce.
|
|
Registered User Joined: 10/7/2004 Posts: 794
|
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!
|
|
Registered User Joined: 10/7/2004 Posts: 794
|
Did I miss the response to my quiry?
|
|
Administration
Joined: 9/30/2004 Posts: 9,187
|
No, you just posted about 2 hours ago so it hasn't been answered yet.
|
|
Administration
Joined: 9/30/2004 Posts: 9,187
|
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)
|
|
Registered User Joined: 10/7/2004 Posts: 794
|
Thank you Stock Guy how would this be presented for version 7 ?
|
|
Administration
Joined: 9/30/2004 Posts: 9,187
|
Updated previous post.
|
|
Registered User Joined: 10/7/2004 Posts: 794
|
Thank you for your prompt response!
|
|
Guest-1 |