Fund Correlation Analysis

Problem

Fund portfolio analysis often requires judging whether several tickers move together, especially QDII funds, ETFs, and actively managed funds. Common needs include assessing the relationship between overseas and domestic assets, comparing how closely index ETFs track each other, and checking how well active funds align with benchmark indices. Manually collecting NAV data, aligning dates, calculating correlations, and formatting reports can be error-prone around fund codes and data sources.

How It Works

The skill uses a two-interface AkShare workflow:
- Takes at least two six-digit fund codes, covering ETFs, open-ended funds, LOFs, QDIIs, money market funds, and bond funds
- Uses ak.fund_name_em() to load fund names from Tiantian Fund, and ak.fund_open_fund_info_em() to fetch historical NAV
- Fetches data for 3m, 6m, or 12m windows, aligns return series to the minimum common length, and computes the Pearson correlation coefficient
- Outputs table, csv, json, or html; HTML reports include a color-coded matrix, legend, and pairwise details

Boundaries

Correlation measures only linear relationships and does not replace drawdown, volatility, or tracking error metrics. Some QDII data may be delayed, and historical correlation does not imply future behavior. Compare multiple time windows and interpret strong, weak, and negative correlations separately.