Mutual Fund Portfolio Analyzer

Process & analyze monthly mutual fund portfolio Excel files with ChatGPT and custom Python code

A dual-purpose Custom GPT that processes monthly mutual fund portfolio disclosures and demonstrates custom Python code integration with GPT for data processing.

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

• 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.

Note

This Custom GPT showcases both practical utility in processing mutual fund portfolio disclosures and technical innovation in GPT-Python integration. The Python code was initially developed with GPT assistance, demonstrating the potential of AI-assisted development for practical business applications.

Built On

OpenAI's GPT Platform - This custom GPT transforms ChatGPT into a powerful mutual fund portfolio processing tool, enabling automated Excel parsing and CSV generation with custom Python code integration.

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