Download SEC Form 13F data sets in file formats that are analysis ready including Excel, Google Sheets, CSV, and JSON.

The Securities and Exchange Commission (SEC) requires institutional investment managers in the United States with $100M or more in assets to report their holdings once a quarter using Form 13F. As a result, the 13F data set is a treasure trove of investment data revealing what firms like Berkshire Hathaway (Warren Buffet) and BlackRock buy and sell. Learn more about SEC Form 13F from Investopedia, SEC Form 13F FAQ, and the 13F form itself (PDF).

Download

Excel (.xlsx)

Start analyzing 13F data immediately in Excel. Data partitioned by institutional manager name.

DOWNLOAD | DATES | SIZE

2019Q2.xlsx | 2019Q2 | 152MB

2019Q3.xlsx | 2019Q3 | 142MB

2019Q4.xlsx | 2019Q4 | 140MB

2020Q1.xlsx | 2020Q1 | 143MB

Most.Recent.Data.Set.xlsx (Subscribe Now)

Email me if you're interested in seeing this data organized in different ways. I can supply the files.

CSV (.csv)

Download the 13F data set as a CSV and import it anywhere (like a database or a python notebook).

DOWNLOAD | DATES | SIZE

2019Q2.csv | 2019Q2 | 295MB

2019Q3.csv | 2019Q3 | 276MB

2019Q4.csv | 2019Q4 | 273MB

2020Q1.csv | 2020Q1 | 277MB

Most.Recent.Data.Set.csv (Subscribe Now)

Email me if you're interested in seeing this data organized in different ways. I can supply the files.

JSON (.json)

Download the 13F data as JSON objects. It's partitioned by date and ideal for importing into HIVE (Example JSON Object).

FOLDER | DATES

2019Q1- 2020Q1 Folder of JSON Objects| 2019Q1 - 2020Q1

Folder containing the most recent data (Subscribe Now)

Sample Analysis

The charts below show Berkshire Hathaway holdings. One chart is for Q42019 and the next chart is for Q12020. You can see substantial changes such as an increase in holdings of Apple.

Data Set Column Definitions

Learn what each column in form 13F means. Below are summary definitions. Full definitions with example data are in this spreadsheet.

name_of_issuer

The stock owned by the asset manager.

title_of_class

Examples include, "COMMON STOCK", "FOREIGN EQUITIES", "REIT", "MUTUAL FUNDS-EQUITIES".

cusip

The CUSIP number is a unique identification number assigned to all stocks and registered bonds in the United States and Canada, and it is used to create a concrete distinction between securities that are traded on public markets.

value

Values in thousands of the shares owned (so the number "2" equates to a value of "$2,000" USD)

ssh_prn_amt

Number of shares owned.

ssh_prn_amt_type

The "type" of shares owned.

voting_authority_sole

Share count with "sole" voting authority.

voting_authority_shared

Share count with "shared" voting authority.

voting_authority_none

Share count with "no" voting authority.

cik

From the SEC: "A CIK number is a unique ten digit number we assign to companies that file with the SEC."

fid

Form identification number (related to the Edgar submission process)

company_name

Name of the asset manager that submitted the form.

form_type

There are several types of 13F forms detailed here.

date_filed

Date the 13F form was filed.