# MF Portfolio Holdings Analyzer with Python pipeline

MF Portfolio Holdings Analyzer with Python pipeline

## Links
- App: https://chatgpt.com/g/g-68d684965d888191bf81f02022dd3591-india-mutual-funds-portfolio-holding-analytics
- Docs: https://tigzig.com/app-documentation/gpt-mf-holding-analyzer.html

## Tags
chatgpt-integrations, portfolio-analysis

## Documentation

    - [Try the GPT](https://chatgpt.com/g/g-68d684965d888191bf81f02022dd3591-india-mutual-funds-portfolio-holding-analytics)

# 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](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](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.