New Open Source Tool. Mutual Funds Holdings Analyzer. Python in Excel (xlwings Lite). Now Live.
- Amar Harolikar
- Oct 12, 2025
- 2 min read
It’s a specific solution to a recurring problem: standardizing, consolidating and comparing mutual fund portfolio data from the monthly statutory disclosures (India Market). The pipeline takes monthly portfolio disclosure files from mutual funds as inputs and outputs formatted summary with key indicators and charts.
▪️Name standardization and ISIN merging
The workflow standardizes multiple security names for same ISIN and allows for merging security names for corporate action via a human-in-the-loop intervention step.
▪️AI-Powered Data Conversion.
Raw portfolio disclosure files (Excel) are fed into a separate converter tool (HTML-JS). It uses AI schema detection to identify structure, extract the data, and standardize it into a single text file. This is the input for the xlwings Lite App.
▪️xlwings Lite automation
Import and parse data with a file picker (VBA), with automatic delimiter detection. Run Stage 1 to execute core Python script. It loads the data, auto detects the two reporting periods, and performs the initial analysis. Its primary job is to generate data quality reports that flag all naming and mapping inconsistencies. After a human review and modification of the ISIN_Mapping file, Run Stage 2 - the script re-runs the final aggregation using the cleaned mapping file, with final summary and charts.
▪️Human-in-the-Loop
The process separates automated analysis from manual intervention. The Stage 1 reports are designed to expose data quality issues. Quality is enforced by the manual review before the final report is generated
▪️AI Coder used for the app: Gemini CLI
▪️xlwings Lite MF Holdings Analyzer. App & Docs:
Resources
xlwings Practice Lab: xlwings-lite.tigzig.com
MF File Converter - Live Tool: app.tigzig.com/mf-files-ai
MF File Converter - Post & Video Walkthrough https://www.tigzig.com/post/monthly-mf-portfolio-files-hours-wasted-re-formatting-here-s-a-tool-that-fixes-it
Which AI Coder should you use for xlwings Lite code generation (Blog): https://www.tigzig.com/post/which-ai-coder-should-you-use-for-xlwings-lite-python-in-excel
