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 |

personal criteria formulas Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
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?

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.
Users browsing this topic

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.