| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 12/13/2004
Posts: 4
|
Hi:
I have been listening ot Doug's presentation on moving average crossovers. Nice presentation.
I'm interested in doing something slightly different which is a price crossover of the moving average. I'm writing to you as I'm having some problems getting the scan to do that. I tried to do a price crossover of the 3 day MA for starters using (AVGC1/AVGC3)*100 for the first PCFand then like the video, use (AVGC1.3/AVGC3.3)*100 for the second PCF.
I did it this way as I could not get a formula to make the price or  close, cross the average or AVG3. What I'm still getting however, is a list of some stocks that meet the criteria and some that do not.
Any suggestions?
Thanks,
Paul
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Let's make it even simpler
Today
C/AVGC3*100
Yesterday
C3/AVGC3.3*100
If your averages are exponential use these:
C/XAVGC3*100
C3/XAVGC3.3*100
Also be sure your moving average is directly indented under price when you edit your template (hot key I). If it is indented under another average (not flush left with that average) it is a 3-bar average of what it is indented under.
Let me know if these clear it up.
(PS, be sure you are looking at a daily chart too)
- Craig
Here to Help!
|
|
Registered User
Joined: 4/11/2005
Posts: 24
|
Craig,
I've been trying to get a Price Crossing the 200 Day Simple Moving Average PCF to work but no success.
Used your C/AVGC3*100 and changed it to C/AVGC200*100. Thought this would give me the crossover today but it is all over the place.
Please help me correct this to find Price crossing the 200 Day MA today and 1-Day ago.
Thank you,
bobw
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 4,308
|
Here are two videos that will demonstrate two different methods for finding crossovers. One uses formulas, the other does not. Both videos demonstrate one moving average crossing another, but the exact same concepts can be applied to price crossing a moving average.
Create PCFs and EasyScans to find moving average crossovers
Comparing indicators using Visual Difference sorts
Assuming you want the closing price to have crossed the moving average, here are two formulas for you:
Price Crossing Up Through 200 Bar SMA:
C1<AVGC200.1 AND C>AVGC200
Price Crossing Down Through 200 Bar SMA:
C1>AVGC200.1 AND C<AVGC200
- Doug
Teaching Online!
|
|
|
Guest-1 |