← back
Market Data Dashboard
A web application built in C# (ASP.NET Core) that downloads, stores, visualizes, and
analyzes historical stock market data — built to demonstrate real-world engineering
practices: async data processing, local persistence, external service integration,
and clean architectural separation.
C# 12 / .NET 9ASP.NET Core Razor Pages
SQLite / EF CoreChart.jsPython
Features
- Download historical prices from the Alpha Vantage API, cached locally with SQLite + EF Core (incremental updates only)
- Interactive time-series charts (Chart.js) with zoom/pan and CSV export
- Technical indicators — SMA (10/20/50/100), EMA (10/20/50), RSI (7/14), Bollinger Bands, MACD
- Asynchronous prediction module — cross-language integration with a Python regression script, polled every 500 ms without blocking the UI
- Responsive tabbed UI for multiple stock symbols, built with Bootstrap 5 and jQuery DataTables
Testing & CI
33 unit tests (xUnit, Moq, EF Core InMemory) across technical indicators, CSV export,
data service, and the prediction workflow. Tests run automatically on every push via
GitHub Actions.