ValueWiki expands Fund Coverage

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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: