ValueWiki may now be the only financial site showing all funds holding a position in each stock. Thanks to Zach for some nifty programming.
Here’s how it works…
Let’s search for Apple Computer. The ValueWiki Apple Computer article shows a dashboard box stating that 1191 Funds hold Apple in their Top 25 Holdings, making Apple Computer the 25th most held stock by funds.
So every stock on ValueWiki now has a subpage listing all the funds with Top 25 ownership positions. Another upgrade to ValueWiki’s Fund coverage is on each Fund page. We now list the Top 10 Holdings for every US Fund.
How we generate this data
All Funds (aside from private Hedge Funds) make their holdings pubicly available. A fairly accurate portrait of a fund can be garnered from their Top 25 Holdings, or even their Top 10 Holdings, because of portfolio weighting. Zach parsed data for all US Funds (NYSE, NASD, AMEX, OTC) and found that only 4,500 stocks were held in the Top 25 position by US Funds. Ranking this data, Zach was able to discover which stocks were the most widely held by Funds. Due to the large number of ties, there are only 351 ranks. Thus, Apple Computer is ranked 25th out of 351, for stocks held by Funds.
Stocks most widely held by Funds
For those who are curious, these are the Top 10 Stocks held by Funds (in the Top 25 position in a Fund portfolio). The first number is the Stock’s rank, the second number is the total number of Funds holding. The full list of all 4,500 stocks can be found at ValueWiki.
1. BK OF AMERICA CP: 2750
2. GEN ELECTRIC CO: 2734
3. CITIGROUP INC: 2649
4. EXXON MOBIL CP: 2643
5. Microsoft Corporation: 2508
6. JP MORGAN CHASE CO: 2411
7. Cisco Systems, Inc.: 2313
8. PFIZER INC: 2230
9. AMER INTL GROUP INC: 2094
10. PROCTER GAMBLE CO: 1899