MF Portfolio Holdings Analyzer

Processes two-point mutual fund portfolio holdings with deterministic Python pipeline for validation and summary generation

Processes two-point mutual fund portfolio holdings (e.g., May → Aug 2025) with deterministic Python pipeline. Validates totals, builds ISIN mapping, detects duplicates, and generates final summary tables with % changes.

How This Gpt Works

Processes two-point mutual fund portfolio holdings (e.g., May → Aug 2025).

Input = standardized CSV in the required format (month_end, scheme, ISIN, market value, quantity).

Runs a Python pipeline behind the scenes:

• Validates totals (Market Value & Quantity)
• Builds ISIN mapping file (deduplication + standardized names)
• Checks for duplicate or conflicting names (name_cut and ISIN overlaps)
• Generates final summary table with % shares, counts, and % changes

Always deterministic: No placeholder values, no assumptions, no hallucinations.

What It Can Do

Validation reports:

• Totals by scheme and period
• Duplicate name detection (via name_cut)
• ISIN mapping + exceptions

Final summary CSV with:

• Company-level holdings (MV, Qty, % shares, MF counts)
• % change in MV and Qty between periods
• Manual comments (e.g., "Split", "Rights", "Bonus") preserved from ISIN mapping

Outputs are CSV-ready for Excel or BI tools. Results can be pushed into any dashboard.

How To Use It

• Prepare data file
• Convert your monthly portfolio disclosures into the required CSV format
• Either format manually or use the MF Conversion Tool at: app.tigzig.com/mf-files-ai
• Ensure both months' data are appended into one CSV
• Upload file to this GPT
• Immediately receives 3 validation CSVs: Validation totals, ISIN mapping, Duplicate name/ISIN checks
• Confirm or adjust
• Review validation files
• If needed, give GPT corrections (e.g., update ISIN mapping, fix duplicates)
• GPT re-runs pipeline and regenerates outputs
• Get final results
• Download the final summary CSV
• Analyze in Excel, or feed into custom dashboards

SETUP (FOR YOUR OWN DEPLOYMENT):

Quick Overview:

• Get these two files (available in the resources section):
• pipeline.py (full reproducible pipeline)
• custom_instructions.md (system instructions)
• In the Custom GPT builder:
• Apply custom_instructions.md as system prompt
• Upload pipeline.py under Actions schema
• Your GPT will now:
• Accept CSV uploads in the required format
• Generate validation reports → wait for user confirmation → create final summary
• Extend/customize as needed:
• The full Python pipeline is open for editing
• Add new metrics, filters, or visual outputs as you require

Resources

MF Portfolio Holdings Processor:

https://app.tigzig.com/mf-files-ai

Convert & append Excels to CSV format required for the GPT analysis

Complete Source Code:

https://github.com/amararun/gpt-mf-holding-processor

GPT Custom Instructions & Python Code for MF holding processor

Built On

OpenAI's GPT Platform - This custom GPT transforms ChatGPT into a powerful mutual fund portfolio analysis tool, enabling automated processing of two-point holdings data with deterministic validation and summary generation.

Source: tigzig.com | Open source AI tools for analytics, databases & automation | Amar Harolikar