This excel sheet calculates the net profit of each intraday trade after deducting the brokerage and charges (including stamp duty) for Zerodha equity day traders.
Calculates up to 15 intraday trades.
Use this as your daily intraday equity trading journal.
Screenshot of the Excel sheet :
Once the above link opens up >> SELECT File >> Download as >> Microsoft Excel
Check the below post for an advanced excel sheet with daily and weekly profit/loss calculation:
This excel sheet works for Zerodha equity intraday brokerage rates, maximum value set to 40INR on closed positions.
Set the appropriate stamp duty rate of your residing state. (maximum cutoff not set for stamp duty)
Date values on column A updates to current date, delete values of column A to override this default setting
For reference only, use at your own risk.