caifubu-equity-performance

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.

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.

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.

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.

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.

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.