RedPine Quant Project — Investor Portal + Admin Ranking & Risk (MVP) 1. Project Scope Build a single web-based system (Next.js + TypeScript, PostgreSQL ledger backend). It must include: - Admin view on /admin for performance ranking & risk monitoring - Investor view on /portal that shows only Net portfolio performance - Shared internal USD ledger-based NAV/Unit calculation engine - Fee (Mgmt 2% annualized daily, Perf fee 20% with HWM) applied internally but hidden on investor UI 2. Core Modules (Use included ZIP structure) Backend SQL schema: - users - accounts - fund_nav_history - subscriptions - redemptions - api_keys Performance engine: - NAV calculation - IRR (Money-Weighted Return) - TWR (Time-Weighted Return) - Risk metrics per investor 3. Pseudo Logic (Must compile to valid TypeScript/JS) - Carry forward NAV from last available date - Compute units outstanding and NAV per Unit - Deduct management/performance fees internally - Store NAV history on each valuation date - Provide investor-level current value + Net ROI + Risk metrics - Rank investors by IRR/TWR for admin dashboard - Confirm calculations are consistent across UI and API 4. Delivery Requirements - All code must run/build without errors - UI must be clean, responsive (Tailwind-free styling allowed) - Backend must normalize all values to USD ledger unit - Session must bind user.id → investorId for portal/API use - Admin routes must verify role = 'admin' - Investor portal must verify role = 'investor' and not expose internal fee/dividend ledger entries 5. Output Package Use attached template ZIP project. Expand folder structure as needed, but preserve the core files and routing pattern. * I will give you all partially coded text by chatGPT. * If need, you should install db in my pc through remote access.