Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Different format report compare CIK 1067983 vs 1541617 #34

Closed
IgBell opened this issue Apr 1, 2020 · 6 comments
Closed

Different format report compare CIK 1067983 vs 1541617 #34

IgBell opened this issue Apr 1, 2020 · 6 comments

Comments

@IgBell
Copy link

IgBell commented Apr 1, 2020

For Berkshire, program gives nice txt with tables in it, for Altimetr capital, it gives txt, but like xml file if open. Check out CIK 1067983 vs 1541617.

@jadchaar
Copy link
Owner

jadchaar commented Apr 1, 2020

Hey @IgBell, can you give me a specific example like a URL and/or a screenshot of what you are speaking of? Also, which form type are you trying to download?

@IgBell
Copy link
Author

IgBell commented Apr 1, 2020 via email

@jadchaar
Copy link
Owner

jadchaar commented Apr 1, 2020

Hey @IgBell, sadly this is something that is out of my control and must be a matter of the 13F format and SEC requirements changing over the years. Notice how the Berkshire 13F is from 2009 but the Altimeter Capital filing is from 2012.

If I do the following, I get very similar formats of the submission files (an XML-like file):

env ❯ python3
Python 3.7.3 (v3.7.3:ef4ec6ed12, Mar 25 2019, 16:52:21)
[Clang 6.0 (clang-600.0.57)] on darwin
Type "help", "copyright", "credits" or "license" for more information.
>>> from sec_edgar_downloader import Downloader
>>> dl = Downloader()
>>> dl.get("13F-HR", "1067983", 1)
1
>>> dl.get("13F-HR", "1541617", 1)
1

To give you a sense of what this tool is doing, it downloads the complete submission txt file here, for example: https://www.sec.gov/Archives/edgar/data/1067983/000095012320002466/0000950123-20-002466-index.htm.

SEC formats change over the years and are kind of a wild west since there are very lenient formatting requirements for filings. I am planning to add support for downloading XML/HTML files in the future (#32), so this could help alleviate the issues you are seeing. Stay tuned.

@IgBell
Copy link
Author

IgBell commented Apr 1, 2020

got it, it will be much easier if it'll be possible to download 13fInfoTable.html
there are some nice ready-made solutions to work with it, Complete submission text file is harder to parse into dataframe to compare (well, maybe for me as a rookie). My idea was to merge your code with this one
https://briancaffey.github.io/2018/01/30/reading-13f-sec-filings-with-python.html
Thank you,
Igor

@IgBell
Copy link
Author

IgBell commented Apr 1, 2020

Reading 13F SEC filings with python
in case you can't open the link, copy-paste the link directly to a browser.

@jadchaar
Copy link
Owner

This should hopefully be fixed by #32, so I am closing this issue for now.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants