StockFetcher Forums · General Discussion · Need help on DROPPED filter<< >>Post Follow-up
HerveM
2 posts
msg #121092
Ignore HerveM
7/25/2014 8:16:45 AM

Hello,

The high of MBI was 13.25 on June,17
The low of MBI was 9.2 on July, 10, sixteen trading days later.
The drop was greater than 30% (9,2/13.25 = 0.694)

Please, does someone know what is the correct phrase to see the stocks with more than 30% between their highest and lowest in a recent given period and keep these cases for 5 days ?
I don't know if I am clear and sorry for my bad english.

(I have not found a similar question in the past theads)

Many thanks in advance.

djones000buck
206 posts
msg #121099
Ignore djones000buck
modified
7/25/2014 2:38:51 PM

Take a look....

Fetcher[

Set{hivar, high 30 day high}
Set{lowvar, low}
Set{var, hivar - low}
Set{pctchg, var/hivar}
Set{trigger, count(pctchg crossed above .29,1)}
Price > 2
Average volume(90) > 1000000
Add column pctchg
Add column trigger
Sort column 5 descending
And draw trigger
And draw pctchg
And draw hivar on plot price
And draw lowvar on plot price
]



Maybe this is closer, seems to flag your mbi example. Still need to exclude stocks like usu who move up > 29% in one day as they will throw a trigger as well.

djones000buck
206 posts
msg #121101
Ignore djones000buck
7/25/2014 10:14:55 PM

Interestingly enough you will see that some stocks have a sweet spot.. Check out spls in that filter and what happens when it hits a 20% drop from a 30 day high...

HerveM
2 posts
msg #121104
Ignore HerveM
7/26/2014 10:09:10 AM

Oh, a big thank to you, I would not have found on my own.
I understand the principle, I will work on these bases and the user guide.
Thank you again.

StockFetcher Forums · General Discussion · Need help on DROPPED 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 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