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 first if you have raw Excel files.
How to Use
#- Prerequisite: convert raw MF files using MF File Converter
- 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
