| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 4/2/2006
Posts: 38
|
I'm looking at charts on a daily time frame, over a two year length to get a good over view of the overall direction.
Can you send me the formula for the 20 day moving average being greater than the 50 day moving average (20 day crossing the 50 day) by a period of thirty days.
In other words, the 20 day should have crossed the 50 day already, but if you can I'd like to see the crossover after a thirty day time frame.
If this is confusing then I'll except a simple crossover without any other parameters such as the one mentioned above.
I'm only interested in SMA not EMA as far as the weights.
Thanks
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Here are a few formulas to try:
20 greater than 50
AVGC20 > AVGC50
20 greater than 50 (last 30 days)
AVGC20>AVGC50 AND AVGC20.5>AVGC50.5 AND AVGC20.10>AVGC50.10 AND AVGC20.15>AVGC50.15 AND AVGC20.20>AVGC50.20 AND AVGC20.25>AVGC50.25 AND AVGC20.30>AVGC50.30
- Craig
Here to Help!
|
|
Registered User
Joined: 4/2/2006
Posts: 38
|
Craig,
You deserve all the flattery that you get 
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Glad to hear we got another one working for you!
- Craig
Here to Help!
|
|
|
Guest-1 |