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.
PLEASE NOTE: Since the stt, gst, exchange and clearing charges keep changing from time to time, after downloading the file you will need to edit the rate calculation on these files to the latest ones.
Screenshot of the Excel sheet :
Download Link:
click here to download 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:
Notes:
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.