Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

What's the difference between these two PCF's? Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
daledalmada
Posted : Thursday, June 10, 2010 12:42:46 PM
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!
StockGuy
Posted : Thursday, June 10, 2010 12:44:11 PM

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.

daledalmada
Posted : Thursday, June 10, 2010 12:55:24 PM
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?
daledalmada
Posted : Thursday, June 10, 2010 1:00:30 PM
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?
Bruce_L
Posted : Thursday, June 10, 2010 1:01:15 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
daledalmada,
The difference is that C22 is just the Close of 22-Bars Ago (C22 doesn't care what the Close has been since 22-Bars Ago) while MINC22 is the lowest Close over the most recent 22-Bars.

So the formula using C22 actually uses slightly older data than MINC22 since C22 is 22-Bars Ago while MINC22 only looks at the lowest Close from the current Bar through 21-Bars Ago.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
daledalmada
Posted : Thursday, June 10, 2010 1:11:34 PM
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?
Bruce_L
Posted : Thursday, June 10, 2010 1:25:21 PM


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
daledalmada
Posted : Thursday, June 10, 2010 1:29:22 PM
Registered User
Joined: 7/5/2009
Posts: 191
Thanks!
Bruce_L
Posted : Thursday, June 10, 2010 1:30:12 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
daledalmada,
You're welcome. Our pleasure.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
daledalmada
Posted : Thursday, June 10, 2010 5:53:21 PM
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!

Bruce_L
Posted : Friday, June 11, 2010 7:21:28 AM


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
bustermu
Posted : Friday, June 11, 2010 9:38:22 AM
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
Bruce_L
Posted : Friday, June 11, 2010 9:48:33 AM


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
Users browsing this topic
Guest-1

Forum Jump
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.