| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 10/9/2007
Posts: 18
|
i recently read in stock and commodities magazine the concept of the GOLDEN CROSS 50macrossing the 200day ma. could you please help me set up a scan that would show when the two moving avgs. are getting close or about to cross either up or down please advise thanks sd
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You might want to try something like the following (it is based on Simple Moving Averages) as an EasyScan Condition:
SGN((50 * (200 - 1) * AVGC199.1 - 200 * (50 - 1) * AVGC49.1) / (200 - 50) - C1) - SGN((50 * (200 - 1) * AVGC199 - 200 * (50 - 1) * AVGC49) / (200 - 50) - C) <> 0
It may not work since it is attempting to predict the future, but when you compare it to the actual crossovers, they follow quickly with some consistency. You may wish to review the following:
Backscanner and S&C Traders Tips
How to create a Personal Criteria Forumula (PCF)
Using EasyScan to find stocks that meet your own criteria
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/1/2005
Posts: 2,645
|
QUOTE (Bruce_L) SGN((50 * (200 - 1) * AVGC199.1 - 200 * (50 - 1) * AVGC49.1) / (200 - 50) - C1) - SGN((50 * (200 - 1) * AVGC199 - 200 * (50 - 1) * AVGC49) / (200 - 50) - C) <> 0
Bruce,
I do not have access to the literature, but if the idea is to try to predict a cross for tomorrow, why is the C1 not a C? We do not have to predict C using C1, we already know its value.
If it is just an error, please delete this post.
Thanks,
Jim Murphy
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
bustermu,
There might be a better way to do this, but it's essentially just a crossover formula:
Warning: The following aren't real PCFs and can't be used.
TC xUp Price:
TC > C AND TC1 <= C1
TC xDn Price:
TC < C AND TC1 >= C1
TC crossing Price (in either direction):
SGN(TC - C) <> SGN(TC1 - C1)
The last is only slightly re-arranged from the formula given above:
SGN(TC1 - C1) - SGN(TC - C) <> 0
Tomorrow's Close isn't really a prediction of what the Close will be tomorrow. It is the value that the Close would need to be tomorrow for the Moving Averages to be equal to each other.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/9/2007
Posts: 18
|
thank you bruce that looks like it will work very well much thanks again sd
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
guru7306,
You're welcome. Our pleasure.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |