| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 12/8/2004
Posts: 6
|
I'm interested in a PCF that calculates the intersection of the 10, 20 ,30 day MA. I willaccept a $.05 difference in the calculation instead of 0.00 between the three.
Thanks
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Do you want the full bowtie (where they are apart, cross/converge then flow apart again) or do you just want them within .05 of each other?
Using a dollar amount will mean the price per share of the stock will be a large factor in your results vs. them being close together. You might consider using a percentage to measure closeness to avoid a price per share bias.
- Craig
Here to Help!
|
|
Registered User
Joined: 12/8/2004
Posts: 6
|
Craig,
I would like the full bowtie, and a percentage would be acceptable too. I'd would think that .05% would suffice.
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Try this for me....
AVGC10>AVGC20 AND AVGC20>AVGC30 AND AVGC10/AVGC20<1.05 AND AVGC20/AVGC30<1.05 AND AVGC10.10<AVGC20.10 AND AVGC20.10<AVGC30.10
This version allows the bowtie to occur over 10 days.
CTX is a good example of what it finds. Does this work for you?
- Craig
Here to Help!
|
|
Registered User
Joined: 1/1/2005
Posts: 2,645
|
Craig,
Your PCF only implies that the MAs are within 10.25% of each other.
If they are required to be within 5% of each other, you can replace the portion:
AVGC10/AVGC20<1.05 AND AVGC20/AVGC30<1.05
by:
AVGC10<1.05*AVGC30
Thanks,
Jim Murphy
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Correct. My version only requires the 10 to be no more than 5% above the 20 and the 20 to be no more than 5% above the 30.
mpmeyers can use my formula, as is, or, if he wants the 10 to be no more than 5% above the 30, make the changes you suggest.
- Craig
Here to Help!
|
|
Registered User
Joined: 1/1/2005
Posts: 2,645
|
Craig,
The reason for my post is that you said:
"Do you want the full bowtie (where they are apart, cross/converge then flow apart again) or do you just want them within .05 of each other?"
The response was:
"I would like the full bowtie, and a percentage would be acceptable too. I'd would think that .05% would suffice."
You then provided a PCF for which the maximum distance apart is 10.25% rather than 5% as you suggested. It may be that mpmeyers assumed that your PCF required that the maximum distance allowed by the PCF was 5% instead of 10.25%.
Thanks,
Jim Murphy
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
I appreciated you clarification of my response.
- Craig
Here to Help!
|
|
|
Guest-1 |