| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
 Gold Customer
Joined: 12/7/2004
Posts: 43
|
How do I find stocks with current stock price near or at 52 week high and if it is at 52 week high, is it 10 points or higher than the 52 week high?
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 4,308
|
There is a built-in sort criterion called Price as a % of 52 Week high. When you use it to sort a watchlist in descending order, the stocks at the top will have returned a value of 100 if they are currently at a 52 week high. The closer to 100, the closer the current price is to the 52 week high.
As for being 10 points higher than the 52 week high? There is no such animal. A stock can't closer higher than its 52 week high...or that price would be the 52 week high.
- Doug
Teaching Online!
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
You can also use these PCFs:
Price as % of 52wk high (no today)
C/MAXH250.1*100
This will return the price today as a percent of the 52wk high but not including today. This could return a value greater than 100%.
Price less 52wk high (no today)
C-MAXH250.1
This will return the net difference between the price today and the 52-wk high as of yesterday.
- Craig
Here to Help!
|
|
Registered User
Joined: 1/1/2005
Posts: 2,645
|
It should be noted that a stock can make a new 52 week high which is at least 10 points higher than the high for the previous 52 weeks and still be below the previous 52 week high. This is because the high for the previous 52 weeks is not generally itself a 52 week high.
In any case, Craig's statement:
"This will return the net difference between the price today and the 52-wk high not (?) as of yesterday."
is in need of some modification.
Thanks,
Jim Murphy
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
bustermu,
I think Craig's statement is True by definition even if the 52-Week High as of Yesterday wasn't the 52-Week High on the day it was made.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
I need you guys to help me on this, I am not 100% clear on what has been said.
Are you condending that:
H1=MAXH250.1
...can be true but if we go back in time to yesterday:
H=MAX250
would not have to be true on yesterday?
- Craig
Here to Help!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Craig,
I'm not saying that at all. The 52-Week High as of Yesterday was most likely not a New 52-Week High Yesterday. Not only that, it is possible the 52-Week High as of Yesterday never was a a New 52-Week High, even on the day it was made. It is very likely that if the 52-Week High was made 51-Weeks ago that there was a higher High in the 52-Weeks before that not included in the current 52-Week High.
That said, a 52-Week High is still the 52-Week High by definition even if it wasn't a New 52-Week High. This seems to be consistent with both what you said and the way I interpret kiss35's original request. Here's a single Boolean Personal Criteria Formula for what I believe he is requesting:
C >= MAXH250.1 + 10
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/1/2005
Posts: 2,645
|
Bruce,
We both know that the previous 52 week high is not the same as the high for the previous 52 weeks.
The only question is what does "52-wk high as of yesterday" mean? One could interpret it as "the previous 52 week high" or as "the high for the previous 52 weeks". Of course, Craig meant "the high for the previous 52 weeks", but what he actually said is open to interpretation. My suggestion was that he change his statement so that it is not so open to an interpretation not intended.
Some users likely pay more attention to the words than to the PCF itself.
Thanks,
Jim Murphy
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
bustermu,
I'm not sure if it is just semantics or if I'm missing your point entirely (so I'll retreat a bit into Personal Criteria Formula Language in an attempt to get some clarification).
I see the 52-Week High as simply (assume for a moment that 250 trading days are in a year):
MAXH250
I see a New 52-Week High as either:
H=MAXH250
or
H>MAXH250.1
So the 52-Week High as of Yesterday would mean to me rather clearly the 52-Week High 1-Day Ago:
MAXH250.1
I'm pretty sure you mean what I see as "the 52-Week High" when you say "the high for the previous 52 weeks", but I'm beginning to doubt I understand at all what you mean when using the phrase "the previous 52 week high". Two possibilities might be "the most recent New 52-Week High" or "the 52-Week High 52 Weeks Ago". Then again the second interpretation would leave my understanding of the first phrase in doubt as well.
Now I think I'm just confused.... 
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Let me see if I now understand:
The highest high for the past 250 days may not have been the MAXH250 when it happened.
Example:
Suppose...
the current MAXH250 happened 125 days ago (it is H125).
the H255 is greater than the H125.
H125 <> MAXH250.125
Is this what you mean, bustermu?
- Craig
Here to Help!
|
|
Registered User
Joined: 1/1/2005
Posts: 2,645
|
Craig,
Yes.
Bruce,
Suppose a stock increased each day by 0.01 from 10.00 to 100.00 and then decreased by 0.01 each day from 100.00 to 10.00 today. I believe most would say "the high for the previous 52 weeks" was 12.50. I believe at least some would say that "the previous 52 week high" was 100.00. Apparently, many would say that "the previous 52 week high" was 12.50.
My concern was that some may interpret Craig's "the 52-wk high as of yesterday" as 100.00 rather than 12.50 as he intended.
Thanks,
Jim Murphy
|
|
|
Guest-1 |