| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 3/20/2005
Posts: 17
|
Is it possible to scan or have a formula which result in stocks which make record high within N days? for example, N = 10 days.
Record High means all time high here.
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 4,308
|
Not exactly. Here is the maximum high function:
MAXH1250 This finds the maximum high over a ten year period.
You could write a formula like:
H=MAXH1250 OR H1=MAXH1250 OR H2=MAXH1250...etc. up to OR H9=MAXH1250
This would find stocks where the maximum 10 year high was achieved on one of the past 10 trading days. However, you must specify the lookback period in the MAX function. No way to specify over the life of the stock without specifying how many days that is.
- Doug
Teaching Online!
|
|
Registered User
Joined: 3/20/2005
Posts: 17
|
thanks..
I tried that myself. It works but the updates become very slow after adding this pcf. Looks like 1250 days are too much data to process. Hope there are other ways to do it.
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
I would zoom out all the way and bring up a monthly chart then visually sort by the visual value of price. At the top of the list you should have all the new ALL TIME highs.
Sort by Visual Value to find new highs and lows in price and indicators
- Craig
Here to Help!
|
|
|
Guest-1 |