StockFetcher Forums · General Discussion · Finding moving Averages before the crossover<< >>Post Follow-up
alp1535
13 posts
msg #37178
Ignore alp1535
7/30/2005 5:43:31 PM

Hi I'm new to trading and have been reading the forum for about two months now. TheRumpledOne's "load the boat" suggestion has been wonderful. I also added MA 13-50-200 to the prophet.net charts and it works great. But here's my question. I'm wanting to find stocks where MA(13) and MA(50) are about to crossover. SF's scan says "Show stocks where MA(13) crossed above MA(50)" and this scan is after the fact. It finds stock that have already gapped up. I want to see this setup BEFORE the MA's actually crossover.
What phrase would I use to have the scan find stocks where the two MA's (13-50) are just about to crossover.
I tried using "Show stocks where MA(13) is approaching MA(50) but it didn't work too well.

Can anyone help me out here


txtrapper
548 posts
msg #37186
Ignore txtrapper
7/30/2005 8:19:18 PM

show stocks where EMA(13) is approaching EMA(50) from below

this works you may also want to try WMA. Could not get MA to work properly, I think EMA will work fine for you.



TxTrapper
_______________________________________________________


TheRumpledOne
6,407 posts
msg #37187
Ignore TheRumpledOne
7/30/2005 8:43:23 PM

Fetcher[
set{E1350b,days(ma(13) is above ma(50),100)}
set{E1350a,days(ma(13) is below ma(50),100)}
set{M13xM50, E1350a - E1350b}

set{D1350, ma(50) - ma(13)}

set{T13, count(13 day slope of the close above 0,1)}
set{T50, count(50 day slope of the close above 0,1)}
set{T200, count(200 day slope of the close above 0,1)}

Set{u1, T200 * 1}
Set{u2, T50 * 10}
Set{u3, T13 * 100}

Set{uu, u1 + u2}
Set{TREND, uu + u3}

add column D1350
add column M13xM50
add column TREND

draw ma(13)
draw ma(50)

D1350 above 0

sort column 5 ascending

/* change price and volume to your own criteria */

close above 20
volume above 1000000
]




Column D1350 is the result of subtracting the MA(13) from the MA(50).

The closer D1350 is to zero, the closer the MA(13) is to crossing over the MA(50). Of course, if you can add a line like:

D1350 below .10

and only look at the ones close by.

This is a case where SORTING beats selecting due to SF limitations.

I display the M13XM50 column so you would know how many days the MA(13) has been below the MA(50).

I display the TREND column so you can see if the stock is in a 13, 50 and/or 200 day uptrend or downtrend.


MAY ALL YOUR FILLS BE COMPLETE.




alp1535
13 posts
msg #37188
Ignore alp1535
7/30/2005 11:01:58 PM

Thanks TxTrapper and TheRumpledOne. Both suggestions seem to work great. I can't wait until Monday.
TheRumpledOne: After sorting, I think the D1350 between .20 and .40 will offer the most opportunity to jump in and ride the wave.


TheRumpledOne
6,407 posts
msg #37189
Ignore TheRumpledOne
7/30/2005 11:14:34 PM

7/30/2005 8:43:23 PM


Fetcher[
set{E1350b,days(ma(13) is above ma(50),100)}
set{E1350a,days(ma(13) is below ma(50),100)}
set{M13xM50, E1350a - E1350b}

set{D1350, ma(50) - ma(13)}

set{T13, count(13 day slope of the close above 0,1)}
set{T50, count(50 day slope of the close above 0,1)}
set{T200, count(200 day slope of the close above 0,1)}

Set{u1, T200 * 1}
Set{u2, T50 * 10}
Set{u3, T13 * 100}

Set{uu, u1 + u2}
Set{TREND, uu + u3}

add column D1350
add column M13xM50
add column TREND

add column ma(13)
add column ma(50)

draw ma(13)
draw ma(50)



sort column 5 ascending


show stocks where EMA(13) is approaching EMA(50) from below


/* change price and volume to your own criteria */

close above 20
volume above 1000000


]




Seems like my original filter showed a flaw in SF's processing.

I got a few emails saying that MY filter gave invalid info... but in reality the difference was out to 4 decimal places.

The above filter uses TxTrapper method for finding the stocks. What is funny is RD comes up on the when it really shouldn't!! The difference is -.22!!

That's another reason why having the data displayed is valid and not just bells and whistles. It shows you when SF isn't accurate.

MAY ALL YOUR FILLS BE COMPLETE.


TheRumpledOne
6,407 posts
msg #37190
Ignore TheRumpledOne
7/30/2005 11:23:57 PM

Whoops! I forgot TX was using ema instead of ma!

Here's TX's method using MA!

Fetcher[
set{E1350b,days(ma(13) is above ma(50),100)}
set{E1350a,days(ma(13) is below ma(50),100)}
set{M13xM50, E1350a - E1350b}

set{D1350, ma(50) - ma(13)}

set{T13, count(13 day slope of the close above 0,1)}
set{T50, count(50 day slope of the close above 0,1)}
set{T200, count(200 day slope of the close above 0,1)}

Set{u1, T200 * 1}
Set{u2, T50 * 10}
Set{u3, T13 * 100}

Set{uu, u1 + u2}
Set{TREND, uu + u3}

add column D1350
add column M13xM50
add column TREND

add column ma(13)
add column ma(50)

draw ma(13)
draw ma(50)



sort column 5 ascending


show stocks where MA(13) is approaching MA(50) from below


/* change price and volume to your own criteria */

close above 20
volume above 1000000

]



So approaching only catches the stocks within .20.

Learned something new.

MAY ALL YOUR FILLS BE COMPLETE.


StockFetcher Forums · General Discussion · Finding moving Averages before the crossover<< >>Post Follow-up

*** Disclaimer *** StockFetcher.com does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. StockFetcher.com does not recommend particular securities. StockFetcher.com, Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.


Copyright 2022 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.