| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 11/1/2005
Posts: 78
|
Hello,
The following PCF is what I am running a scan for to try and pick up Stocks that meet the criterion of Bill Williams Alligator... Bruce has helped develop an Alligator for Price... I now want to scan for Stocks that meet the Signal...
PCF:
H > H1 AND H1 > H2 AND L > L1 AND L1 > L2 AND O > C AND C < ((H + L) / 2) AND AVGV50 > 10000 AND AVGC5.3 > AVGC8.5 AND AVGC8.5 > AVGC13.8 AND C >= 10 AND C <= 150 AND AVGC5 > AVGC5.3 AND AVGC8 > AVGC8.3
What I am trying to scan for are Stock prices that have Higher Highs and Higher lows for the last 3 days... Volume high and then I am trying to get the Price to have good angulation away from the Green line... I am using a Simple moving average for my PFC... Is there a way to have the scan mathch up more to the untire Alligator... Meaning the Green line is greater then the Red line and the Red line is greater then the Blue line... I hope this makes sense... If not I will have to try again...
Thanks,
Keith
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (kpnicholson) Is there a way to have the scan match up more to the entire Alligator... Meaning the Green line is greater then the Red line and the Red line is greater then the Blue line...
I won't comment on the rest of your formula at this point, but the reason the results don't match the Alligator Indicator is that you are using Simple Moving Averages of Price instead of Smoothed Moving Averages of the midpoint between the High and Low as is done in the Alligator Indicator (at least I think this is the version we decided actually matched):
AVGC5.3 should be:
(XAVGH9.3 + XAVGL9.3) / 2
AVGC8.5 should be:
(XAVGH15.5 + XAVGL15.5) / 2
AVGC13.8 should be:
(XAVGH25.8 + XAVGL25.8) / 2
So the portion testing for this should be:
XAVGH9.3 + XAVGL9.3 > XAVGH15.5 + XAVGL15.5 AND XAVGH15.5 + XAVGL15.5 > XAVGH25.8 + XAVGL25.8
If that meets your expectations, we can go from there.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 11/1/2005
Posts: 78
|
Hi Bruce,
When I try to calculate the formula I inserted on your suggestion... The formula will not calculate... So I know I must have something wrong with the way I entered the formula...
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Do you get an error message when you TEST the formula?
- Craig
Here to Help!
|
|
Registered User
Joined: 11/1/2005
Posts: 78
|
Hi Craig,
Here is the PCF I am trying to create...
H > H1 AND H1 > H2 AND L > L1 AND L1 > L2 AND O > C AND C < ((H + L) / 2) AND AVGV50 > 10000 AND
(XAVGH9.3 + XAVGL9.3) > (XAVGH15.5 + XAVGL15.5) AND (XAVGH15.5 + XAVGL15.5) > (XAVGH25.8 + XAVGL25.8)
AND C >= 10 AND C <= 150 AND AVGC5 > AVGC5.3 AND AVGC8 > AVGC8.3
When I test the PCF I get a Result: False "Market Days Needed to Calculate Criterion: 134...
Where do I go to understand these error messages...?
Thanks,
Keith
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The "Market Days needed to Calculate Criterion 134" message is informational and is not an error. It is just indicating the formula will not calculate for symbols with less than 134 days of data. You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 11/1/2005
Posts: 78
|
Hi Bruce,
The problem:
Even though there is no answer... When I update or login to Worden the PCF says "Not Calculated"... So I am always getting Zero for information... I agree with you regarding the PCF... I just do not know why I am Calculation Nothing...?
Thanks,
Keith
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Have you reviewed the first video I referenced? Have you tried calculating your Personal Criteria Formulas manually?
Select Databank | Personal Criteria Formulas.
Verify Calculate For is set to All Items in System.
Verify Include criteria which require more than 250 days of history (slower) is checked.
Select Update All Criteria.
If that doesn't work, verify that Do not update this criteria is not checked in the PCF itself.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 11/1/2005
Posts: 78
|
Hi Bruce,
I just now watched the video and looked at the given definitions on creating a PCF... Thanks...
I did recalculate all the PCF formulas by following your instructions... Thanks, it worked... The reason it did not calculate before... I just noticed my Box was not checked to do so in the "Update vie Network"...
Here are the two PCF's I am trying to create...
My Intention is for a Bearish setup, In English:
Todays High > Yesterday's High > day before
Todays Low > Yesterday's Low > day before
Volume last 50 days > 10000
Stock price > 20 < 150
Here is where I get a little confused:
Red line = Teeth
Green line = Lips
Blue line = Jaw
All = the Gator (as you know)
so,
Price > Green line
Green line > Red Line
Red line > Blue line
Do I have this correct in the following PCF...?
H > H1 AND H1 > H2 AND L > L1 AND L1 > L2 AND O > C AND C < ((H + L) / 2) AND AVGV50 > 10000 AND ((XAVGH9.3 + XAVGL9.3) / 2) > ((XAVGH15.5 + XAVGL15.5) / 2) AND ((XAVGH15.5 + XAVGL15.5) / 2) > ((XAVGH25.8 + XAVGL25.8) / 2) AND C >= 20 AND C <= 150
Thanks again for the help,
Keith
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (kpnicholson) Todays High > Yesterday's High > day before:
H > H1 AND H1 > H2
This part appears to be correct.
QUOTE (kpnicholson) Todays Low > Yesterday's Low > day before:
L > L1 AND L1 > L2
This part appears to be correct.
QUOTE (kpnicholson) Volume last 50 days > 10000:
AVGV50 > 10000
This would be the 50-Period Simple Moving Average of Volume is greater than 1000000 shares. Volume in TeleChart is quoted in blocks of 100 shares. If you mean that it cannot drop below this value, you would want to use MINV50 instead of AVGV50.
QUOTE (kpnicholson) Stock price > 20 < 150:
C >= 20 AND C <= 150
This differs only in the inclusion of equality in the actual formula.
QUOTE (kpnicholson) Price > Green line, Green line > Red Line, Red line > Blue line:
((XAVGH9.3 + XAVGL9.3) / 2) > ((XAVGH15.5 + XAVGL15.5) / 2) AND ((XAVGH15.5 + XAVGL15.5) / 2) > ((XAVGH25.8 + XAVGL25.8) / 2)
The above seems to be missing the Price comparison:
C > (XAVGH9.3 + XAVGL9.3) / 2 AND XAVGH9.3 + XAVGL9.3 > XAVGH15.5 + XAVGL15.5 AND XAVGH15.5 + XAVGL15.5 > XAVGH25.8 + XAVGL25.8
I also simplified things a bit.
QUOTE (kpnicholson) O > C AND C < ((H + L) / 2)
This portion of the formula does not appear to be represented in your English language description but tests for the Open to be above the Close and for the Close to be below the midpoint between the High and Low.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 11/1/2005
Posts: 78
|
Hi Bruce,
Thanks for the clarification and editing my PCF...
My Bearish Scan:
H > H1 AND H1 > H2 AND L > L1 AND L1 > L2 AND O > C AND C < ((H + L) / 2) AND MINV50 > 10000 AND C > (XAVGH9.3 + XAVGL9.3) / 2 AND XAVGH9.3 + XAVGL9.3 > XAVGH15.5 + XAVGL15.5 AND XAVGH15.5 + XAVGL15.5 > XAVGH25.8 + XAVGL25.8 AND C >= 20 AND C <= 150
My Bullish Scan:
H < H1 AND H1 < H2 AND L < L1 AND L1 < L2 AND O < C AND C > ((H + L) / 2) AND AVGV50 > 10000 AND C < (XAVGH9.3 + XAVGL9.3) / 2 AND XAVGH9.3 + XAVGL9.3 < XAVGH15.5 + XAVGL15.5 AND XAVGH15.5 + XAVGL15.5 < XAVGH25.8 + XAVGL25.8 AND C >= 20 AND C <= 150
How does this look for correctness...
You may not be aware of Bill Williams set up... However, his strategy is to find a Price bar Well above/bellow, Berish/Bullish, the Green line of the Gator... Then if all the other indicators match up, that would be a Signal point... Not an entry... Just a Signal point...
Do the above PCF's seem logical/correct to the way I am trying to find a signal point of entry...?
Thanks,
Keith
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The Personal Criteria Formulas seem logical enough, although it should probably be noted that the trainers cannot actually give settings, interpretation or investment advice.
One comment is that the Bearish and Bullish Scans use different Volume checks and will not use the same universe of symbols. If you want them to be consistent, they should either both use AVGV50 or MINV50.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 11/1/2005
Posts: 78
|
Hi Bruce,
Yes, I noticed the difference in the Volume calculation and changed the Bullish to "MIN"...
Of course, I am not asking you to judge the PCF for investment advice... That is my Risk...
I just appreciate the help you have given me to develop the code I am asking...
I could not have not this without your assistance...
Do not ever think my questions are about ivestment advice... I would never concider doing so and I know you cannot based on the Job position you have...
Thanks again,
Keith
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome. Our pleasure.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |