Zerodha Brokerage Calculator: Excel Guide for Intraday & Delivery Trading

Zerodha Brokerage Calculator tools help traders accurately estimate the total cost of every trade — including brokerage, STT, GST, SEBI turnover fees, exchange transaction charges, and stamp duty — before placing an order. Whether you trade intraday equity, take delivery positions, or deal in Futures & Options, building a brokerage calculator in Excel gives you complete control over cost analysis. In this comprehensive guide, we walk through the Zerodha fee structure, provide ready-to-use Excel formulas, and show you how to automate the entire process.

Introduction

Navigating the world of stock trading can be complex, especially when it comes to understanding brokerage fees. Zerodha, one of India's leading brokerage firms, simplifies this process with low-cost trading options and a transparent fee structure. In this article, we'll explore the Zerodha brokerage formula, how to calculate it using Excel, and the benefits of the Zerodha brokerage calculator Excel tool. Dive in to make trading more affordable and straightforward!

What is the Formula for Zerodha Brokerage?

Zerodha, a popular brokerage firm in India, is known for its low-cost trading options, and you can easily calculate these costs using the Zerodha brokerage calculator Excel tool. The formula for Zerodha brokerage is straightforward and transparent. For equity delivery trades, there is no brokerage fee, making it free. In intraday and Futures & Options (F&O) trading, Zerodha charges either a flat Rs. 20 or 0.03% of the trade value, whichever is lower, applicable to both buying and selling transactions. Additionally, Zerodha offers prepaid plans for higher volume traders, providing further reductions. The firm also charges a nominal fee for currency and commodity trading. Overall, Zerodha aims to make trading affordable for its users.

Complete Zerodha Charges Breakdown by Segment

Understanding every charge component is essential for building an accurate Zerodha brokerage calculator in Excel. Below is a comprehensive breakdown of all charges across different trading segments.

Equity Delivery Charges

Equity Intraday Charges

Futures Trading Charges

Options Trading Charges

Commodity Trading Charges

Currency Trading Charges

How Do I Calculate Brokerage Percentage in Excel?

To calculate brokerage percentage in Excel, first, input your data in columns. For example, list the total transaction amounts in column A and the brokerage fees in column B. In column C, you can calculate the brokerage percentage by using the formula =B1/A1*100, which you can drag down to apply to other rows. This formula divides the brokerage fee by the total transaction amount, then multiplies it by 100 to get the percentage. If you have many rows, simply double-click the small square at the bottom-right corner of the cell with your formula to fill down automatically. You can format these cells as percentages for better readability. Double-check your entries to ensure accuracy in your calculations.

Step-by-Step: Building a Zerodha Brokerage Calculator in Excel

Follow these detailed steps to create your own Zerodha brokerage calculator spreadsheet from scratch.

Step 1: Set Up Input Cells

Create a clean input section at the top of your worksheet:

Step 2: Calculate Trade Values

Turnover (B8):     =B3*B5 + B4*B5
Buy Value (B9):    =B3*B5
Sell Value (B10):  =B4*B5

Step 3: Calculate Brokerage

For intraday trades, the formula captures Zerodha's "Rs. 20 or 0.03%, whichever is lower" rule:

Buy Brokerage (B12):   =MIN(20, B9*0.0003)
Sell Brokerage (B13):  =MIN(20, B10*0.0003)
Total Brokerage (B14): =B12+B13

For delivery trades, brokerage is zero:

Total Brokerage (B14): =0

Step 4: Calculate STT

For intraday (sell side only at 0.025%):

STT (B16): =B10*0.00025

For delivery (both sides at 0.1%):

STT (B16): =B8*0.001

Step 5: Calculate Exchange Transaction Charges

Exchange Charges (B18): =B8*0.0000297

(Use 0.0000375 for BSE)

Step 6: Calculate GST

GST (B20): =(B14+B18)*0.18

Step 7: Calculate SEBI Turnover Fee

SEBI Fee (B22): =B8*0.000001

Step 8: Calculate Stamp Duty

For intraday (buy side only at 0.003%):

Stamp Duty (B24): =B9*0.00003

For delivery (buy side only at 0.015%):

Stamp Duty (B24): =B9*0.00015

Step 9: Calculate Total Charges and Net P&L

Total Charges (B26):  =B14+B16+B18+B20+B22+B24
Gross P&L (B28):      =(B4-B3)*B5
Net P&L (B29):        =B28-B26
Breakeven (B30):      =B3+(B26/B5)

Step 10: Add Segment Switching with IF Formulas

To make your calculator handle multiple segments automatically, use nested IF statements:

=IF(B2="Delivery", 0, MIN(20, B9*0.0003))

This approach lets you switch between Intraday, Delivery, Futures, Options, Commodity, and Currency segments by simply changing cell B2.

Is the Zerodha Brokerage Calculator Accurate?

