StockFetcher Forums · General Discussion · Looking into the past<< >>Post Follow-up
D538262
7 posts
msg #48519
Ignore D538262
modified
12/10/2006 4:38:50 PM

Hello,
Can someone tell me the code to put into my filter that will show me results from a few days ago...example...I would like to see a moving average that has crossed, but I want the filter to display only crosses that occured 5 days ago, not"within" the last 5 days...any solutions would be appreciated...thanks

Ron





retired
28 posts
msg #48520
Ignore retired
12/10/2006 6:36:08 PM

Ron, I believe it's, offset 5 days


D538262
7 posts
msg #48521
Ignore D538262
12/10/2006 7:11:08 PM

Retired,
Thanks for awnser, but changing the offset doesn't accomplish the task at hand. It doesn't pinpoint the day in which the ma cross occured. For some reason, it shows me ma crosovers that occured more than 5 days ago...the way I am doing it now is to create a watchlist on the day the ma crossed and then watch it. This is very cumbersome. I have found that w/my particular filter criteria, that after the crossover, it may take a few days for price action to move in the direction I am anticipating...so I am watching for a divergence between the 2 ma's after the crossover to help pinpoint an entrypoint. I need to look into the past 5 days to weed out the ma's that are still intertwined from the ones that are diverging.


retired
28 posts
msg #48524
Ignore retired
12/10/2006 8:30:11 PM

Ron,

Sorry. Can't help you with that, it's beyond my knowledge. A form contributor who goes by the name as214 probably could help. Good luck.

Retired


maxreturn
745 posts
msg #48525
Ignore maxreturn
12/10/2006 8:45:24 PM

I believe this is what you're looking for:

Fetcher[ma(5) 5 days ago crossed above ma(20) 5 days ago]



As you can see the key is using "x days ago" after each ma statement

Regards
Max




luc1grunt
622 posts
msg #48527
Ignore luc1grunt
12/10/2006 8:45:57 PM

Wow max, I think we hit send at the same time.


emergentrades
10 posts
msg #48528
Ignore emergentrades
12/10/2006 8:52:41 PM

show stocks where days(close crossed above ma(10),15) equals 5
set{cross5, count(close crossed above ma(10),1)}
draw cross5




TheRumpledOne
6,358 posts
msg #48530
Ignore TheRumpledOne
modified
12/10/2006 9:47:26 PM

Fetcher[
set{E5b,days(close is above ema(5),100)}
set{E5a,days(close is below ema(5),100)}
set{CxEma5, E5a - E5b}

add column CxEma5

sort column 5 descending
]



The CxEma5 column will tell you how many days since the close crossed above/below the ema(5).

If you want the 5 day cross, just add this line:

CxEma5 equal 5


Fetcher[
set{E5b,days(close is above ema(5),100)}
set{E5a,days(close is below ema(5),100)}
set{CxEma5, E5a - E5b}

add column CxEma5

CxEma5 equal 5

sort column 5 descending
]



I used some of the code out of the BASIC FILTER DISPLAY that I posted.

HTH.


luc1grunt
622 posts
msg #48526
Ignore luc1grunt
modified
12/11/2006 6:49:04 AM

Show stocks where the MA(9) 5 days ago crossed above the MA(13) 5 days ago




D538262
7 posts
msg #48553
Ignore D538262
12/11/2006 3:33:41 PM

Thanks guys..it's nice to know you are all out there and willing to help.


StockFetcher Forums · General Discussion · Looking into the past<< >>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 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