# MF Portfolio Analyzer: Holdings Change Analysis

Automated data quality checks, ISIN standardization, and human-in-the-loop corrections for mutual fund portfolio analysis.

- Download Excel (.xlsm): https://www.tigzig.com/files/xlwings/XLWINGS_PORTFOLIO_ANALYZER.xlsm
- Watch Video Guide: https://youtu.be/U7RwHxRkOao

## What This App Does

A pipeline for analyzing mutual fund portfolio holdings across two periods:

- **Smart file import:** auto-detects CSV/TXT/pipe-delimited formats

- **2-period detection:** auto-identifies the latest two months

- Automatic ISIN name standardization and deduplication

- Data quality validation reports

- Human-in-the-loop correction workflow

- Summary analysis tables with holdings changes

- Automated Top 10 holdings charts

#### Important Note

Requires standardized text files. Use [MF File Converter](/mf-files-ai) first if you have raw Excel files.

## How to Use

- **Prerequisite:** convert raw MF files using [MF File Converter](/mf-files-ai)

- **Download & Install:** get the app and install xlwings Lite

- **Import Data:** click "Import Data" on Control Sheet

- **Run Stage 1:** review ISIN_Mapping sheet

- **Manual Correction:** fix grouping issues if needed

- **Run Stage 2:** generate final analysis

- **View Results:** check Summary_Analysis and Charts

## How It Works

A 3-step workflow for data quality and accuracy:

### Smart Detection

- File import: auto-detects CSV/TXT/pipe formats

- 2-period detection: identifies the latest two months automatically

### ISIN Standardization

- Handles name variations (HDFC, HDFC Bank Ltd, etc.)

- Selects the best name for each ISIN

- Name truncation to identify conflicts

### Human-in-the-Loop

- Namecut_Exceptions and Multiple_ISINs reports

- User edits ISIN_Mapping for accuracy

- Stage 2 uses the corrected mappings

## Resources

- [xlwings Lite](https://lite.xlwings.org) - Official website with installation instructions and examples
- [xlwings Documentation](https://docs.xlwings.org/en/latest/) - Comprehensive documentation with Excel object reference and API docs

---
Source: https://www.tigzig.com/mf-portfolio-processor

---
Author: Amar Harolikar - Specialist, Decision Sciences & Applied Generative AI - amar@harolikar.com - https://www.linkedin.com/in/amarharolikar
Source: https://www.tigzig.com/mf-portfolio-processor
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