Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Worden Discussion Forum » Customer Training & Support » Ask a Trainer - TC2000 version 7 » personal criteria formulas

personal criteria formulas Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
stone1
Posted : Friday, March 4, 2011 5:56:53 PM
Registered User
Joined: 3/16/2005
Posts: 1

What would be the formula for IPO'S within the last 52 weeks?
Back to top
jlsmith
Posted : Friday, March 4, 2011 9:59:14 PM
Gold Customer Gold Customer

Joined: 3/28/2005
Posts: 31
 No need for a pcf formula. Just plot a 52 bar simple moving average on a weekly chart and sort all stocks by the absolute value of this average. Stocks trading less than 52 weeks will show a value of zero in the sort column. Flag these and move them to their own watchlist. The problem, at least with 2007, is that you'll get a bunch of etf's in the new watchlist. You can get rid of most of these by flagging everything in the etf watchlist and then removing all flagged items from your new watchlist. If version 11 has a watchlist consisting of only common stocks, then this latter problem is solved.
Back to top
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.