# MF Portfolio File Converter

Custom GPT that converts raw monthly mutual fund portfolio Excel disclosures into a standardized CSV format, ready for further analysis.

- Try Portfolio Analyzer GPT: https://chatgpt.com/g/g-b6a7uHe84-mutual-fund-portfolio-analyzer
- LLM Context (.txt): https://www.tigzig.com/llm/gpts/mf-portfolio-analyzer.txt

## What This GPT Does

This GPT serves two main purposes:

- **Portfolio Processing:** Parse and analyze monthly mutual fund portfolio disclosure Excel files

- **GPT-Python Integration:** Demonstrates how a Custom GPT can execute custom Python code

- Process different Excel file formats from various funds

- Generate consolidated CSV output

- Create validation files for data verification

- Perform custom analysis on request

## How to Use

Follow these steps to analyze mutual fund portfolios:

- **Upload Files**

 Share the monthly portfolio Excel file

- Provide the schema information file

- **Specify Schema Details**

 Data start row number

- Column mappings (company, instrument, value, ISIN, etc.)

- **Get Results**

 Receive consolidated CSV file

- Get validation file for verification

- Request specific analysis as needed

- **Need Help?** Just ask the GPT "How do you work?" or "What do you need?"

## Technical Details

The GPT uses a custom Python backend created with GPT assistance for data processing:

### Processing Pipeline

- Custom Python script for file processing

- Schema-based Excel parsing system

- Flexible column mapping configuration

- Automated CSV generation

- Validation file creation

### Required Schema Information

- Data start row specification

- Company name column mapping

- Instrument details column mapping

- Market value column mapping

- ISIN number column mapping

#### Current Use Case

Demonstrates the integration of Custom GPT with Python code for processing monthly mutual fund portfolio disclosures. The system handles various Excel formats, generates standardized outputs, and provides analysis capabilities while showing how GPTs can execute custom code.

## Resources

- [MF Files AI App](https://www.tigzig.com/mf-files-ai) - Dedicated app for converting raw AMC Excels to the standardized CSV (recommended, faster than the GPT)
- [Companion GPT: MF Portfolio Processor](https://www.tigzig.com/gpt-mf-holding-analyzer) - Takes the standardized CSV and runs validation, ISIN mapping, duplicate detection, and two-period composition drift
- [LLM Context (.txt)](https://www.tigzig.com/llm/gpts/mf-portfolio-analyzer.txt) - Plain-text context file for feeding to AI agents about this GPT

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

---
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-analyzer
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