In the fourth quarter of 2011, I decided that I needed to analyze the 13F filings of major investors who I thought were bright. ?The first stage was looking at track records, and then finding the 13F filings. ?Some investment management companies ?make them difficult to find. ?And, prior to three quarters ago, formatting issues allowed managers to make it a lot more difficult to compare 13F data across managers.
But now data must be submitted in a uniform format, using extensible markup language [XML]. ?That can be fed into Excel with little effort, and much of the prior data scrubbing goes away. ?That data scrubbing took an extra day at least.
That said, the central challenge for someone that does not have a Bloomberg terminal is converting the CUSIP numbers [Committee on Uniform Securities Identification Procedures numbers] into ticker symbols. ?Those numbers are owned by the American Banking Association, and they charge a pretty penny to use them. ?I asked the folks at AAII [American Association of Individual Investors] to include a CUSIP field ?in their deluxe stock screening package, and they said something like, “Are you kidding? ?Do you know what the American Bankers Association charges for it?!”
When I started, I asked my bright, then 12-year old daughter to build up our own CUSIP to Ticker database. ?She worked for many hours, producing a significant database for which I paid her well. ?Since that time, I have maintained that database.
After I download via XML all of the manager reports that I want to follow, I sort out all of the CUSIPs I have never seen before, and find their tickers.
What used to take a week now takes a little more than a day in total, start to finish.
One thing that I do differently than some others in analyzing 13F filings is that I am interested in what percentage of the market capitalization the positions represent, and how large the net increase in positions is relative to market capitalization.
After that I look at three things:
- What are the largest holdings as a group as a whole as a percentage of market cap,
- What are the largest net increases in holdings as a group as a whole as a percentage of market cap, and
- What ideas are new, that no one invested in last quarter, and two or more invested in this quarter?
Now I am not saying that I have the formula right, but this feels right to me. ?I invite readers to suggest their own ways of screening through 13Fs to determine the most worthy investment ideas.
But before I leave for the evening, another boon: here are the tickers generated by my 13F methods this quarter:
AAL, ADT, ALSN, AN, BCS, BIOS, BRX, CAM, CAR, CCI, CLH, COH, CSLT, CSTM, CTRP, CTXS, CYH, DAR, DDC, DSW, DV, DVA, ENDP, ENT, EPE, ESRT, EVTC, FLXN, GHC, GLPI, GME, GS, HMHC, HOLX, HW, IBP, IDIX, JNPR, KATE, KIN, KN, KSU, LNN, LPNT, MDR, MTOR, NADL, NCLH, NMIH, NUAN, PAH, PBF, PHH, PLCM, POST, QEP, QLIK, RCII, RDN, REIS, RFMD, RH, RLD, RPXC, SBAC, SC, SFUN, SNMX, STAY, SWI, SYMC, TDG, TLM, TLMR, TQNT, TRLA, TRW, TWI, USG, VECO, VIPS, VOCS, VOXX, VRTX, WPP, XL, XONE, YRCW, ZINC
After the last few articles, you know almost all of the companies that I am considering investing in versus my current portfolio. ?Have look as you like, and maybe a few of them are good investment ideas.
I notice there are some sub $1B market caps among these names. Is there a minimum market cap under which you would not invest?
My minimum market cap for investment is $100 million.
Just in case you wanted to automatise the CUSIP to ticker phase, you can screen scrape the map from various websites pretty easily. If the raw CUSIP fails, you can use the ISIN (“US” + CUSIP + the computed check digit for US stocks). For example, from the Stoxx website, for Apple:
http://www.stoxx.com/indices/component_information.html?isin=US0378331005
For some reason, that site won’t load for me. Thanks for the idea, though.
Thanks for your post. I’m curious why you use total holding as a % of market cap rather than AUM. I think % of AUM would show levels of conviction; I guess % of market cap could signal potential liquidity issues. Or am I off track here?
Thanks again.
I would compare it to AUM if I were analyzing manager by manager. I look at what the 80 managers are doing as a group, net flows, and aggregate amounts held as a fraction of each stock’s market cap.
Is this list generated using the same group of managers that you have mentioned in the past? I believe the post was on idea generation.
Largely so — names get added and dropped as time goes by, but it is largely the same list.