The Zerodha brokerage calculator is considered accurate for most users. It helps traders estimate costs associated with their transactions effectively. The tool accounts for various charges like brokerage fees, taxes, and other levies. Some users report minor discrepancies occasionally, often due to market fluctuations or updates in fee structures. Generally, it provides a reliable estimate that aligns closely with actual costs. However, it's always a good idea to double-check calculations, especially for high-value trades. Overall, the tool is a valuable asset for managing trading expenses.

How Can a Zerodha Brokerage Calculator Excel Sheet Be Created from Scratch?

To create a Zerodha brokerage calculator Excel sheet from scratch, start by gathering all relevant brokerage details, including various charges like brokerage fees, transaction charges, and taxes. Set up an Excel sheet with clearly labeled columns for buy price, sell price, quantity, and the specific charges. Insert formulas to calculate brokerage fees based on Zerodha's fee structure, considering both intraday and delivery trades. Incorporate sections for Securities Transaction Tax (STT), GST, SEBI fees, and stamp duty to capture all necessary deductions. Use cell references to link these calculations so that inputting the buy and sell prices along with the quantity automatically updates the final cost and profit. Ensure data validation to avoid user input errors. Finally, test the sheet with sample transactions to verify accuracy before general use.

Zerodha Brokerage Calculator: Comparison with Other Indian Brokers

Understanding how Zerodha's charges compare to competitors helps you evaluate the true cost advantage. Here is a detailed comparison:

Key Takeaways from the Comparison

• Zerodha leads with the lowest intraday brokerage cap (0.03%) and a mature API (Kite Connect) popular among algorithmic traders.
• Upstox and Groww match Zerodha on delivery but charge slightly more on intraday trades.
• ICICI Direct remains the most expensive but offers full-service research and advisory.
• Angel One provides free delivery with comprehensive research tools at a competitive price point.
• For traders who build custom Excel-based analysis, Zerodha's Kite Connect API combined with MarketXLS offers the most flexible data integration.

How Does Zerodha's Brokerage Structure Compare to Other Brokers?

Zerodha operates a flat-fee brokerage model, which is significantly different from most traditional brokers. They charge a fixed fee per trade, regardless of the trade's size. This is particularly advantageous for high-volume traders, as costs remain predictable. In contrast, many other brokers charge a percentage-based fee, which can become quite expensive with larger trades. Zerodha's structure also simplifies the fee calculation process. Additionally, they offer various zero brokerage services, making them appealing to small investors. While some competing brokers provide advanced research and advisory services, Zerodha focuses on a straightforward, cost-effective trading experience.

How Can I Incorporate GST and SEBI Charges in the Excel Calculator?

To incorporate GST and SEBI charges in an Excel calculator, start by creating separate columns for GST and SEBI fees. Input the applicable percentage rates for each charge. Use basic Excel formulas to compute GST and SEBI charges based on transaction amounts. For instance, if your transaction amount is in cell A1, you can calculate GST in cell B1 with a formula like =A1*GST_rate. Similarly, calculate SEBI charges in cell C1 using =A1*SEBI_rate. Ensure that all computed fees are summed in an additional column to get the total cost. Also, regularly update the rates to reflect any changes in GST or SEBI guidelines. This setup streamlines the calculation process, making it accurate and efficient.

How Can I Calculate the Total Cost of a Trade Using the Zerodha Brokerage Calculator?

To calculate the total cost of a trade using the Zerodha brokerage calculator, start by entering the basic details of your trade. Input the buy and sell price, quantity, and the segment you are trading in, such as equity, F&O, currency, or commodity. The calculator will automatically take into account the brokerage charges, which are Rs. 20 per trade or 0.03% (whichever is lower) for equity intraday, F&O, currency, and commodity. Additionally, it factors in other costs like STT, exchange transaction charges, GST, SEBI turnover fees, and stamp duty. After entering all the required details, the calculator will display the total brokerage, other charges, and the net profit or loss. This allows traders to know the exact costs and potential returns before executing a trade.

Sample Calculations: Intraday vs. Delivery vs. F&O

Let's walk through three real-world examples to see how the Zerodha brokerage calculator works in practice.

Example 1: Equity Intraday Trade

Scenario: Buy 200 shares of Reliance at Rs. 2,500 and sell at Rs. 2,520 on NSE.

Example 2: Equity Delivery Trade

Scenario: Buy 50 shares of TCS at Rs. 3,800 and sell at Rs. 3,900 on NSE.

Example 3: Options Trade (Nifty)

Scenario: Buy 1 lot (50 units) of Nifty 24000 CE at Rs. 150 premium and sell at Rs. 200 premium.

Advanced Excel Techniques for Your Brokerage Calculator

Using Data Validation for Segment Selection

Add a dropdown list in your segment cell to prevent errors:

