Trading Journal

Upload your broker tradebook CSV for instant insights — equity curve, win rate, time-of-day patterns, and what separates your wins from your losses. All data stays in your browser.

📂
Drop your tradebook CSV here, or click to browse
Select one or multiple files at once. Auto-detects format. Merges with existing data — no duplicates.
✓ Zerodha Console → Tradebook ✓ Upstox → Reports → Trade History
Data stored locally in this browser only. Clearing browser data, using a different browser or device, or reinstalling the browser will permanently erase your trades. Use Export CSV in the Trade Log regularly to keep a backup.

What is a Trading Journal and Why Do You Need One?

A trading journal is a systematic record of every trade you take — entry price, exit price, quantity, P&L, and the reasoning behind each decision. It is widely regarded as one of the most powerful habits a trader can develop. Without a journal, patterns in your behaviour (good and bad) remain invisible, and you are forced to repeat mistakes because you have no data to learn from.

For Indian stock market traders on NSE and BSE, a trading journal helps you answer questions like: Do I trade better on Mondays or Fridays? Which symbols consistently lose me money? Am I profitable in the first hour, or do I tend to overtrade near the close? This free trading journal app answers all of those questions automatically once you upload your broker tradebook.

How to Use This Trading Journal

This tool works entirely in your browser — no account, no signup, and no data ever leaves your device. Here is how to get started:

  1. Export your tradebook CSV from Zerodha Console or Upstox (instructions below).
  2. Drop the file onto the upload zone above, or click to browse and select it.
  3. The journal automatically detects your broker format, matches buy and sell executions into round-trip trades using FIFO logic, and calculates net P&L including all charges.
  4. Your equity curve, daily P&L, win rate, symbol breakdown, time-of-day heatmap, and wins vs losses analysis appear instantly.
  5. Upload more files any time — new trades are merged and duplicates are skipped.
  6. Export CSV from the Trade Log section regularly to back up your data.

How to Export Your Tradebook from Zerodha

  1. Log in to Zerodha Console at console.zerodha.com.
  2. Click Reports in the top navigation.
  3. Select Tradebook from the dropdown.
  4. Choose your date range (you can select up to a full financial year at once).
  5. Click Download — the file is saved as a .csv.
  6. Upload the file here. The journal auto-detects the Zerodha format.

How to Export Your Trade History from Upstox

  1. Log in to Upstox at upstox.com.
  2. Go to Reports → Trade History.
  3. Select the date range you want.
  4. Click Download CSV.
  5. Upload the file here. The journal auto-detects the Upstox format.

Understanding Your Analytics

Once your trades are loaded, the dashboard shows six key metrics at the top:

  • Trades: Total closed trades and any open positions currently in localStorage.
  • Win Rate: Percentage of closed trades with positive net P&L. A win rate above 50% is generally healthy, but must be evaluated alongside average win vs average loss size.
  • Net P&L: Total profit or loss after all charges — STT, exchange fees, stamp duty, SEBI turnover fee, GST, and DP charges.
  • Profit Factor: Gross wins divided by gross losses. A value above 1.0 means you are net profitable. Aim for at least 1.5 for a sustainable edge.
  • Avg Win / Avg Loss: The average size of your winning and losing trades. A healthy system typically has average wins significantly larger than average losses.
  • Streak: Your current consecutive winning or losing run, measured on the most recent closed trades.

The time-of-day heatmap is particularly useful. It shows your average net P&L for each 30-minute entry slot from 9:00 to 15:30 IST. Dark green means you historically make good money entering in that slot; dark red means you tend to lose. Many traders discover they are profitable in the morning session but consistently lose in the afternoon, which leads to a simple rule change with a big impact on results.

The Wins vs Losses pattern analysis compares your winning trades and losing trades across three dimensions: the symbols you trade most, the days of the week you enter, and the time-of-day slots you enter. Common insights include seeing that you win more in certain symbols but keep coming back to a symbol that consistently hurts your P&L.

About Data Privacy and Storage

This trading journal stores all trade data exclusively in your browser's localStorage. No trade data, no CSV contents, and no personal information is transmitted to TradeCrunch servers or any third party. The application runs entirely client-side using JavaScript.

Important limitation: localStorage is tied to the specific browser and device you are using. If you clear your browser history or cookies, uninstall the browser, use a different browser, or switch to another device, all your stored trades will be gone. There is no cloud sync or account recovery.

To protect your data, use the Export CSV button in the Trade Log section after each upload session. Keep the exported file in a cloud drive (Google Drive, Dropbox, or iCloud) so you always have a recoverable copy.

Frequently Asked Questions

  • Yes, completely free. No signup, no subscription, no credit card. All analytics run in your browser using JavaScript. TradeCrunch does not charge for any feature of the trading journal.
  • All trade data is stored only in your browser's localStorage — never on a server. This means your data is private and inaccessible to anyone else. However, it also means the data is tied to this browser on this device. Clearing browser data or switching devices will erase it. Export CSV regularly from the Trade Log section as a backup.
  • Zerodha Console Tradebook and Upstox Trade History CSV formats are fully supported and auto-detected. For other brokers, use the manual Add Trade form to enter trades one by one. More broker formats may be added in future updates.
  • Yes. Each upload is merged with your existing data. A deduplication key (symbol, exchange, direction, date, time, quantity, price) prevents the same trade from being imported twice. Upload monthly or quarterly exports one at a time to build a complete multi-year history.
  • Net P&L = Gross P&L minus all charges. The charge model includes: STT (Securities Transaction Tax at SEBI-prescribed rates), exchange transaction charges (NSE/BSE rates by segment), SEBI turnover fee, stamp duty, GST on brokerage and exchange fees, and DP charges (₹15.34 per scrip per day for CNC delivery sells). Brokerage is calculated on the Zerodha slab model (₹20 or 0.03% per executed order, whichever is lower, for intraday/F&O; zero for CNC equity delivery).
  • The heatmap divides the NSE session (9:00–15:30 IST) into 30-minute slots and shows your average net P&L per trade for each slot, based on entry time. Green cells mean you tend to make money when entering in that window; red means losses. The darker the colour, the stronger the pattern. It helps identify your best and worst entry windows so you can focus activity or apply tighter rules during problem periods.
  • Profit Factor = Total Gross Winning P&L ÷ Total Gross Losing P&L. A value above 1.0 means your strategy is net profitable before fixed costs. Most traders aim for a Profit Factor of 1.5 or higher for a robust edge. A value of 2.0 means you earned ₹2 for every ₹1 lost across all trades. Values below 1.0 indicate a net losing strategy regardless of win rate.
  • Scroll to the Trade Log section and click Export CSV. This downloads a complete file with all your trade data including entry/exit prices, P&L, charges, setup tags, and notes. Save this file to Google Drive, iCloud, or Dropbox. If you ever lose your browser data, you will have this CSV as a permanent record (re-importing to the journal is a planned feature).