| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 8/25/2006
Posts: 15
|
Craig...
Through my research you wrote this sometime back...
"If so, try sorting any WatchList by the following PCF in ASCENDING ORDER.
100*(ABS(XAVGC3-XAVGC5)+ ABS(XAVGC5-XAVGC8)+ ABS(XAVGC10-XAVGC8)+ ABS(XAVGC10-XAVGC12)+ ABS(XAVGC12-XAVGC15)+ ABS(XAVGC15-XAVGC30)+ ABS(XAVGC35-XAVGC30)+ ABS(XAVGC35-XAVGC40)+ ABS(XAVGC45-XAVGC40)+ ABS(XAVGC50-XAVGC45)+ ABS(XAVGC50-XAVGC60)+ ABS(XAVGC3-XAVGC60)+ ABS(XAVGC5-XAVGC45)+ ABS(XAVGC30-XAVGC8)+ ABS(XAVGC10-XAVGC60))/(MAXH100-MINL100)
It should bring the stocks with the more consolidated averages to the top of your list. Be sure you are sorting in ASCENDING order."
What I am wanting to do is get the averages 30 to 60 to the top. I want to see the wider the group 30 to 60 is the better. Since I dont understand this ABS funtion I might have it in front of me and not know it.
If its not a bother could you have a look please.
Thanks
Mike
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
You want the stocks with the most consolidated 30ema and 60ema? If so, over how many days do you want to check?
- Craig
Here to Help!
|
|
Registered User
Joined: 8/25/2006
Posts: 15
|
Craig;
Thanks for the quick responce...
OK you through me here with the word consolidated...When I look at a chart and use the above formula I want to see the EMA of the group 30 to 60 to be as wide apart as can be or getting wider. I want the scan or the sort to show the charts with the widest to the tightest of the 30 to 60 emas. I am not looking for a crossover or if I understand you correctly a consolidating of the averages.
This is hard to explain when one doesnt know what one is talking about....
Hope this makes sence
Mike
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
OK.
Try sorting by this:
ABS(XAVGC30-XAVGC60)/(MAXH120-MINL120)
- Craig
Here to Help!
|
|
Registered User
Joined: 8/25/2006
Posts: 15
|
Craig...
Thank you Sir...that worked...
So I can explain what you did and learn from it could I bother you again to put this in sentance form...so I can understand what it says
Again thanks for your kindness
Mike
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Sure.
ABS(x) returns the absolute value of x.
So if x is negative it returns a positive number. If it is positive it stays positive. We have to do this so we measure the absolute distance of the difference of XAVGC30 and XAVGC60.
The divisor normalizes based on the volatility and price of the stock for the last 120 days. We don't need the ABS because the highest high less the lowest low can never be a negative number.
Does that help?
Here is a resource to keep handy: Handy PCF example formulas to help you learn the syntax of PCFs!
- Craig
Here to Help!
|
|
Registered User
Joined: 8/25/2006
Posts: 15
|
Thank you Sir...your kindness is much appreciated...I understand it and will try some differant examples....
Mike
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
You know where to find me if you get stuck!
- Craig
Here to Help!
|
|
Registered User
Joined: 8/25/2006
Posts: 15
|
Craig...
I am back for more... I played around with differant time frames and it all worked. Thank you...
What I am trying to do now is build a scan with the above pcf in it. Now I want to add another PCF which will tell me which stocks have the 3 to 15 EMA group far seperated from the 30 to 65 EMA group.
To put this in english, we have a chart with both groups of EMA's. When you look at the chart I want to see the space or distance between the two grops getting larger.
Can this be done...now thats a dumb question...I've seen your work...
Thanks
Mike
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Wow.
This is a challenge.
Here is something to try. Sort by it in ascending order and see if you like the stocks it finds:
1000*((1-(ABS(XAVGC30-XAVGC60)/(MAXH120-MINL120)))+
(1-(ABS(XAVGC3-XAVGC15)/(MAXH120-MINL120)))+
(ABS(XAVGC3-XAVGC30)/(MAXH120-MINL120))+
(ABS(XAVGC15-XAVGC60)/(MAXH120-MINL120)))
I think you will find the stocks with higher values more interesting so sort your lists in descending order. It is far from perfect but it may make it easier for you to find stocks you like.
- Craig
Here to Help!
|
|
|
Guest-1 |