# Mutual Fund Analytics Tools for processing mutual fund portfolio disclosures, composition drift analysis, holdings comparison. Indian mutual fund focus. ## Apps (4) ### MF Portfolio Holdings Analyzer with Python pipeline - App: https://chatgpt.com/g/g-68d684965d888191bf81f02022dd3591-india-mutual-funds-portfolio-holding-analytics - Docs: https://tigzig.com/app-documentation/gpt-mf-holding-analyzer.html - AI Docs: https://tigzig.com/ai/apps/gpt-mf-holding-analyzer.md - MF Portfolio Holdings Analyzer with Python pipeline ### MDRIFT - Mutual Fund Composition & Drift Analyzer - App: https://mf-fetch.tigzig.com - AI Docs: https://tigzig.com/ai/apps/mf-drift.md - Serverless mutual fund portfolio analysis app. Tracks holdings drift across 21 Indian mutual funds (5 categories) over multiple time periods. Runs entirely in-browser - no backend needed. ### AI Powered MF Portfolio File Converter - App: https://mf.tigzig.com - Docs: https://tigzig.com/app-documentation/mf-files-ai.html - AI Docs: https://tigzig.com/ai/apps/mf-files-ai.md - Processes Indian mutual fund portfolio disclosure files from Excel to standardized text format. Uses AI-powered schema detection with multi-model validation, ISIN mapping enrichment, and cross-model discrepancy highlighting. ### Process & analyze monthly MF portfolio Excel files - App: https://chatgpt.com/g/g-b6a7uHe84-mutual-fund-portfolio-analyzer - Docs: https://tigzig.com/app-documentation/mf-portfolio-analyzer.html - AI Docs: https://tigzig.com/ai/apps/mf-portfolio-analyzer.md - Process & analyze monthly MF portfolio Excel files ## Blog Posts (11) - [Rolling Returns: Why CAGR Alone Can Mislead You (And What To Use Instead)](https://tigzig.com/post/rolling-returns-why-cagr-alone-can-mislead-you.html) — Tags: mutual-funds, portfolio-analytics, duckdb Explains why point-to-point CAGR is fragile and how rolling returns provide a more reliable picture of fund performance. Covers the difference between rolling window and evaluation period, the ASOF JOIN computation in DuckDB SQL, minimum gap thresholds, CAGR vs absolute return for sub-1-year windows, and how to read each column (average, median, min, max, % negative, observations). Includes validation results across 7,485 data points within 0.50 bps of Excel. Live on MFPRO with 95 funds and 9 indices. AI-readable: https://tigzig.com/ai/posts/rolling-returns-why-cagr-alone-can-mislead-you.md - [Now live - MFPRO v2 - Mutual Fund Analytics (India) - now with rolling returns, custom eval periods, multi-period & multi-instrument comparisons](https://tigzig.com/post/mfpro-v2-mutual-fund-analytics-rolling-returns.html) — Tags: mutual-funds, portfolio-analytics MFPRO v2 release for Indian mutual fund analytics. Adds rolling return statistics (1Y/3Y/5Y windows with average, median, min, max), custom evaluation periods, multi-fund and multi-index return comparisons across 95 funds and 9 indices. Includes downloadable NAV data, Excel templates for independent verification, multi-period holdings comparison, and index constituent analysis. Data from Jan 2013, auto-synced twice daily. AI-readable: https://tigzig.com/ai/posts/mfpro-v2-mutual-fund-analytics-rolling-returns.md - [How I Identify and Map Every Holding — The ISIN Mapping Process](https://tigzig.com/post/mdrift-isin-mapping-process.html) — Tags: mutual-funds Detailed 12-step pipeline for standardizing Indian mutual fund portfolio holdings across 15 AMCs. Covers ISIN lookup against 361,000-record NSDL master, corporate action detection via ISIN serial number analysis, 7-character name-cut deduplication, CD/CP/T-Bill aggregation with synthetic ISINs, foreign stock identification, TREPS classification, human-in-the-loop validation, and grand total verification to the paisa across 96 fund-month combinations. AI-readable: https://tigzig.com/ai/posts/mdrift-isin-mapping-process.md - [MF Composition Analytics With MDRIFT - Interesting Moves in Top Flexi Cap and Focused Funds](https://tigzig.com/post/mdrift-flexi-cap-focused-fund-composition-analytics.html) — Tags: mutual-funds Analysis of top Indian Flexi Cap and Focused mutual funds using MDRIFT composition analytics tool. Highlights include PPFAS holding 12% in US tech, HDFC sitting on 15% cash, SBI Focused with 10% in Alphabet. Compares portfolio compositions across time periods showing entries, exits, weight changes. Nifty index comparisons added for spotting off-index bets. AI-readable: https://tigzig.com/ai/posts/mdrift-flexi-cap-focused-fund-composition-analytics.md - [Releasing MDRIFT - Mutual Fund Composition & Drift Analytics Tool](https://tigzig.com/post/releasing-mdrift-mutual-fund-composition-drift-analytics.html) — Tags: mutual-funds MDRIFT tool release for comparing Indian mutual fund portfolio compositions across funds and time periods. Processes monthly AMC Excel files, standardizes ISINs, handles corporate action remaps, and groups debt instruments. Covers 21 equity funds across Large Cap, Mid Cap, Small Cap, Flexi Cap, and Focused categories. Sept 2025 through Jan 2026 data. Features drill-downs from scheme type to individual ISIN level. AI-readable: https://tigzig.com/ai/posts/releasing-mdrift-mutual-fund-composition-drift-analytics.md - [New Open Source Tool. Mutual Funds Holdings Analyzer. Python in Excel (xlwings Lite). Now Live.](https://tigzig.com/post/new-open-source-tool-mutual-funds-holdings-analyzer-python-in-excel-xlwings-lite-now-live.html) — Tags: mutual-funds, xlwings-lite, python-in-excel Open-source xlwings Lite tool for standardizing and comparing Indian mutual fund portfolio disclosure data. Handles ISIN-based name standardization, corporate action merging, and human-in-the-loop data quality review. Two-stage pipeline: Stage 1 generates data quality reports, Stage 2 produces final analysis after manual review. Built with Gemini CLI. AI-readable: https://tigzig.com/ai/posts/new-open-source-tool-mutual-funds-holdings-analyzer-python-in-excel-xlwings-lite-now-live.md - [Analysis-as-App: Inside India’s Top Midcap Funds: Buys, Sells, Entries and Exits. Interactive Dashboard Release (Analysis-as-App)](https://tigzig.com/post/analysis-as-app-inside-india-s-top-midcap-funds-buys-sells-entries-and-exits-interactive-dashbo.html) — Tags: mutual-funds Interactive dashboard analyzing portfolio changes across India's top 5 midcap mutual funds (Axis, HDFC, Kotak, Motilal, Nippon) managing ~54% of category AUM. Compares May vs August 2025 holdings. Built as a single 150KB HTML file using the MF Processor pipeline with GPT for ISIN standardization. Tracks buys, sells, entries, and exits. AI-readable: https://tigzig.com/ai/posts/analysis-as-app-inside-india-s-top-midcap-funds-buys-sells-entries-and-exits-interactive-dashbo.md - [Monthly MF portfolio files = hours wasted re-formatting. Here’s a tool that fixes it](https://tigzig.com/post/monthly-mf-portfolio-files-hours-wasted-re-formatting-here-s-a-tool-that-fixes-it.html) — Tags: mutual-funds, converters-tools Converter utility for Indian mutual fund monthly portfolio disclosure Excel files. Uses AI-powered schema detection to automatically identify data layouts, cross-validates with multiple models, and outputs clean CSVs with ISIN mapping and standardized names. Includes append, transpose, and audit trail utilities. Available at app.tigzig.com/mf-files-ai. AI-readable: https://tigzig.com/ai/posts/monthly-mf-portfolio-files-hours-wasted-re-formatting-here-s-a-tool-that-fixes-it.md - [AI automation micro-app: MF Portfolio Files Processor. Live app. Open source.](https://tigzig.com/post/ai-automation-micro-app-mf-portfolio-files-processor-live-app-open-source.html) — Tags: mutual-funds, converters-tools AI-powered micro-app for processing Indian mutual fund monthly portfolio Excel files into standardized CSV/database format. Handles varying Excel formats using LLM schema detection (GPT-4o-mini, GPT-4o, Gemini Flash) for column identification and market value extraction. Includes validation diagnostics and manual override. Built with vanilla JavaScript frontend, FastAPI proxy for LLM calls, and domain whitelisting. Open source with Power Pivot analysis example. AI-readable: https://tigzig.com/ai/posts/ai-automation-micro-app-mf-portfolio-files-processor-live-app-open-source.md - [Mutual Fund Allocation Analysis with GPT Power Tools. Custom GPT. Custom Python Code. Multiple Excels.](https://tigzig.com/post/mutual-fund-analysis-custom-gpt-python-multiple-excel.html) — Tags: mutual-funds, custom-gpt Custom GPT for tracking changes in mutual fund equity portfolio allocations across time periods by merging multiple Excel files (up to 10, each in different formats). Uses custom Python code within the GPT for consistent processing instead of ad-hoc approaches. Handles print-formatted Excel files with images. Includes validation summaries and pivot table output. Replicable for any Excel processing use case with minimal modification. AI-readable: https://tigzig.com/ai/posts/mutual-fund-analysis-custom-gpt-python-multiple-excel.md - [Mutual Fund Portfolio Analysis with ChatGPT: Merging and analyzing across multiple excel files](https://tigzig.com/post/fa18de05.html) — Tags: mutual-funds, custom-gpt Using ChatGPT to merge and analyze multiple mutual fund portfolio Excel files (print-formatted, varying formats, containing images) for tracking equity allocation changes over time. Demonstrates merging 12 files in 30 seconds with a single prompt, including handling different filename formats. Covers voice-typed prompt preparation via Google Docs, validation against totals, and option to generate reusable Python code for larger datasets. AI-readable: https://tigzig.com/ai/posts/fa18de05.md ## Related Topics - [Database AI & Text-to-SQL](https://tigzig.com/ai/tags/database-ai.md) - [Python in Excel (xlwings Lite)](https://tigzig.com/ai/tags/python-in-excel.md) - [Claude in Excel](https://tigzig.com/ai/tags/claude-in-excel.md) - [DuckDB - Analytics & Dashboards](https://tigzig.com/ai/tags/duckdb.md) - [MCP Servers & Agents](https://tigzig.com/ai/tags/mcp-servers.md)