Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Gold Customer
Joined: 6/13/2005 Posts: 5
|
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
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
RLGY is not on the list because there is less that 250 trading days of data required for your formula to calculate available. The C >= .98 * MAXC250 portion of the formula cannot be true when there is only 46 trading days of data available.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Gold Customer
Joined: 6/13/2005 Posts: 5
|
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
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I cannot think of a way to do what you want in either version of TC2000.
MAXC250 is the highest close out of the most recent 250 closes. It cannot calculate unless all 250 closes required for its calculation are present. There is no syntax available in the Personal Criteria Formula Language for a 52-week high which can calculate with less than 250 bars of data.
It is possible to create a Condition in TC2000 version 12.2 for a New High which will calculate with fewer bars of data than its period by clicking on an Indicator, selecting Create Scan Condition and choosing New High, but this option is not available in TC2000 version 7. In addition, this type of Condition would be specifically checking for a New High, it is not possible to calculate the High over the abbreviated period, multiply it by .98 and compare it to another value as you have done in your formula.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Gold Customer
Joined: 6/13/2005 Posts: 5
|
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
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
It would certainly seem possible to do so as the New High Condition created by clicking on an indicator and selecting Create Scan Condition already implements highs in this way.
Thank you for your suggestion. It hass been assigned case number 9620.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |