New Members: Be sure to confirm your email address by clicking on the link that was sent to your email inbox. You will not be able to post messages until you click that link.
Scan for Stocks that do not yet have 200 Day SMA - Recent IPOs
Looking to add a scan criteria that will show stocks that have not yet traded for 200 days (stocks without a 200 day SMA). So really stocks that have had their IPO in the last 200 days. I can't seem to find anything online for this, if anyone could help!
You can create a ChartList from another source and then run scans against that list. I just googled IPO in the last 200 days and there were several results. I can't vouch for any of them being accurate but, that is how I'd create a scan on IPO's
[ [exchange is NYSE] or [exchange is NASD]]
rank by ROC(200)
and download the results as a CSV file, symbols trading for less than 200 days will appear at the top of the list with no value in the last column (ROC(200).
Copy the symbols only from the those rows and use the "Add Many" option to put them into a list.
So the 36 blanks are stocks that have traded less than 200 days. Those are the stocks of interest (presumably they are IPOs if they have traded less than 200 days - although some could be mergers or new tickers). The rest don't matter.
You could try to narrow the results by specifying sectors, but some it seems IPOs don't get sector assignments for a while, so that method might miss some.
If you use the link like the one I shared, there are 64 stocks listed on that site that are within 200 days of the Offer Date currently. I don't believe you can create a scan for IPO's currently on the StockCharts workbench. if you could do Nulls, or Blanks that would be both much easier and an unbelievably fun addition to the scan language. Then you could scan for IPO. You'd still get the preferreds but still managable.
You can't scan for nulls or blanks so the code you posted just looks for the stocks in the NYSE or NASD and returns a list the 1st to last, A to Z, gets to 999 results and then sorts those by the ROC 200. Like I said it only exported A to part of C. Then, sorting those A to C's you get the blanks in there as well as the others. The scan isn't looking for anything really, and then giving the list a sort. It's not like it's returning ALL of the stocks and then sorting.
I don't believe that you can scan for IPO on stockcharts without a Date Offered or Date Listed field, OR without the capability to use Null or Blank as an option. If you had the Null or Blank option you could put something like and 201 days ago Close = Null or Blank
Sounds like this is right. It does the alpha sort first. So you would have to have criteria that limits the result to less than 999 first. Maybe by one exchange and then by each sector. So 22 scans. But you would still have the problem of "false positives". So a reliable outside source, as you suggest, is probably most efficient if you can get a .csv or other compatible download file.
I rarely import a CSV file unless I have modified the data to get more information into the chart. Column A is the symbol. Column B is imported into the Name field. Column C is imported into the Notes field.
I'm getting the same issue ranking by ROC, only getting 30+ results with a null value.
Using iposcoop and manually putting them into a chartlist seems like a good alternative.
'Next up, the present. Dave Landry and I were chatting this week about an important yet often-overlooked feature of the StockCharts platform: our dedicated "IPO Listings" page. This is a great way to find some of the market's newest listings and latest symbol additions on StockCharts. With links to all of our charting tools right there in the table, you can see what's new and quickly click in to start charting these recent IPOs. Plus, as part of our "Recent Data Adjustments" resource, the menu above the table will also allow you to see splits, dividends, symbol changes and other corporate actions. Check it out!'
Also the look back ought to be extended - at least 200 days.