Full-stack Web App: Portfolio Tracker
Full stack web app built with Next.js and React for automatically tracking a portfolio with traditional assets (stocks) managed by International Brokers and cryptocurrencies stored on a Trezor hardware wallet [link]
This full-stack web app is built with Next.js 16.1.6.Prisma ORM is used to manage a PostgreSQL database. Client-to-Server queries made via tRPC calls, and the database is hosted with Neon DB, while the server is running on AWS EC2 instance.
15-minute delayed financial data is accessed via EODHD to calculate the portfolio value timeseries. I used Alchemy to retrieve crytocurrency wallet balances from a cold-storage hardware wallet (ETH network tokens and BTC public address). A client gateway provides direct connectivity to an International Brokers Account, and live balances and options contracts currently held are queried via this API on the admin backend. Portfolio snapshots are stored in a database table.
Trades are stored in tables in the database, and the portfolio value across trading days is generated on demand and displayed via Plotly.js. Standard per-post SEO included for search engine indexability.