Institutional investor (e.g., Berkshire Hathaway, Point72, Pershing Square) data analysis from 13F
Hey all - I recently was laid off as part of a restructuring so I have some time on my hands. As a means to improve my own investing process I’ve been working on building a database of institutional investor activity from 13F data sets ([the data sets linked here](https://www.sec.gov/data-research/sec-markets-data/form-13f-data-sets), [13f data requirements here](https://www.sec.gov/files/form13f.pdf)). I’m starting with just snapshots from the most recent filing, but will plan to add time series analyses in subsequent iterations, but what other data specifically from 13F filings should I be looking at / would be interesting to you all?
The views of the data I am looking at are below (each one is a table)
**Institutional investor overview: List of all institutional investors in the 13F dataset.**
* Fields include:
1. Institutional investment firm name
2. Total # of portfolio positions (with columns splitting equity and debt)
3. Total portfolio value $(with columns splitting equity and debt)
4. Equity vs. debt as a % of total portfolio value
5. Average position sizes (with columns calculating same for equity and debt)
* Here is an example of one row, I chose JPMorganChase at it was the largest in the dataset (albeit not particularly interesting from an investing perspective).
|filingmanager\_name|Total # of Positions|\# of Equity Positions|\# of Debt Positions|Total Value ($M)|Equity Value ($M)|Debt Value ($M)|Equity Value %|Debt Value %|Total # of Equities (M)|Average Position Size $M|Average Equity Position Size $M|Average Debt Position Size $M|
|:-|:-|:-|:-|:-|:-|:-|:-|:-|:-|:-|:-|:-|
|JPMORGAN CHASE & CO|9669|9214|456|6105030|6094644|10386|99.8|0.2|60504|631.4|661.5|22.8|
**Portfolio snapshot: What is the makeup of a given institutional investors portfolio?**
* Fields include:
1. Institutional investor name (filingmanager\_name)
2. Name of company (name of issuer)
3. Equity or debt (SH = Shares)
4. For options - put or call (NULL if just shares)
5. $ value of position
6. \# of shares held or aggregate principal value for debt
7. Portfolio weight - individual position value as a % of total portfolio value
* Here is an example for Berkshire Hathaway's position in Apple (there would be rows for all of an investors positions)
|filingmanager\_name|nameofissuer|sshprnamttype|putcall|Position Value ($M)|\# of Shares (M) / Principal Value ($M)|Portfolio Weight (%)|
|:-|:-|:-|:-|:-|:-|:-|
|Berkshire Hathaway Inc|APPLE INC|SH|NULL|75126|300|28.1|
**Company snapshot: Which institutional investors hold a given company or group of companies securities?**
* Fields include:
1. Company (name of issuer)
2. Institutional investor name
3. CUSIP to identify the security
4. $ value of investors holding
5. \# of shares held by the investor or principal amount
6. Equity or debt (SH = Shares)
7. % of institutional ownership - this investors # of shares as a % of total institutional investor share ownership
* Here is an example row for the company Danaher:
|nameofissuer|filingmanager\_name|cusip|Position Value ($M)|\# of Shares (M) / Principal Value ($M)|sshprnamttype|Percent of institutional share ownership (%)|
|:-|:-|:-|:-|:-|:-|:-|
|DANAHER CORPORATION|VANGUARD GROUP INC|235851102|13715.6|59.8|SH|8.7|
To spark some conversation - would love to hear from all of you:
1. Do these tables include the data on institutional investor holdings that you are most curious about? What other information or metrics would be useful/informative for investing?
2. Would this data be useful for your investing / trading processes? What other institutional investor data do you look at?
3. From the existing free websites that provide this data - what data / metrics do you typically review that they don’t provide? Examples sources are:
1. [https://whalewisdom.com/](https://whalewisdom.com/)
2. [https://13f.info/](https://13f.info/)
3. [https://fintel.io/latest-13f-filings](https://fintel.io/latest-13f-filings)
4. [https://en.macromicro.me/13f](https://en.macromicro.me/13f)