| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
 Gold Customer
Joined: 10/3/2011
Posts: 2
|
Hello,
Craig posted on july 6, 2007 the formula to calculate the length of wicks. (ABS(C>=O)*(H-C))+
(ABS(C<O)*(H-O))
Is there a way to calculate the average wick length over a certain number of days, say 50?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Note that the formula given is specifically for the upper wicks. The easist way to calculate the average would be to use the formula as the Formula in a Custom PCF Indicator.
You can then set the Period and Average Type of the Custom PCF Indicator as desired. For example, if you wanted a 50-period simple moving average, set the Period to 50 and the Average Type to Simple.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Gold Customer
Joined: 10/3/2011
Posts: 2
|
Thanks Bruce,
Didn't think of that. Works great.
Nat
|
|
Registered User
Joined: 12/18/2004
Posts: 89
|
Bruce,
How about the PERCENTAGE of the body relative to the whole bar over, say 30 days? Trying to sort or scan for stocks that tend to wick less.
ABS((O-C)/(H-L))*100 is all I have at this point.
Thanks
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Your formula is just fine for a single bar. So you could do something similar to what I recommended for tamia and use it as the Formula in a Custom PCF Indicator. Then set the Period of the Custom PC Indicator to 30.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/18/2004
Posts: 89
|
Worked Great!.. Thanks Bruce..
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |