Sheersh Sharma.

Back to Work

The Trade LogBook

Advanced Trading Analytics Platform

Full Stack Developer

Next.js 15TypeScriptPostgreSQLPrismaTailwindAWS S3RechartsNextAuth v5

Project Overview

The Trade LogBook is a sophisticated SaaS application that serves as a second brain for financial traders. Unlike simple spreadsheet replacements, it offers deep analytics into trading performance and psychology.

I architected the entire application from the ground up, focusing on a seamless user experience and powerful data processing. It combines quantitative metrics with qualitative behavioral data to help traders identify leaks and improve performance.

Technical Architecture

Next.js 15 App Router & Server Actions

Leveraged React Server Components (RSC) for optimized data fetching, ensuring near-instant page loads and SEO friendliness without client-side waterfalls.

Type-Safe Ecosystem

End-to-end type safety using TypeScript and Zod schemas. Database models (Prisma) are perfectly synced with UI components and API validation layers.

Complex Relational Database

Architected a PostgreSQL schema handling intricate relationships between Users, multiple Trading Accounts, Strategies, and granular Trade Executions.

Advanced Capabilities

Interactive Visualization

Custom Recharts integration processing raw trade data into interactive Cumulative PnL, Win Rate, and Drawdown charts on the client side.

High-Performance Import

Robust CSV/Excel parser (Papaparse) capable of validating and normalizing thousands of trade records from different brokers in seconds.

Cloud Storage (AWS S3)

Secure, scalable storage for trade screenshots using S3 compatible storage with signed URLs for secure access control.

RBAC Authentication

NextAuth v5 implementation supporting secure sessions, multi-account management, and role-based access control for administrative features.

Key Features

  • Real-time PnL Analytics
  • Psychology-based Reporting
  • Multi-Account Aggregation
  • Strategy Tagging System
  • Rich-Text Journaling
  • Automated Daily Reports

Challenges Solved

Data Performance

Optimized SQL queries to aggregate stats from thousands of rows without latency.

Data Integrity

Strict validation pipelines to prevent corruption from varied brokerage export formats.