- Case Study -

Fund-of-Funds 13F Filings Database

 

compass

 

Client Type

Large Manhattan-based Fund of Funds.

Business Context

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.

Outcome

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.

0

Years of 13F History

0

13F Issuers Extracted

0

Hedge Funds In-Depth

Services

Pipeline engineering

We provide a wide array of cutting-edge services required to fully build a fast data pipeline.

 

Focus

Simplification

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.

 

Interested in a Fund of Fund Database? 

No problem, reach out to us, and we're happy to talk about creating a fund of funds time series database that will support your unique needs!

 

Talk to us