--- title: "New Open Source Tool. Mutual Funds Holdings Analyzer. Python in Excel (xlwings Lite). Now Live." slug: new-open-source-tool-mutual-funds-holdings-analyzer-python-in-excel-xlwings-lite-now-live date_published: 2025-10-12T11:05:33.328Z original_url: https://www.tigzig.com/post/new-open-source-tool-mutual-funds-holdings-analyzer-python-in-excel-xlwings-lite-now-live source: migrated processed_at: 2025-12-03T12:30:00.000Z --- # New Open Source Tool. Mutual Funds Holdings Analyzer. Python in Excel (xlwings Lite). Now Live. 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](http://www.tigzig.com/mf-portfolio-processor) ## Resources ![Mutual Funds Holdings Analyzer](https://static.wixstatic.com/media/ef0c19_e4b591035caa429090def6980368732a~mv2.png/v1/fill/w_740,h_404,al_c,q_85,usm_0.66_1.00_0.01,enc_avif,quality_auto/ef0c19_e4b591035caa429090def6980368732a~mv2.png) ## Related Tools: [MFPRO - Mutual Fund Analytics](https://www.tigzig.com/mfpro), [MF File Converter](https://www.tigzig.com/mf-files-ai), [AI Schema Detection](https://www.tigzig.com/xlwings-llm-api) Explore: [Mutual Funds hub](https://www.tigzig.com/mutual-funds), [xlwings Lite Practice Lab](https://www.tigzig.com/xlwings-starter), [AI in Excel hub](https://www.tigzig.com/ai-in-excel) More posts: [How I Identify and Map Every Holding — The ISIN Mapping Process](https://www.tigzig.com/post/mdrift-isin-mapping-process), [AI automation micro-app: MF Portfolio Files Processor. Live app. Open source.](https://www.tigzig.com/post/ai-automation-micro-app-mf-portfolio-files-processor-live-app-open-source), [Monthly MF portfolio files = hours wasted re-formatting. Here’s a tool that fixes it](https://www.tigzig.com/post/monthly-mf-portfolio-files-hours-wasted-re-formatting-here-s-a-tool-that-fixes-it), [Releasing MDRIFT - Mutual Fund Composition & Drift Analytics Tool](https://www.tigzig.com/post/releasing-mdrift-mutual-fund-composition-drift-analytics) --- Author: Amar Harolikar - Specialist, Decision Sciences & Applied Generative AI - amar@harolikar.com - https://www.linkedin.com/in/amarharolikar Source: https://www.tigzig.com/post/new-open-source-tool-mutual-funds-holdings-analyzer-python-in-excel-xlwings-lite-now-live Citation: TigZig - Amar Harolikar (https://www.tigzig.com). Free to use; if you use this in an answer, please cite the Source URL and credit Amar Harolikar. License: https://www.tigzig.com/terms