TLDR: This guide walks you through connecting your Zerodha account to JournalPlus, importing your trade history, and setting up analytics for equity, F&O, and commodity trading in the Indian market.
Why Zerodha Traders Need a Dedicated Journal
Zerodha’s Kite platform provides basic trade history and P&L statements through Console, but these tools are designed for record-keeping, not performance analysis. You can see what you traded and how much you made or lost, but you cannot easily answer questions like “What is my win rate on Nifty options expiry day trades?” or “How does my performance differ between morning and afternoon sessions?”
A dedicated trading journal bridges this gap by taking your raw Zerodha trade data and transforming it into actionable analytics. It tracks the metrics that Zerodha’s built-in tools do not surface, correlates your trading behavior with outcomes, and provides the structured review process that separates improving traders from stagnant ones.
Step 1: Export Your Trade Data from Zerodha
Accessing Your Tradebook
Log into Zerodha Console at console.zerodha.com. Navigate to the Reports section and select Tradebook. Choose the date range you want to export. For your initial import, select the longest range available to give your journal a meaningful historical dataset to analyze.
Downloading the CSV
Click the download button to export your tradebook as a CSV file. This file contains your trade entries and exits with timestamps, instruments, quantities, prices, and order types. Verify that the downloaded file opens correctly in a spreadsheet application and contains the expected number of trades.
F&O Trades
Futures and options trades appear in the same tradebook export. Options trades include the strike price, expiry date, and option type (CE or PE) as part of the instrument name. The journal will parse these fields automatically during import.
For options traders, it is worth also downloading the P&L statement from Console, which provides a consolidated view of profits and losses including premium received and paid. This data helps reconcile multi-leg strategies.
Step 2: Import into JournalPlus
Creating Your Account
If you have not already, create a JournalPlus account. Select India as your region during setup so that the platform configures currency, tax settings, and market hours correctly for NSE, BSE, and MCX.
Uploading Your Zerodha Data
Navigate to the import section and select Zerodha from the broker list. Upload the CSV file you exported. The system automatically maps Zerodha’s column format to the journal’s data structure.
Review the import preview before confirming. The preview shows how many trades were detected, the date range covered, and any rows that could not be parsed. Common reasons for unparsed rows include corporate action entries or internal transfer records that are not actual trades.
Handling Multi-Leg Strategies
If you trade options strategies like straddles, strangles, or spreads, the import process will bring in each leg as a separate trade. You can group related legs into a single strategy after import, which allows the journal to calculate the combined P&L and risk metrics for the entire position.
Step 3: Configure Your Dashboard
Setting Up Key Metrics
After importing your trades, configure your dashboard to display the metrics most relevant to your trading style. For typical Indian market traders, recommended metrics include:
Net P&L: Your bottom-line profit or loss after brokerage, STT, stamp duty, GST, and exchange transaction charges. JournalPlus can factor in Zerodha’s fee structure automatically.
Segment-Wise Breakdown: Separate your equity delivery, intraday, F&O, and commodity performance. Many traders are profitable in one segment but losing in another without realizing it.
Daily and Weekly Performance: View your P&L by day of the week and by time of day relative to Indian market hours (9:15 AM to 3:30 PM IST).
Configuring Costs
Zerodha’s brokerage structure is straightforward: zero brokerage on equity delivery, flat 20 rupees per order on intraday and F&O. However, the true cost includes STT, stamp duty, exchange charges, and GST. Configure these charges in your journal settings so that your P&L calculations reflect actual take-home profits.
This is particularly important for high-frequency intraday traders and options sellers, where transaction costs can significantly impact net profitability.
Step 4: Set Up Your Review Process
Daily Review After Market Close
Indian markets close at 3:30 PM IST. Set a daily reminder for 4:00 PM to complete your journal review. At this time, your Zerodha tradebook will have the final settlement data, and the trades are fresh in your memory.
During the daily review, check that all trades imported correctly, add notes about your reasoning and emotional state for each trade, tag trades with the strategy or setup used, and record any rule violations.
Weekly Review on Weekends
Saturday is ideal for the weekly review since Indian markets are closed. Pull up your weekly performance dashboard and examine win rate trends, average trade duration, and P&L by instrument. Compare this week to the previous four weeks to identify improving or declining patterns.
Monthly Review and Reporting
At the end of each month, generate a performance report. This report is useful for your own analysis and also serves as preparation for quarterly advance tax calculations, which are required for traders classified under the speculative or business income categories.
Step 5: Track India-Specific Metrics
Expiry Day Analysis
Options expiry days (weekly on Thursdays for Nifty and Bank Nifty, monthly for stock options) have unique dynamics with theta decay and increased volatility. Tag expiry-day trades in your journal to analyze your performance on these days separately from regular trading days.
Many traders discover that their expiry-day results are significantly different from their non-expiry performance, which informs whether they should increase, decrease, or modify their approach on these days.
Segment Performance
Indian markets offer distinct segments: NSE cash, NSE F&O, BSE equity, MCX commodity, and currency derivatives. Each segment has different characteristics, costs, and tax implications. Your journal should track performance by segment so you can allocate more capital to segments where you demonstrate edge and reduce exposure to segments where you do not.
Pre-Open and Post-Close Activity
The NSE pre-open session from 9:00 to 9:15 AM and the closing session from 3:40 to 4:00 PM are unique to Indian markets. If you participate in these sessions, tag those trades separately. Your journal can then show whether these non-regular-hours trades are adding to or detracting from your overall performance.
Tax Reporting Benefits
A well-maintained journal simplifies the complex tax reporting requirements for Indian traders. Your journal provides an auditable trail of all transactions, categorized by segment and holding period. This data directly feeds into the speculative income, non-speculative business income, and short-term capital gains calculations required for ITR filing.
For traders who file under the presumptive taxation scheme (Section 44AD) or maintain books of account, the journal serves as a supporting document that substantiates reported income figures.
Getting the Most From Your Setup
The initial setup takes about 30 minutes: exporting data from Zerodha, importing it into JournalPlus, and configuring your dashboard. The ongoing daily commitment is 10 to 15 minutes after market close.
The traders who extract the most value from this setup are those who use the journal not just as a record but as a decision-making tool. Before taking a trade, check your journal for how you have historically performed in similar conditions. After a loss, review whether the same mistake has appeared before. During your weekly review, set one specific improvement goal for the coming week.
Your Zerodha trade data, properly analyzed, contains the roadmap to better performance. The journal is the tool that reads that map.
