Overview

Opentrade is a social network for traders where you can share watchlists and portfolios, start conversations, visualize S&P 500 stock charts, and run a basic price forecast using Prophet. This project serves as a proof of concept and does not actually maintain real portfolios or handle real transactions.

Full price charts

Charts are built on top of React Echarts and render tuples of (open, close, high, low) over the time period. There are view options for week, month, quarter, and year.

The frontend uses Zustand and TanStack Query for state management. Client-side query caching is frequently used in the app to prevent refetching large amounts of data, such as price data.

Advanced Insights

A neat tool we built into this platform is a correlation matrix and beta calculation tool for each portfolio/watchlist. These give insights into how correlated each stock is to the others in the portfolio and help pinpoint potential skews toward certain sectors. The beta value calculation is also useful in determining how volatile a given stock is relative to the S&P 500. All calculations are done entirely via SQL and are cached in a cache table for speedy retrieval.