I have a group of public equity investors I'm interesting and tracking to help with investment idea generation.
Essentially, I'm looking to pull the name of the company of interest out of all the 13F's files in the last 3 months for 5-10 firms in a regular monthly report. Does anyone know a good way to do this?
I've reached out to CapIQ and they say they can't do it in the way I want. They can only give the you links to all the 13F's in one place which is annoying.
Any help would be much appreciated!
whalewisdom.com might get you close
agreed....whalewisdom is a good start
I believe they provide these documents in html format on the sec website. It wouldn't be too hard to write Python code to check the fund SEC edgar url for a new 13f filing daily, and then when you find one download the document and parse the html using something like beautifulsoup. From there you could generate an excel report of the updating holdings. All of this presupposes you know how to code, though.
Also, keep in mind that 13f filings only show long positions, not short positions. The whole point of most hedge funds is to hedge their longs with appropriate shorts, so 13F filings really only tell half the story. It may still be useful for your purposes though.
dataroma is a very useful site
gurufocus also worth a butchers
In what way do you want it?
-
(Financial Data Engineer)
I agree with a previous post. Dataroma has a good selection of investors they follow. You can select an investor and look at their current portfolio composition and you can look at their holding in a particular name over time. You can also search for tickers and see if anyone owns it. They have some supplemental data as well like top buys over last 6 months and quarter. It's easy to use.
this is precisely what ipreo is for
Just as an FYI, 13F's are only filed quarterly. The next filing is due on November 16th, I believe (would check the SEC calendar). So, if you want to compile the firms, you can just pull the SEC filings for the past 2 or 3 quarters. Also, Bloomberg/Factset are fairly up to date as to ownership percentages, so that may be a good resource as well.
Novus has a web-based product, The Novus Ownership Platform, which is the most powerful tool for analyzing 13f filings.
In deserunt est in sed autem eos. Libero nostrum maxime accusantium velit commodi similique. Esse ut sapiente quod maxime voluptas aut repellendus. Quaerat quasi at iusto assumenda.
Dicta perferendis eos dolore quo. Dicta asperiores nemo nihil in accusamus. Fugiat aliquid aut veritatis quo illo odio est. Iusto rerum esse quam eum consequatur quasi.
Voluptas sint nihil repellat itaque omnis temporibus. Excepturi quis nostrum vitae quia explicabo est. Nesciunt asperiores velit rerum corrupti sequi.
Quia quos nam molestiae libero omnis unde blanditiis voluptas. Pariatur eveniet et non eum. Quaerat quia ea ducimus. Fugit eos ipsum atque id error atque velit sed.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...