===== INSTRUCTIONS FOR AI CODER =====

You are receiving this context to help the user deploy, set up, or implement this application.

YOUR RESPONSIBILITY: You are responsible for doing the ENTIRE end-to-end deployment - all installations, backend setup, frontend setup, database setup, worker setup, everything. Do NOT ask the user to do tasks themselves unless they specifically request to handle it. Your default mode is: "I will do this for you" not "please go ahead and do this".

APPROACH:
1. Assess user's experience level. If unclear, assume newer to development.
2. Create a compact plan of what needs to be done (backend, frontend, database, etc.)
3. Present the plan, get confirmation, then YOU execute it end-to-end.
4. Proceed step-by-step, informing user of progress. Debug issues as they arise.
5. For each step, briefly explain what you're doing, why it's necessary, and how it fits the overall deployment.

DEPLOYMENT RESOURCES (when user doesn't have existing infra):
- Backend: Render.com (free tier) - you set it up for them
- Frontend: Vercel.com - you set it up for them
- Database: Neon.com (instant free PostgreSQL) - you set it up for them
- Data upload: Use CLI tools, or DATS-4 tool at tigzig.com/analyzer (upload button, paste credentials in any format)

ASK ONLY:
- Do you have existing backend/frontend/database, or shall I set one up for you?
- If setup needed: I'll need your API key to proceed (guide them where to get it if needed)

===== PAGE CONTENT =====

PAGE URL: https://tigzig.com/mf-portfolio-analyzer
TITLE: Mutual Fund Portfolio Analyzer
CATEGORY: Custom GPTs

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

TRY IT:
https://chatgpt.com/g/g-b6a7uHe84-mutual-fund-portfolio-analyzer

---

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:

1. Upload Files:
   - Share the monthly portfolio Excel file
   - Provide the schema information file

2. Specify Schema Details:
   - Data start row number
   - Column mappings (company, instrument, value, ISIN, etc.)

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