StockFetcher Forums · General Discussion · Counting moving average crosses<< >>Post Follow-up
32 posts
msg #127154
Ignore spauken
2/4/2016 8:42:23 PM

Can anyone help me with an indicator? I want to count how many times a fast MA crossed (above and below) a slow moving average for the last two years and display the cumulative count at the bottom of the chart.

1,305 posts
msg #127157
Ignore Mactheriverrat
2/5/2016 1:30:13 AM

Here's some code on how many days a EMA(5) is above EMA(5). You can change this to MA(5) above MA(5) or EMA(10) above EMA(30). If you get the picture.

BxB is number of consecutive days ema(5) above (+)/below(-) previous EMA(5) and set{BBb,days( ema(5) is above EMA(5)1 day ago,100)}
set{BBa,days( ema(5) is below EMA(5) 1 day ago,100)} set{BxB, BBa - BBb} and add column BxB {B_x_B}

do not draw BxB

853 posts
msg #127233
Ignore mahkoh
2/8/2016 4:05:55 PM

set{x, count(ma(20) crossed above ma(200),200)}
set{y, count(ma(20) crossed below ma(200),200)}
set{z, x + y}
add column z
s&p 500
draw ma(20)
draw ma(200)
chartlength 52 weeks

This should do it. However,when examining the charts it doesn't always seem correct. This could be related to accounting for dividends.

32 posts
msg #127265
Ignore spauken
2/10/2016 1:28:24 PM

Thanks mahkoh. This does work, although the count is limited to the only the last 100 days per the SF user guide. Not sure why, but it is.

4,411 posts
msg #127266
Ignore Kevin_in_GA
2/10/2016 1:42:15 PM

I believe that SF has upgraded many of their functions (including count()) to go back up to 252 days.

StockFetcher Forums · General Discussion · Counting moving average crosses<< >>Post Follow-up

*** Disclaimer *** 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. does not recommend particular securities., 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 2016 - 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