Fundalysis
Indian mutual fund analytics: 14 years of monthly portfolios from 37 fund houses, ~72M rows in a 15 GB Postgres, NAVs since 2006, what each fund paid for each share, and an MCP server for AI agents.
- Built a monthly ingestion pipeline (31 scripted AMC downloaders plus hand-fetched houses) that cleans and parses 110,000+ disclosure files (29.9 GB of Excel, PDF and XML, archived in a versioned S3 bucket) into 4.9M+ normalized holdings across 1,951 schemes and 16,000+ securities, covering September 2012 to today.
- Precomputed 5.2M month-over-month position changes (new, added, reduced, sold, exited) and six monthly rollup tables (fund x sector, house x stock, house x sector, house x industry, stock, house), so 'which funds bought this stock last month' is an indexed read, not a join over 14 years of holdings.
- Computed what each fund paid on average for each share it holds (4.7M rows) from 10.9M daily NSE, BSE and foreign prices, carrying cost through 61,900 corporate actions: exact split factors, bonuses, rights at issue price, mergers, and demergers split by market value on the ex-date. 98%+ of cost is priced at actual exchange closes.