How praveenkumarv-github/portfolio works
This is a single-user Django personal-finance dashboard. An approved user accesses the dashboard through Cloudflare Access; they upload an XLSX workbook or provide a Google Sheet URL, after which the app validates and parses the workbook, resolves fund NAV and metal prices, computes portfolio metrics and alerts, and renders the results. The graph includes workbook import, look-through allocation, and net-worth snapshots as distinct product stages. Source excerpts show the main orchestration and dependencies; some documented runtime and security links rely on the README.
Main entry points: views.py Dashboard handlers · aggregator.py Dashboard aggregator · metal_price_service.py Metal price service · settings.py Django app
Components 22
Access and UI
- Cloudflare Access
- Django app
finance_dashboard/settings.py - Access JWT check
finance_dashboard/middleware.py - Dashboard handlers
dashboard/views.py - Dashboard UI
dashboard/templates/dashboard/dashboard.html
Workbook Import
- Workbook validation
dashboard/services/workbook_validation.py - Google Sheet import
dashboard/services/google_sheet_service.py - Google Drive export
- Workbook parser
dashboard/services/excel_parser.py - Fund NAV lookup
dashboard/services/nav_service.py
Portfolio Analytics
- Dashboard aggregator
dashboard/services/aggregator.py - Portfolio calculations
dashboard/services/calculation_engine.py - Look-through allocation
dashboard/services/economic_allocation.py - Portfolio alerts
dashboard/services/alerts.py - Fund transaction analytics
dashboard/services/capital_gains.py - XIRR solver
dashboard/services/xirr.py
Prices and State
- Metal price service
dashboard/services/metal_price_service.py - Metal price cache
data/metal_prices.json - Upload and snapshots
dashboard/models.py
Other components
- Approved user
- AMFI / MFAPI
- GoodReturns
Connections 23
- Approved user → Cloudflare Access: signs in
README.md - Cloudflare Access → Django app: forwards request
README.md - Django app → Access JWT check: configures
- Django app → Dashboard handlers: routes requests
README.md - Dashboard handlers → Dashboard UI: renders
README.md - Dashboard handlers → Workbook validation: validates upload
dashboard/views.py - Dashboard handlers → Google Sheet import: imports sheet
dashboard/views.py - Google Sheet import → Google Drive export: fetches private export
dashboard/services/google_sheet_service.py - Google Sheet import → Workbook validation: validates download
dashboard/services/google_sheet_service.py - Dashboard handlers → Dashboard aggregator: builds dashboard
dashboard/views.py - Dashboard aggregator → Workbook parser: parses workbook
dashboard/services/aggregator.py - Workbook parser → Fund NAV lookup: resolves NAV
dashboard/services/excel_parser.py - Fund NAV lookup → AMFI / MFAPI: queries NAV
README.md - Workbook parser → Metal price service: resolves metal prices
dashboard/services/excel_parser.py - Dashboard aggregator → Portfolio calculations: builds portfolio
dashboard/services/aggregator.py - Dashboard aggregator → Look-through allocation: builds allocation
dashboard/services/aggregator.py - Dashboard aggregator → Portfolio alerts: runs alerts
dashboard/services/aggregator.py - Dashboard aggregator → Upload and snapshots: records snapshots
dashboard/services/aggregator.py - Portfolio calculations → Fund transaction analytics: uses transaction analytics
dashboard/services/calculation_engine.py - Portfolio calculations → XIRR solver: solves returns
dashboard/services/calculation_engine.py - Metal price service → GoodReturns: scrapes prices
dashboard/services/metal_price_service.py - Metal price service → Metal price cache: reads and writes
dashboard/services/metal_price_service.py - Dashboard handlers → Metal price service: refreshes prices
dashboard/views.py