StockFetcher Forums · Filter Exchange · Please help improve on this filter<< >>Post Follow-up
patskijoe
3 posts
msg #41231
Ignore patskijoe
2/15/2006 7:04:32 PM

Can anyone improve on this filter ....Maybe shorter phrases
I do not know how to write a phrase where the close price is not more that X% above and X% below each close price for the last X days,months .....such as price was 15 which would be only 25% above the lowest price which occured during the last 6 months and only 20% below the highest price which occured during the last 6 months

When I show results from 68 days ago forward I get some amazing increases

Fetcher[average volume (3) is greater than average volume (6) and average volume (90) is greater than 50000 and volume is greater than average volume (90) and close is less than 20% below 6 month high and close is less than 20% above 6 month high and close is less than 20% above 1 month low and price gained less than 20% over the last 10 days and price gained less than 25% over the last 30 days and price gained less than 50% over the last 60 days and price gained less than 100% over the last 90 days and high is less than 25% above low 1 day ago high is less than 25% above low 2 days ago and high is less than 25% above low 3 days ago and high is less than 25% above low 4 days ago and high is less than 25% above low 5 days ago and price is between 1 and 4 ]




yepher
359 posts
msg #41252
Ignore yepher
2/16/2006 3:40:23 PM

I think it would be improved if you were to add some line feeds sometimes :)

-- yepher


nikoschopen
2,824 posts
msg #41254
Ignore nikoschopen
modified
2/16/2006 3:55:45 PM

Here's a bit more presentable vis-à-vis digestible form:

Fetcher[
/*volume*/
average volume (3) is greater than average volume (6)
and average volume (90) is greater than 50000
and volume is greater than average volume (90)

/*close*/
close is less than 20% below 6 month high
and close is less than 20% above 6 month high
and close is less than 20% above 1 month low
and price gained less than 20% over the last 10 days
and price gained less than 25% over the last 30 days
and price gained less than 50% over the last 60 days
and price gained less than 100% over the last 90 days

/*high-low*/
high is less than 25% above low 1 day ago
and high is less than 25% above low 2 days ago
and high is less than 25% above low 3 days ago
and high is less than 25% above low 4 days ago
and high is less than 25% above low 5 days ago

and price is between 1 and 4
]





8638236
2 posts
msg #41259
Ignore 8638236
2/16/2006 6:27:55 PM


Very neat and organized programing.


nikoschopen
2,824 posts
msg #41260
Ignore nikoschopen
2/16/2006 6:39:13 PM

Ugh <dazed & confused> I really didn't do anything but to break up the long sentence into less verbose fragments.


nikoschopen
2,824 posts
msg #41264
Ignore nikoschopen
modified
2/16/2006 7:47:05 PM

Q: How do you write... "close is not more that X% above and X% below each close price for the last X days"

A: In another word, you want to find the stock that closed in between x% and y%. Taking the example of 25% above the low and 25% below the high of the past 6 months, what ure looking for are stocks that traded between 25% and 75% of the 6 month range, respectively.

Fetcher[
set{range, high 6 month high - low 6 month low}
set{cl, close - low 6 month low}
set{ratio, cl / range}
ratio between 0.25 and 0.75
add column ratio
]






StockFetcher Forums · Filter Exchange · Please help improve on this filter<< >>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.