MF Excel to CSV (GPT)
Custom GPT that converts raw monthly mutual fund portfolio Excel disclosures into standardized CSV format, ready for further analysis
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