1. Select cell B2
2. Go to Data → Data Validation
3. Choose List and enter: Intraday,Delivery,Futures,Options,Commodity,Currency
4. Now you can switch segments from a dropdown menu

Conditional Formatting for Profit/Loss

Apply conditional formatting to your Net P&L cell:

1. Select the Net P&L cell (B29)
2. Go to Home → Conditional Formatting → New Rule
3. Set green fill for values > 0 and red fill for values < 0

Using VLOOKUP for Rate Tables

Instead of hardcoding charge rates, create a separate rate table and use VLOOKUP:

=VLOOKUP(B2, RateTable, 2, FALSE)

This way, when Zerodha updates its charges, you only need to update one table.

Calculating Breakeven Points

The breakeven calculator tells you the minimum price movement needed to cover all charges:

Breakeven Points (in Rs.): =B26/B5
Breakeven Percentage: =(B26/B9)*100

This is especially useful for scalpers and intraday traders who need to know the minimum profitable move.

Are There Any Templates Available for Zerodha Brokerage Calculation in Excel?

Yes, MarketXLS offers various templates that can be used for different investment strategies and calculations, including templates for brokerage calculations.

For example, MarketXLS provides templates for:

1. Investment Models.
2. Options Strategy Templates.
3. Stock Valuation Templates.
4. Portfolio Analysis Templates.

While the documents reviewed do not explicitly mention a "Zerodha brokerage calculation template," many valuable templates and tools are available that can be adapted for various uses.

For your specific needs with Zerodha brokerage calculation, I would recommend browsing through the selection of available templates and possibly using related options or stock trading templates to modify them as per your requirement. You can access these templates via the MarketXLS website and use them to simplify and automate your brokerage calculations in Excel.

If you still need help or a customized solution, you can contact MarketXLS support, and they will assist you in creating or modifying templates to suit your specific requirements.

Here is the template you might want to check out and MarketXLS has 100s of templates to get you started easily and save you time.

If you need others, you may refer to the MarketXLS template library.

How Do You Connect Zerodha Account to Excel?

To connect your Zerodha account to Excel via MarketXLS, you can follow these steps:

1. Download and Install MarketXLS: For Windows, download the MSI file from the provided link, install the software, and open Excel. You should see the new "MarketXLS" menu in Excel. For Mac, create a new Excel Workbook, go to the Insert Tab, click on "Add-ins" and select "Store" to access the Microsoft Office Add-in store. Search for the MarketXLS add-in and click "Add." After installation, the add-in will be available in the "My Add-ins" section.

2. Activate MarketXLS: Once installed, you need to activate MarketXLS using your license key. Go to the settings/help menu on the MarketXLS ribbon in Excel and click on "apply license," then copy and paste your license key into the box provided.

3. Log in to MarketXLS: Open the MarketXLS menu in Excel and log in to the add-in. If you are a first-time user, you may need to register first.

4. Connect Your Zerodha Account for Real-Time Data: Navigate to the 'Broker Login' section within the MarketXLS menu and select Zerodha. You will need your Zerodha credentials to establish this connection. For more detailed assistance on how to establish this connection, you can watch the provided video tutorial on connecting Zerodha with MarketXLS.

5. Using MarketXLS Functions: Once connected, you will have access to real-time data and all MarketXLS functions. You can review these functions on the MarketXLS website.

By following these steps, you should be able to connect your Zerodha account to Excel and leverage MarketXLS to access real-time market data and a variety of financial functions.

Using MarketXLS Functions with Indian Stocks

Once you have connected your Zerodha account through MarketXLS, you can use powerful Excel functions to pull live data directly into your brokerage calculator:

• Last Traded Price: =Last("RELIANCE.NS") — Get the current price of any NSE-listed stock
• Streaming Price: =Stream_Last("RELIANCE.NS") — Get continuously updating real-time prices
• Historical Data: =GetHistory("RELIANCE.NS", "2025-01-01", "2025-06-30", "Daily") — Pull historical price data for backtesting
• P/E Ratio: =PERatio("RELIANCE.NS") — Evaluate valuation before trading
• Moving Average: =SimpleMovingAverage("RELIANCE.NS", 50) — Technical analysis directly in Excel

Building an Automated Trading Journal

Combine your Zerodha brokerage calculator with MarketXLS functions to create a comprehensive trading journal:

1. Column A: Trade Date
2. Column B: Stock Symbol
3. Column C: =Last(B2) — Pulls current price
4. Column D: Buy Price (manual entry)
5. Column E: Sell Price (manual entry)
6. Column F: Quantity
7. Column G: Brokerage calculation formula
8. Column H: STT calculation
9. Column I: Total charges
10. Column J: Net P&L

This setup gives you a real-time view of your trading performance with accurate cost tracking.

Tips for Optimizing Your Zerodha Brokerage Calculator

