Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Column sorts Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
wdcraf19
Posted : Monday, September 17, 2012 11:36:10 AM
Platinum Customer 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.

Bruce_L
Posted : Monday, September 17, 2012 11:56:03 AM


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
wdcraf19
Posted : Monday, September 17, 2012 12:21:46 PM
Platinum Customer 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.

 

Bruce_L
Posted : Monday, September 17, 2012 12:29:27 PM


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
wdcraf19
Posted : Monday, September 17, 2012 12:42:27 PM
Platinum Customer 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.

 

Bruce_L
Posted : Monday, September 17, 2012 12:45:23 PM


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
wdcraf19
Posted : Monday, September 17, 2012 12:59:51 PM
Platinum Customer 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

Bruce_L
Posted : Monday, September 17, 2012 1:00:49 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.