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
Dedicated app for converting raw AMC Excels to the standardized CSV (recommended, faster than the GPT)
Takes the standardized CSV and runs validation, ISIN mapping, duplicate detection, and two-period composition drift
Plain-text context file for feeding to AI agents about this GPT