WRDS 13F Holdings Data and Recent Thomson Data Issues
undefined
Introduction to WRDS 13F Holdings Data
13F Holdings Data on WRDS
•
Thomson/Refinitiv Institutional (13f) Holdings - S34
•
Stock holdings
•
1980 - present
•
Factset Ownership v5 - 13F Historical Institutional Holdings
•
Stock holdings
•
1993 - present
•
WRDS 13F Holdings
•
All holdings, including bonds and options if reported
•
“As filed”, 2002 - present
•
“Complete” since 2013 June
•
The SEC began requiring institutional investment managers to file their 13F reports in XML format in
2013. Prior to that, the reports were filed in a text-based format.
2
Example: WRDS 13F Holdings
•
WRDS SEC Analytics Suite - 13F Holdings Data
•
1
3
F
h
o
l
d
i
n
g
s
i
t
e
m
i
z
e
d
h
o
l
d
i
n
g
s
•
Example: GE, CIK=40545
•
WRDS SEC Analytics Suite - 13F Summary Data
•
1
3
F
h
o
l
d
i
n
g
s
s
u
m
m
a
r
y
a
t
h
o
l
d
i
n
g
c
o
m
p
a
n
y
l
e
v
e
l
•
Example: GE, CIK=40545
•
https://www.sec.gov/edgar/browse/?CIK=40545&owner=exclude
•
https://www.sec.gov/Archives/edgar/data/40545/000004054522000033/xslForm13F_X02/primary_doc.xml
3
WRDS 13F Linking to Other 13F Data
•
WRDS 13F CIK-MGRNO Link (wrds_13f_link)
•
/wrds/sec/sasdata/wrds_13f_link
•
https://wrds-www.wharton.upenn.edu/data-dictionary/wrdssec_all/wrds_13f_link/
4
Recent Thomson 13F Data Issues
5
Faculty report missing
Thomson/ Refinitiv
13F holdings 60%-70%
in 2019Q3Q4
2022 March
Present
Day
Recent Thomson 13F Data Issues
6
2022 March
Present
Day
April
Thomson patched
S34 Data for 2019Q3Q4
Recent Thomson 13F Data Issues
7
2022 March
Present
Day
April
Thomson patched
S34 Data for 2019Q3Q4
Thank You!
Delve into the realm of 13F holdings data on WRDS, covering historical stock holdings, factset ownership, and SEC requirements. Explore examples, linking to other data, and recent issues with Thomson 13F data. Stay informed about the evolving landscape of institutional investment data.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
E N D
Presentation Transcript
13F Holdings Data on WRDS Thomson/Refinitiv Institutional (13f) Holdings - S34 Stock holdings 1980 - present Factset Ownership v5 - 13F Historical Institutional Holdings Stock holdings 1993 - present WRDS 13F Holdings All holdings, including bonds and options if reported As filed , 2002 - present Complete since 2013 June The SEC began requiring institutional investment managers to file their 13F reports in XML format in 2013. Prior to that, the reports were filed in a text-based format. 2
Example: WRDS 13F Holdings WRDS SEC Analytics Suite - 13F Holdings Data 13F holdings itemized holdings Example: GE, CIK=40545 WRDS SEC Analytics Suite - 13F Summary Data 13F holdings summary at holding company level Example: GE, CIK=40545 https://www.sec.gov/edgar/browse/?CIK=40545&owner=exclude https://www.sec.gov/Archives/edgar/data/40545/000004054522000033/xslForm13F_X02/primary_doc.xml 3
WRDS 13F Linking to Other 13F Data WRDS 13F CIK-MGRNO Link (wrds_13f_link) /wrds/sec/sasdata/wrds_13f_link https://wrds-www.wharton.upenn.edu/data-dictionary/wrdssec_all/wrds_13f_link/ 4
Recent Thomson 13F Data Issues Faculty report missing Thomson/ Refinitiv 13F holdings 60%-70% in 2019Q3Q4 Present Day 2022 March 5
Recent Thomson 13F Data Issues Thomson patched S34 Data for 2019Q3Q4 Present Day 2022 March April 6
Recent Thomson 13F Data Issues Thomson patched S34 Data for 2019Q3Q4 Present Day 2022 March April 7
