Great. Thank you for your reply. It would be great if I actually got an email alert once you replied to my post or anyone else commented on the thread.
|
Hi, I need to find stocks with are up vs 12/31/2016. And i'll run this scan daily so I can't say look back X days since every day X will increase by 1.
erik
|
Bruce,
So to me it sounds like it's a serious development flaw. I understand what current defenition of MAXC250 is. It should be redesigned to include things that only have 1 bar. There is no reason to exclude stocks with a shorter trading history. When searching for a 52Week High Close it means look for the past 250 days. If only 249 days are present in the history then look withing that time period, if 248 then max of that, etc..... But no more than 250days.
There is no need to change the actual syntax as you have mentioned. All this calculation and definition should be done by the developers on the back end.
Can this change be done by the developers?
Erik
|
The formula says Max of 250. So it should encompass everything within that time period. If that portion of the formula is inccorect. How should I filter for stocks that are withing 2% of their 52 week high?
It shouldn't matter if it's been trading for 1 year or 1 week. 52 week high is 52 week high.
Thank you,
Erik Fridman
|
So I have a simple formula listed below. With 4 criteria.
(1) Close >$30 (2)30day Avg Vol is >50k shares (3)Today's close is within 2% of the yearly range (4)Today's close is at least 10 cents higher then the day before
C > 30 AND (V + V1 + V2 + V3 + V4 + V5 + V6 + V7 + V8 + V9 + V10 + V11 + V12 + V13 + V14 + V15 + V16 + V17 + V18 + V19 + V20 + V21 + V22 + V23 + V24 + V25 + V26 + V27 + V28 + V29) / 30 > 500 AND C >= .98 * MAXC250 AND C >= C1 + .1
I then run an easyscan and i apply this formula to a watchlist of "ALL items in the system" so there should never be any stocks missing that fit this criteria.
However, on 12/18 RLGY was missing from this scan. It has met all 4 criteria.
Close 40.16, Avg volume is over 700k, closed at a new Year High, and was up more then 10 cents on the day.
Please help. I think other things might be missing as well.
I took screen shots as well and you can see them at the link below.
https://www.dropbox.com/sh/7y8189hasl7ptr6/4wpcHp7RKa
|