caifubu-equity-performance

Analyze outsourced product NAVs and equity fund holdings into an Excel performance report.

Updated Jan 25, 2026

Search Tags:#excel-report #fund-performance #nav-analysis #outsourced-investments #equity-portfolio #weighted-portfolio

Ready to run

npx skills add https://github.com/xfs96192/claude-config --skill caifubu-equity-performance

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: caifubu-equity-performance
Source: https://github.com/xfs96192/claude-config/tree/main/skills/caifubu-equity-performance
Command: npx skills add https://github.com/xfs96192/claude-config --skill caifubu-equity-performance

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, numpy, openpyxl, EmQuantAPI, and includes scripts (resource) components.

What problem does it solve?

委外产品及持仓权益基金业绩分析，帮助用户快速计算净值趋势、涨幅和回撤等关键指标，并生成汇总Excel报告，提升分析效率。

Core Features & Use Cases

净值分析：从委外净值走势 Excel 中读取 NAV 序列，计算成立以来涨幅、2025年度涨幅、今年以来涨幅及相应的最大回撤等非年化指标。
权益基金筛选与加权：从持仓明细筛选公募基金等权益持仓，基于日终市值构建权重，并对权重进行归一化处理以构建加权组合。
输出报告：输出包含汇总表和两个权益持仓明细表的格式化 Excel 报告，便于对比与汇报。
数据源与集成：通过 iChoice API 获取基金累计净值历史，按日终市值进行权重归一化与前向填充，支持端到端分析。

Quick Start

将委外净值与持仓数据导入后运行分析，自动输出汇总Excel报告。

Frequently Asked Questions about caifubu-equity-performance

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I analyze outsourced product NAVs and equity fund holdings to generate a performance report?▼

To analyze outsourced product NAVs and equity fund holdings, ingest NAV time series and holding lists, fetch accumulated NAV data via iChoice, build a value-weighted portfolio, and export a formatted Excel report.

What is the best way to calculate fund performance metrics like maximum drawdown and period returns for an equity portfolio?▼

Calculating fund performance metrics like maximum drawdown and period returns involves reading NAV series from Excel, computing inception and year-to-date returns, and applying value-weighted normalization to selected equity holdings.

How to build a weighted portfolio from equity fund positions and daily market values?▼

To build a weighted portfolio from equity fund positions, filter public funds from holding details, calculate weights based on daily closing market values, normalize the weights, and apply forward-filling for missing data.

Does this outsourced product analysis tool require the iChoice API to fetch accumulated NAV data?▼

Yes, this outsourced product analysis tool requires the iChoice API to fetch accumulated NAV data history for selected eligible equity funds, ensuring accurate end-to-end performance processing.

Can I use pandas and openpyxl to export aggregated fund performance metrics into an Excel report?▼

Yes, you can use pandas and openpyxl to export aggregated fund performance metrics, generating a formatted Excel output containing summary tables and equity holding details for comparison.

What happens if there are missing NAVs in the daily time series during equity portfolio analysis?▼

During equity portfolio analysis, if there are missing NAVs in the daily time series, the tool validates the data and automatically applies forward-filling to handle the gaps and ensure continuous calculations.