StockFetcher Forums · General Discussion · How to assign number of days that qualify ?<< >>Post Follow-up
tanveer
10 posts
msg #95914
Ignore tanveer
8/31/2010 4:55:24 PM

Hi there, brand new member here. Love this site, love the program and in an effort to switch from an expensive scanner I need to know if it is possible to do the following and if so then how ? If this has been previously discussed then please kindly post the link and I shall check for myself. (I did try searching however I am not sure what term to exactly look for.)

Ok so what I am trying to do is assign a filter and have it be true for a series of days. Example:

I need stocks that have traded over a million shares EVERYDAY for the past 20 days ... how can i do this ?
Or stocks that have had a high greater than 100 EVERYDAY for the past 20 days ?

I don't want -
volume (20) greater than 1M
high (20) greater than 100

(I could be mistaken but don't the above example show me the results for the periods combined)

All help is appreciated.

Thank you,
Tanveer

Kevin_in_GA
4,553 posts
msg #95915
Ignore Kevin_in_GA
8/31/2010 5:24:32 PM

Fetcher[

COUNT(VOLUME ABOVE 1000000,20) ABOVE 19

]



OR

Fetcher[

COUNT(HIGH ABOVE 100,20) ABOVE 19

]



EACH OF THESE STATEMENTS WILL REQUIRE THAT EVERY DAY FOR THE PAST 20 DAYS, THE VOLUME OR HIGH MEETS YOUR SPECIFIED CRITERIA.

tanveer
10 posts
msg #95917
Ignore tanveer
8/31/2010 6:10:03 PM

Thanks Kev, what's the "above 19" at the end for ?

Kevin_in_GA
4,553 posts
msg #95918
Ignore Kevin_in_GA
8/31/2010 6:20:12 PM

IT REQUIRES THAT THE TOTAL NUMBER OF DAYS OUT OF THE LAST 20 DAYS WHERE THE DESIRED CRITERIA HAS OCCURRED IS GREATER THAN 19 (BASICALLY, IT FORCES IT TO BE EVERY DAY DURING THE 20 DAYS, OR THE STOCK IS NOT INCLUDED IN THE FILTER RESULTS).

Sorry about the caps lock!

the "count" function returns the number of times out of the last X days where your criteria has been met.

tanveer
10 posts
msg #95919
Ignore tanveer
8/31/2010 6:22:41 PM

Thanks a ton, much appreciated !

StockFetcher Forums · General Discussion · How to assign number of days that qualify ?<< >>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