1. Account for DP Charges in Delivery Trades

Zerodha charges Rs. 15.93 per scrip as Depository Participant (DP) charges when you sell shares from your demat account. Add this to your delivery calculations:

DP Charges (B25): =IF(B2="Delivery", 15.93, 0)

2. Handle Commodity-Specific CTT

For commodity trades, CTT (Commodity Transaction Tax) replaces STT. Use an IF formula to switch:

=IF(B2="Commodity", B10*0.0001, IF(B2="Intraday", B10*0.00025, B8*0.001))

3. Round Off Charges Correctly

Zerodha rounds off charges to the nearest paisa. Use the ROUND function:

=ROUND(B16, 2)

4. Track Monthly Brokerage Spend

Create a summary sheet that totals all your brokerage expenses by month:

=SUMPRODUCT((MONTH(TradeDate)=1)*TotalCharges)

This helps you monitor whether your trading costs are eating into your profits.

5. Calculate Effective Brokerage Percentage

For each trade, calculate what percentage of your turnover goes toward charges:

Effective Charge %: =(B26/B8)*100

This metric is crucial for scalpers where even a 0.05% difference matters.

Frequently Asked Questions

What charges does Zerodha levy on intraday trades?

Zerodha charges Rs. 20 per executed order or 0.03% of the trade value (whichever is lower) for intraday equity trades. In addition, traders pay STT at 0.025% on the sell side, exchange transaction charges, GST at 18% on brokerage plus exchange charges, SEBI turnover fee, and stamp duty. The Zerodha brokerage calculator Excel sheet helps you compute all these charges automatically so you know your net profit before placing the trade.

Is Zerodha brokerage really free for delivery trades?

Yes, Zerodha charges zero brokerage on equity delivery trades across both NSE and BSE. However, other statutory charges still apply — including STT at 0.1% on both buy and sell sides, exchange transaction charges, GST, SEBI fees, and stamp duty. Additionally, a DP (Depository Participant) charge of Rs. 15.93 per scrip applies when you sell delivery shares. These non-brokerage costs can be significant on smaller trades.

How do I calculate brokerage for F&O trades in Excel?

For Futures trades, use =MIN(20, TradeValue*0.0003) per order. For Options, brokerage is a flat Rs. 20 per executed order regardless of the premium or lot size. Then add STT (0.02% on sell side for futures, 0.125% on sell side for options), exchange transaction charges, GST, SEBI fee, and stamp duty. The step-by-step formulas provided in this guide cover all F&O segments in detail.

Can I use the Zerodha brokerage calculator for commodity and currency trading?

Yes. The same Excel framework applies to commodity (MCX) and currency (NSE Currency) segments. For commodities, replace STT with CTT (Commodity Transaction Tax) at 0.01% on the sell side for non-agricultural commodities. Currency trades have no STT/CTT but have exchange transaction charges at 0.00035%. Adjust the respective rate cells in your Excel calculator to handle these segments.

How accurate is the Zerodha brokerage calculator compared to actual charges?

The official Zerodha brokerage calculator and a well-built Excel version provide estimates that are typically within Rs. 1–2 of actual charges. Minor discrepancies may occur due to rounding differences, intraday rate changes by exchanges, or updated stamp duty rates by state governments. For maximum accuracy, verify the latest charge rates on Zerodha's official website and update your Excel rate table accordingly.

What is the breakeven point for an intraday trade on Zerodha?

The breakeven point depends on your trade value and quantity. For a typical intraday trade of Rs. 5,00,000 (buy side), total charges are approximately Rs. 110–130. This means the stock needs to move about Rs. 0.55–0.65 per share (for 200 shares) just to cover costs. Use the breakeven formula =TotalCharges/Quantity in your Zerodha brokerage calculator Excel sheet to compute this for every trade.

Summary

Zerodha simplifies stock trading with low-cost options and transparent fees. The Zerodha brokerage calculator Excel tool aids in calculating these costs. Zerodha's formula charges Rs. 20 or 0.03% for intraday and F&O trades, with no fees for equity delivery trades.

Create an Excel sheet for brokerage calculation by listing transaction amounts and fees, then using the formula =B1/A1*100 for percentages. To include GST and SEBI charges, create columns and apply necessary formulas.

Zerodha's flat-fee model makes trading more affordable compared to percentage-based fees of other brokers. The Zerodha brokerage calculator provides accurate estimates of trading costs.

MarketXLS offers templates adaptable for Zerodha brokerage calculations. To connect Zerodha to Excel via MarketXLS, install MarketXLS, activate it, and log in using Zerodha credentials. This enables real-time data access in Excel.

Ready to supercharge your trading analysis? Explore MarketXLS plans and visit MarketXLS to get started with real-time data, 1,100+ Excel functions, and powerful templates for Indian and global markets.