golden-portfolio

bysupport whiteocean

Build a client portfolio tracking web application for an investment advisory firm. PURPOSE An internal tool to track individual client investment portfolios across asset classes, compute returns and risk metrics, and display per-client dashboards. [Internal-only / Client-facing with login — pick one and delete the other.] DATA MODEL - Clients: name, client code, PAN (optional/maskable), risk profile, onboarding date. - Holdings, each tagged to a client and an asset class: Mutual Funds, Equities, Fixed Income, IPOs. - Each holding: instrument name, identifier (ISIN / scheme code / symbol), quantity/units, buy date, buy price/NAV, current price/NAV, asset class. - Transactions (for accurate XIRR): date, type (buy/sell/dividend/SIP installment), amount, units, instrument. Support multiple cashflows per holding. CALCULATIONS (show formulas used; do not hardcode results) - Current value per holding and per client. - Absolute return and XIRR (money-weighted, using dated cashflows). - Allocation breakdown by asset class. - Concentration: top holdings as % of portfolio; flag any single holding above a configurable threshold. - Benchmark comparison and alpha: let me input a benchmark return per period; compute portfolio return minus benchmark. - Make every formula visible in the code and document the XIRR method used. VIEWS - Client list with summary (total value, overall XIRR, allocation snapshot). - Per-client dashboard: holdings table, allocation pie/bar, value-over-time line, concentration view, benchmark vs portfolio. - Filters by asset class and date range. DATA INPUT - Bulk import via CSV/Excel upload, with a downloadable template. - Manual add/edit for individual holdings and transactions. - [If using live prices: integrate a price/NAV feed — otherwise default to manual current-price entry. Tell me clearly which APIs you'd use and what they cost before adding any.] REQUIREMENTS - Currency: INR; format numbers in Indian style (lakhs/crores) where sensible. - Handle partial sells, SIPs, and multiple lots per instrument. - Responsive layout; clean, professional UI. - All money and date math must be correct — include a few worked examples in comments so I can verify XIRR and return figures against known values. - [Auth: simple login if client-facing; otherwise no auth.] CONSTRAINTS - Do not invent data sources or pricing APIs. If you cannot integrate a real feed, default to manual entry and say so. - Before deploying, tell me where data is stored and what is exposed publicly.