| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 3/15/2006
Posts: 12
|
Is there anyway to create a PCF to track stocks that start having double top/bottom trend ?
Thanks,
Quoc Pham
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Over what time frame do you want the double top/bottom to form? Last 21 days? 10 days?
Give me a time frame and I will write something up for you.
- Craig
Here to Help!
|
|
Registered User
Joined: 3/15/2006
Posts: 12
|
The time frame is 2 months.
Thanks,
Quoc Pham
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Try this for me:
Watch this short video:
How to create a Personal Criteria Forumula (PCF)
Now create these two PCFs:
2-month Tops
100*MAXH21/MAXH21.21
2-month Bottoms
100*MINL21/MINL21.21
Now watch this short video:
Using EasyScan to find stocks that meet your own criteria
You will create two EasyScans with the following conditions and limits:
2-month Double Tops
WatchList: ALL STOCKS
Price per Share (Limit based on VALUES that meet your price range - as seen in the above video)
Volume 90-day (Limit based on the volume requirements you have - as seen in the above video)
Price Percent Change 26-weeks (MARKET RANK: 70 to MAX)
2-month Tops (VALUE: 97 to 103)
2-month Double Tops
WatchList: ALL STOCKS
Price per Share (Limit based on VALUES that meet your price range - as seen in the above video)
Volume 90-day (Limit based on the volume requirements you have - as seen in the above video)
Price Percent Change 26-weeks (MARKET RANK: MIN to 30)
2-month Bottoms (VALUE: 97 to 103)
You should now have two lists that you can flip through easily with your spacebar. Not every stock will look like a double top/bottom but you should find a few nice candidates in the lists.
- Craig
Here to Help!
|
|
Registered User
Joined: 3/7/2006
Posts: 9
|
Hi - I'm still learning the product, so working on some basic 'how to's'. First, in the formula above, 100*MaxH21/MaxH21.21, what does the MaxH21.21 represent. I thought that (eg.,) MaxH10.20 would represent the high for the time period 10 days ago to 20 days ago, is this correct?? If so, what's the purpose of MaxH21.21 (same day?)
Also, the example uses 21 days to represent 2 months. Seems like 2 months would be 5 days times 8 weeks; how do we calculate this??
Lastly, is there anyplace where this type of info is documented??
Many thanks.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
B4invest,
In MAXHx.y:
x = Period over which to find the Maximum Value.
y = Periods ago that Max Period ended.
The average month is actually slightly longer than 4 weeks and comes out to about 21 Trading Days. The 21-Periods in the formula actually represent a single month. The 2-month Tops and 2-month Bottoms formulas compare the Highs and Lows of the current month to the Highs and Lows of the previous month.
You may be interested in the following:
Handy PCF example formulas to help you learn the syntax of PCFs!
Personal Criteria Language
Personal Criteria Language Function List
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 5/17/2006
Posts: 493
|
Thanks craig, I'm assuming for 2 weeks, it would change from...
2-month Tops
100*MAXH21/MAXH21.21
2-month Bottoms
100*MINL21/MINL21.21
to
2-month Tops
100*MAXH5/MAXH5.5
2-month Bottoms
100*MINL5/MINL5.5
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Bingo!
- Craig
Here to Help!
|
|
Registered User
Joined: 5/17/2006
Posts: 493
|
craig,
the above gives me a error when I try to plug it in to the percent true, can you fix it to mimick a boolean if it's not already
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
In order for a formula to be Boolean it must contain > or < or <> or =.
The above conditions are not Boolean.
You will have to decide the number you want each to be less than. I would try building the scan as directed above and not e the values for each that you would allow.
- Craig
Here to Help!
|
|
 Gold Customer
Joined: 1/6/2005
Posts: 19
|
Thanks Craig!! yes lets do a 20 day top-thx
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Check out the form of the PCF:
2-month Tops
100*MAXH21/MAXH21.21
Change the 21s to half your desired period.
Your desired period is 20 days.... change the 21s to 10s.
- Craig
Here to Help!
|
|
|
Guest-1 |