| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 3/22/2005
Posts: 9
|
Any thoughts on a scan or personal critera formula that would display stocks that have a base.
I was thinking of something that would reflect a 3 to 5 month base. Preferably, with an upward bias.
I guess a starting point could be P < (P*1.05)
P > (P*.95)
P10 < (P*1.05)
P10 > (P*.95)
P20 < (P*1.05)
P20 > (P.95)
P30 etc.....
P50 etc....
P80 etc...
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The trainers can't really suggest what formulas you might use, but we can help you create formulas based on your unambiguous objective descriptions of what you want. The example pseudo-formula you gave would seem to provide exactly the sort of objective starting point required.
Assuming the P without a Days Ago parameter always represents the current Closing Price in the above formula and the number after a P is in fact a Days Ago parameter, I would think this could be written for a base of at least 3 months using the following:
C * .95 < MINC63 AND MAXC63 < C * 1.05
If you wanted the same thing for at least 5 months, you could use the following instead:
C * .95 < MINC105 AND MAXC105 < C * 1.05
Neither of these formulas would contain any sort of upward bias. You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
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: 3/22/2005
Posts: 9
|
Thank you for the quick response. This should get me started, I will inform you with any other questions.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 3/22/2005
Posts: 9
|
I tried it and it actually did not work.
I will try something else if anything comes to mind please it could be a powerful scan for all.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I've made some changes to my Wednesday, April 01, 2009 2:58:50 PM ET post. See if you like the results of the altered versions better.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 3/22/2005
Posts: 9
|
Nice try but I figured it out
MINC84 > MAXC84 * .925 AND MAXC84 < MINC84 * 1.075
whatcha think smart guy
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
It doesn't incorporate all of the Closes during the Period being within 5% of the current Close as was suggested in your Wednesday, April 01, 2009 1:32:48 PM ET post, but it is a lovely formula that will return True whenever the highest Close over the last 4-Months (84-Trading Days) is less than 7.5% above the lowest Close over the same Period. You only need half of it your since the first half:
MINC84 > MAXC84 * .925
Will always be True when the second half is True:
MAXC84 < MINC84 * 1.075
The reverse is not the case. This means you can just use the second half of the formula.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 3/22/2005
Posts: 9
|
So I guess both formulas are saying the same thing. Giving the same result.
I was hopeing this would create and seems to create a 7.5% price band for 84 days.
neverless I think we are closer, thanks for any other input Bruce
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You have successfully created a formula for a maximum 7.5% closing price band for 84 trading days where the 7.5% is of the lowest close during the period.
The reason the first and second halves of the formula aren't the same and that the second half is more restrictive is that the first half is basing its 7.5% on the highest closing price while the second half is basing its 7.5% on the lowest closing price. This means the second half of the formula will always be defining a band that is the same as or narrower than the first half of the formula (and with an actively trading stock will almost always be narrower).
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |