- Case Study -
Fund-of-Funds 13F Filings Database
Large Manhattan-based Fund of Funds.
A Fund of Funds (FoF) manager had 10 years worth of 200 hedge fund proprietary meeting data residing inside of their CRM (Dynamo Software) and sought to combine that with 13F filings to gain a complete picture of their current and potential investments.
Extracted 7+ years of quarterly-level history, 20k issuers, and 6k investors, and stored in modern TimeScaleDB a time series database, where it covered securities like common stock, funds, calls, puts, warrants, and debt.
Years of 13F History
13F Issuers Extracted
Hedge Funds In-Depth
We provide a wide array of cutting-edge services required to fully build a fast data pipeline.
We offer a "simple" approach to designing so called complex systems with an emphasis on Design and DevOps.
A simple interface to harmonized holdings
The client was able to use Python, R, and Apache Superset, to access their data very easily, simply providing a range of effective dates, list of symbols, and number of observations desired, and the data is brought back neatly into their data analytical tool of choice in it's native structure.
Unique proprietary data integrated
This customer had many years of useful data points that they collected from in-person meetings, quarterly emails, PDF's, and performance reports. We built extractors, including use of NLP and built a world class database that stores neatly organized data such that it cane be integrated with 13F's for greater insights.
Immediately updated 13F database
Advanti created a process that runs in the cloud which watches for new 13F's, and when they arrive, a serverless ingestion process is kicked off, tearing through the data in parallel, structuring it very nicely into a time series form, and pushing it into the clients database.