Does anyone have experience setting up a quant database? What is the most optimal way to structure the tables?
Also are there any good references for transaction cost analysis and risk modeling? Want to start with mainly equities and options.
Thanks for any advice from experienced voices.
| +24 | James Fishback | 9 | 2h |
| +21 | Future of L/S | 5 | 3d |
| +17 | Latest blow up / wind down | 25 | 2d |
| +12 | Looking for Fund to Partner With - LMM Activist | 4 | 12h |
| +10 | SM L/S Compensation? | 3 | 14h |
| +9 | MMHF Central Execution Trajectory/Advice | 1 | 1d |
| +9 | How to prep for credit HF? | 4 | 1d |
| +9 | Moving from credit to equity? | 3 | 4d |
| +4 | Jensen Huang | 1 | 7h |
| +3 | Chefs at Pod Shops | 2 | 3d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Bloomberg terminal
bloomberg terminal is terrible for historical data
It really depends on what you're trying to do ( what type of queries you'll run) and how big the data sets are. You could use a relational database - or one of those nosql ones.
i'm trying to build a securities database. But also interested in being able to query 13f filings.
If it’s timeseries, you should use a columnar database like Cassandra.
it's best to use a vendor for 13f filings (you don't want to download all that stuff yourself and then parse it) and have your securities records easily matchable with the vendor's securities. You'll probably be OK with a relational database structure.
I have the data for 13f filings already so don't plan on scraping it. Have you built a securities database before? I'm mainly looking for the best way to structure the relationships.
It's hard to make suggestions without knowing your requirements, your tech stack, and your skills/experience. With that said, here are some pointers:
https://github.com/alpacahq/marketstore</a">MarketStore -- DataFrame Server for Financial Timeseries Data
https://github.com/timescale/timescaledb</a">TimescaleDB -- Open-source database designed to make SQL scalable for time-series data
https://github.com/man-group/arctic</a">Arctic -- TimeSeries and Tick store
https://github.com/influxdata/influxdb</a">InfluxDB -- Scalable datastore for metrics, events, and real-time analytics
Facere provident quia fugiat sit molestiae nemo quo. Quia corrupti est sit dolores laudantium. Ea quo quasi ut repudiandae possimus. Minima ex ut molestiae quis labore quaerat amet.
Molestiae a inventore omnis modi qui quisquam deserunt eos. Harum amet quidem quis recusandae similique nihil autem. Nihil doloribus eum eos eum odio doloremque.
Veritatis ullam nostrum rerum vitae. Fugiat optio a ducimus ex. Qui voluptatem accusamus voluptate porro explicabo. Provident veritatis temporibus totam quia. Vel numquam est numquam quia sit assumenda commodi.
Cumque suscipit ut laboriosam aut corrupti distinctio ut. Qui odit eos amet error itaque officiis. Necessitatibus beatae atque enim perferendis fugit sit. Autem error officia odio totam quia saepe aut delectus.
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...