# Hisaab

Case study by Devansh Tiwari (https://www.devanshtiwari.com) · https://www.devanshtiwari.com/work/hisaab

Open-source trading journal for Indian traders. Zero backend, zero signup. Built as acquisition funnel for Metis (past side project).

## Key facts

- Role: Solo Builder
- Client: Metis
- Year: 2026
- Status: Shipped
- Live: https://hisaab.trymetis.app
- Source code: https://github.com/Devansh-365/hisaab
- Tech: Next.js, TypeScript, Tailwind CSS, shadcn/ui, Dexie.js, IndexedDB, Recharts, PWA

## At a glance

- Problem: Traders don't want to upload their trade history to yet another server.
- What I built: A trading journal that runs fully in your browser and reads broker exports.
- Result: P&L, win rate and tax reports, all worked out on your own device.

## Numbers

| Metric | Value |
| --- | --- |
| Servers that see your trades | 0 |
| Broker formats | 4 |
| Analytics views | 5 |
| Installable app | Offline |
| CSV header variants | 12 |

## The problem

Indian traders don't trust tools with their financial data. 91% of F&O traders lost money last year. They've been burned by platforms that leak data or sell it. Existing journal tools want signups, credit cards, and server access to your tradebook. Nobody wants to upload their Zerodha CSV to a random website.

## What I built

A trading journal where no data ever leaves the browser. Drop your CSV from Zerodha, Groww, Upstox, or Angel One. Auto-detects the broker from column headers (12 signature variants, zero user selection). FIFO-matches buys and sells with partial fill support. Shows instant P&L, win rate, equity curve, drawdown chart, calendar heatmap, Sharpe ratio, Monte Carlo simulation, Kelly criterion. Tax report with STCG/LTCG classification and ITR-ready export. Installable as PWA, works offline. MIT licensed. The architecture was the marketing: zero server, zero signup, read every line of code. Every export carried a Metis link. Free tool builds trust. Trust converts to paid signups.

### Zero-Data Architecture

All processing happens in the browser via IndexedDB and Dexie.js. Trade CSVs are parsed locally, stored in the browser's IndexedDB, and never transmitted to a server. Users can inspect every line of code. Privacy is the default, not a feature.

### Broker Auto-Detection

Drop a CSV from any of 4 supported brokers (Zerodha, Groww, Upstox, Angel One). The system auto-detects the broker by matching column header signatures against 12 known variants. No dropdown, no manual selection. Parsed trades are normalized into a unified schema.

### FIFO Matching Engine

Matches buy and sell orders using FIFO with partial fill support. Handles split trades, multiple legs, and intraday vs delivery classification. Every matched pair shows realized P&L, holding period, and applicable tax regime (STCG or LTCG).

### Analytics Dashboard

Instant P&L, win rate, average winner/loser, equity curve, drawdown chart, calendar heatmap, Sharpe ratio, Sortino ratio, and Monte Carlo simulation. All charts are interactive and update as new trades are imported. Data exports to CSV or PDF.

### Tax Report Export

Generates a tax report with STCG/LTCG classification, turnover calculation, and ITR-ready export format. Shows speculative vs non-speculative income split. Includes a summary sheet for CA review. Updated whenever new trades are imported.

## Work with Devansh

Devansh Tiwari is an AI product engineer based in India, available for freelance and consulting work: custom data feeds from sites without APIs, AI features (agents, chat, RAG, MCP servers) built on that data, and running them after launch.

- Book a 15 minute call: https://cal.com/devansh0718/15min
- Email: devanshtiwari365@gmail.com
- All case studies: https://www.devanshtiwari.com/work
- Site summary for AI tools: https://www.devanshtiwari.com/llms.txt
