Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Platinum Customer
Joined: 5/31/2005 Posts: 16
|
I would like to create some custom watchlist sorts and I'm sorry that I am so weak on writting the PFC code. The first one that I would like is to sort a a live scan watchlist with stocks making a new high of the last 2 days. Is it possible to do this? If so how? Thanks for your help.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Assuming you mean a new 252-Period High, you could write a Condition Formula for this as:
H > MAXH251.1 OR H1 > MAXH251.2
You would need to change the 251 to something else if you wanted to check for a new high over another period. For example, a Condition Formula to check for a new 20-Period High happening during the most recent 2-bars could be written as:
H > MAXH19.1 OR H1 > MAXH19.2
Personal Criteria Formula Conditions
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
You can then use the Condition Formula as a WatchList Column to sort.
Sort with Criteria from the Library
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Platinum Customer
Joined: 5/31/2005 Posts: 16
|
Actually I only want it to look back 2 days and have current price making a high above the high print of just 2 days ago.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
If you want the current high to above the high of 2-bars ago:
H > H2
If you want the current high to above both the high of 1-bar ago and the high of 2-bars ago:
H > MAXH2.1
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Platinum Customer
Joined: 5/31/2005 Posts: 16
|
Thanks Bruce that is working to pull out the stocks that have mad ea 2 day day high. Is there now a way to have it only show those that are currently making this new high and those that have remained above this breakout.
For example sorting the Sp-500 charts it is checking AON. Yes the stock made a 2 day high but currently has slipped below that breakout. Maybe that is asking to much of the software.
I set did set the sort to update every minute but of course it is still returning the same charts.
Again thanks for you help.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You could check for the close to above the high of 2-bars ago:
C > H2
Or above both the high of 1-bar ago and high of 2-bars ago:
C > MAXH2.1
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Platinum Customer
Joined: 5/31/2005 Posts: 16
|
Thank you so much Bruce. That is returing what I was looking for. It's amazing you were able to help me when I clearly did not know how to ask the correct question. LOL
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |