Quantopian's community platform is shutting down. Please read this post for more information and download your code.
Back to Community
SEC Tick-Pilot Filter

Is there a way to somehow filter stocks out that are in the 5c pilot program? I apologize if this has already been asked / answered but I couldn't find any results, thanks!

3 responses

my worthless two cents on this since only heard about it in passing would be to filter it out by either

  1. run a min. mkt cap requirement (think 5c applies only to under $3b mkt cap)
    a. .filter(fundamentals.valuation.market_cap > (3 * 1e9)) if using fundamental_df
    b. If pipeline: add below and use as a filter
    market_cap = morningstar.valuation.market_cap.latest
    market_cap_filter = (market_cap > 3000000000)

  2. or alternatively use fetcher to exclude stocks from ftp://ftp.nyxdata.com/Tick_Pilot/TSPilotSecurities20161230.txt (this seems to be updated daily) – see https://www.quantopian.com/help#overview-fetcher

personally would go with option 1

actually thinking about it again, option 1 could cause all under $3b cap to be weeded out and not just 5c pilot so two would be the more sure bet ... that being said, including that lower mkt cap segment will come likely with low trade volume causing a whole host of different issues depending on what you are trying to do

The 3b market cap idea would be easier for sure, but I'll definitely want them unsliced so i'lol start digging into fetcher.

Thanks for the reply, I've only been into this stuff for about a week now so people like yourself are a huge help and it is much appreciated.