Stamp duty varies by state (e.g., Maharashtra is 0.01% on delivery, Delhi is 0.002%). Open the "Settings" tab and edit the "Stamp Duty %" cell to match your state’s rates.
The trade-off is that Excel sheets lack live market data, but for pre-trade planning or batch analysis, they are superior.
After using the calculator for a week, here is the data traders have discovered:
: Calculate charges for dozens of trades at once without re-entering data. Offline Access zerodha brokerage calculator excel sheet download
: Plan your trades anytime without needing an active internet connection. Performance Tracking
In the fast-paced world of online trading, every rupee spent on brokerage fees, taxes, and charges directly impacts an investor’s net profit. Zerodha, India’s largest stock broker, is renowned for its low-cost, transparent fee structure. However, even with flat pricing (e.g., ₹20 per executed order for intraday and F&O trades), calculating the exact net profit or loss before entering a trade can be complex due to hidden levies like STT, GST, SEBI charges, and stamp duty. This is where a becomes an indispensable tool for traders and investors.
In the fast-paced world of Indian stock trading, precision is everything. A single percentage point in brokerage fees can be the difference between a profitable day and a net loss. For traders using Zerodha, India’s largest discount broker, understanding the exact cost of a trade is paramount. While Zerodha provides an online brokerage calculator on their website, many professional traders and analysts prefer the flexibility of offline tools. This has led to a surge in demand for the . Stamp duty varies by state (e
Not every trader operates with a stable internet connection 100% of the time. An Excel sheet allows you to calculate potential trade costs offline. Whether you are traveling or facing connectivity issues, your financial planning doesn’t have to stop.
Without the calculator, the trader might mistakenly assume ₹10,000 profit. The Excel sheet reveals the exact net profit and break-even sell price (₹2,500.20), preventing misinformed trades.
Zerodha has disrupted the Indian stock market with its "flat fee" model. While their official trading platform, Kite, provides a rough P&L snapshot, many traders face a harsh reality after the trade is squared off: Hidden charges, STT, exchange transaction fees, and GST often eat into profits more than the brokerage itself. After using the calculator for a week, here
The sheet will show you that minimum charges (Rs. 20 + exchange fees + GST) make small trades extremely inefficient. You need a minimum turnover of roughly Rs. 30,000 in Futures to break even on charges.
You will see that your "Realized Profit" is NOT Rs. 15,000 (150 * 100). It is actually Rs. 13,870 after charges. The sheet automatically calculates the Theta Decay relative to your breakeven.
: Use your custom data alongside official Zerodha Tax P&L reports (downloadable from Console) for easier filing.