Registered User Joined: 7/5/2009 Posts: 191

100 * (C1  C22) / C22) <= 10 AND 100 * (C1  C11) / C11) <= 10
vs.
100 * (C1  MINC22) / MINC22) <= 10 AND 100 * (C1  MINC11) / MINC11) <= 10
Thanks!


Administration
Joined: 9/30/2004 Posts: 9,187

The first uses the Close 22 and 11 days ago. The second uses the Minimum Close over the preceding 22 and 11 days.


Registered User Joined: 7/5/2009 Posts: 191

So the first PCF starts from the close 22 days ago, whereas the second PCF starts from yesterday going back 22 days or do they both start from yesterday going back 22 days?


Registered User Joined: 7/5/2009 Posts: 191

Also is there an advantage of one vs. the other?
How would the meaning change if I joined the two PCF's with OR vs AND?


Worden Trainer
Joined: 10/7/2004 Posts: 65,138

daledalmada,
The difference is that C22 is just the Close of 22Bars Ago (C22 doesn't care what the Close has been since 22Bars Ago) while MINC22 is the lowest Close over the most recent 22Bars.
So the formula using C22 actually uses slightly older data than MINC22 since C22 is 22Bars Ago while MINC22 only looks at the lowest Close from the current Bar through 21Bars Ago.
Bruce Personal Criteria Formulas TC2000 Support Articles


Registered User Joined: 7/5/2009 Posts: 191

Stock can have less than 10% growth in last 10 and 21 days but can recover from such correction and be up more than 10% in last 10 and 21 days. As a consequence it will be overextended on 10 and 21 day time frame. To avoid such situation we have additional condition about 10 day and 21 day momentum (The PCF being discussed). Together, the 21 and 10 day conditions ensure we have a stock with less than 10% move in last 20 and 10 days.
Given the above description, which of the PCF's would be best suited for this Bruce?


Worden Trainer
Joined: 10/7/2004 Posts: 65,138

daledalmada,
The trainers can't give setting, interpretation or investment advice.
100 * (C1  C22) / C22) <= 10 AND 100 * (C1  C11) / C11) <= 10
Basically looks for the Price Percent Change between yesterday and both 22 and 11 Bars Ago to be less than or equal to 10%
While:
100 * (C1  MINC22) / MINC22) <= 10 AND 100 * (C1  MINC11) / MINC11) <= 10
Looks for the Price of yesterday to be less than or equal to 10% above the lowest Close during both the last 22 and 11 Bars. You would get the same results using only the first portion of this second version:
100 * (C1  MINC22) / MINC22) <= 10
Bruce Personal Criteria Formulas TC2000 Support Articles


Registered User Joined: 7/5/2009 Posts: 191

Thanks!


Worden Trainer
Joined: 10/7/2004 Posts: 65,138

daledalmada,
You're welcome. Our pleasure.
Bruce Personal Criteria Formulas TC2000 Support Articles


Registered User Joined: 7/5/2009 Posts: 191

Hi Bruce,
I had just one more question on this. Would these two PCF's yield the exact same result:
100 * (C1  MINC22) / MINC22) <= 10
100 * (C1  MINC22) / MINC22) <= 10 OR 100 * (C1  MINC11) / MINC11) <= 10
If not, how are they different? Thanks!


Worden Trainer
Joined: 10/7/2004 Posts: 65,138

daledalmada,
One thing we know about about 100 * (C1  MINC22) / MINC22) <= 10 and 100 * (C1  MINC11) / MINC11) <= 10 is that MINC22 will always be less than or equal to MINC11 because the most recent 11 Bars are a part of the most recent 22 Bars. Another thing we know is Price is always positive for real stocks.
This means 100 * (C1  MINC22) / MINC22) is always greater than or equal to 100 * (C1  MINC11) / MINC11).
If 100 * (C1  MINC22) / MINC22) is less than or equal to 10, then 100 * (C1  MINC11) / MINC11) must also be less than or equal to 10. So if:
100 * (C1  MINC22) / MINC22) <= 10
Then:
100 * (C1  MINC22) / MINC22) <= 10 AND 100 * (C1  MINC11) / MINC11) <= 10
It is possible for 100 * (C1  MINC11) / MINC11) to be less than or equal to 10 without 100 * (C1  MINC22) / MINC22) being less than or equal to 10 however. With this in mind, it would appear logical that if:
100 * (C1  MINC11) / MINC11) <= 10
Then the following must be True:
100 * (C1  MINC22) / MINC22) <= 10 OR 100 * (C1  MINC11) / MINC11) <= 10
Bruce Personal Criteria Formulas TC2000 Support Articles


Registered User Joined: 1/1/2005 Posts: 2,645

daledalmada,
Stronger statements than those given by Bruce can be made.
If a stock has sufficient data to calculate all of the following PCFs, then:
1.
100 * (C1  MINC22) / MINC22) <= 10
is equivalent to
100 * (C1  MINC22) / MINC22) <= 10 AND 100 * (C1  MINC11) / MINC11) <= 10
2.
100 * (C1  MINC11) / MINC11) <= 10
is equivalent to
100 * (C1  MINC22) / MINC22) <= 10 OR 100 * (C1  MINC11) / MINC11) <= 10
Please notice that if a stock declines more than 9.1% today, it will fail both tests. It was probably intended that C1 above be C.
Thanks,
Jim Murphy


Worden Trainer
Joined: 10/7/2004 Posts: 65,138

QUOTE (bustermu) Please notice that if a stock declines more than 9.1% today, it will fail both tests. It was probably intended that C1 above be C.
Another possibility (assuming the formula as given was not intended) would be that MINC22.1 was intended instead of MINC22 and MINC11.1 was intended instead of MINC11.
Bruce Personal Criteria Formulas TC2000 Support Articles


Guest1 