StockFetcher Forums · Announcements · New Feature: Days Since<< 1 2 >>Post Follow-up
963 posts
msg #29428
10/23/2003 11:42:07 AM

We have added a new filter construct that allows you to filter based on the number of days since a particular event occurs. The "days" feature allows you to specify the event and a period of time; it returns the number of days since the event most recently occurred.

For example, suppose you want to find stocks where the most recent Bollinger breach was 10 days ago:

Fetcher[show stocks where days(high above upper Bollinger(20),15) equals 10]

Another example that controls the timing of two moving average crossovers:

Fetcher[show stocks where the days(MA(10) crossed below MA(50),30) is above 20
and days(MA(10) crossed above MA(50),20) is above 0

Finally, an example where the 14-day RSI crossed from below 30 to above 70 within the last 2 weeks:

Fetcher[show stocks where days(RSI(14) crossed above 30,10) is above days(RSI(14) crossed above 70,10)
and days(RSI(14) crossed above 70,10) is above -1

Note: the "above -1" portion of the filter adds the requirement that the crossover above 70 must have occurred.

As always, if you have any questions or find any problems with this new feature, please let us know.

Thank you, Support

150 posts
msg #29444
Ignore defghca
10/23/2003 6:59:04 PM

why the second parameter in
upper Bollinger(20),15) equals 10]
crossed below MA(50,30)
days(RSI(14) crossed above 70,10)

20 posts
msg #29485
Ignore sfbug
10/25/2003 4:28:22 PM

Ya, what does the 15 do?

267 posts
msg #29507
Ignore tomb
10/27/2003 1:11:38 PM


The second parameter indicates the limit on the number of days to search for the last time the event ocurred. So the "15" tells StockFetcher to search only up to 15 days. This is helpful (though not necessary) if you are simply testing for the presence of an event over the last couple of days or weeks and know the time frame you are looking for. Additionally, if you know you are searching a small time-frame, utilizing that parameter can reduce the computations in your filter, thus potentially increasing your response time.

Tom Support

2 posts
msg #29510
Ignore cyclon
10/27/2003 4:57:26 PM

I knew you could do it!!

This opens up fantastic operations.


28 posts
msg #29543
10/29/2003 12:42:49 AM

This message has been removed by StockFetcher.

2 posts
msg #47914
Ignore aarp*sf
11/11/2006 10:45:23 AM

concerning the features of 'days since' & '% change since'...
With either a watchlist or a list from a filter, how can I display the '% change since' a date to be supplied as a parameter? What I have in mind would work exactly like the '% change since date added' column available for a watch list, only without the limitation of the starting date being just the one day on which the symbol was added to the watchlist.

1 posts
msg #50923
Ignore mackthefinger
4/7/2007 7:23:10 PM

I'm trying to filter on days since SAR crossed close. Does anyone have the correct syntax for this? I've tried:
days(Parabolic SAR below close)
days(Parabolic SAR cross close)
etc. and nothing works

6,358 posts
msg #51182
Ignore TheRumpledOne
4/18/2007 1:09:33 AM

set{PARBuy, count(close crossed above Parabolic SAR, 1) }
set{DMIBuy, count( di(14) Difference above 0 , 1) }

set{PARSell, count(close crossed below Parabolic SAR,1) }
set{DMISell, count( di(14) Difference below 0, 1) }

set{PARSBuy, PARBuy * DMIBuy}
set{PARSSell, PARSell * DMISell}
set{PARSTrade, PARSBuy + PARSSell}

add column PARSBuy
add column PARSSell

PARSBuy above 0
close above 1
volume above 1000000

sort column 5 descending

Found this code in the "DMI and Parabolic SAR magic" thread.

I wrote and posted it 6/27/2005 6:58:09 PM

22 posts
msg #55292
Ignore macer
9/27/2007 11:20:44 AM

SF is there any way of counting the days since an event that is not the latest occurrence.

eg days(event, look back period, number of events to skip)


StockFetcher Forums · Announcements · New Feature: Days Since<< 1 2 >>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