[ad_1]
I perceive there may be brokerage calculator and we are able to get a lot of the expenses from it.However, I need to discover out these expenses utilizing my very own excel sheet formulation. I need to embody all the costs/charges/deductions for every commerce.
Can zerodha please present this pattern excel sheet in brokerage calculator urgently?
It will assist all of us to control the costs in our trades. We are able to enter purchase value, promote value and amount and may get ALL the costs. I’m actually stunned why these type of particulars aren’t supplied already and nobody is asking !Now, we have now to test contract be aware, ledger and different locations and consolidate. That is simply not the correct manner !
1 Like
zerodha.com
Brokerage calculator
Complete brokerage calculator to calculate how a lot brokerage, STT, tax and many others. you must pay on all of your trades throughout NSE, BSE, MCX, MCX-SX
You need to use this brokerage calculator by zerodha
1 Like
Right here is an excel file I made for my intraday scalp trades. (This works just for choices trades, for futures trades, you’ll have to alter the formulation for STT calculation) https://drive.google.com/file/d/1sl0BIN1o249IGhfzY5UCDnxjbwhH5YA6/view?usp=sharing
2 Likes
right here it doesn’t enable to share e-mail ID. I’ve excel sheet.
You may share it on Google drive please
You can be required to calculate the prices of all trades earlier than and after commissions. Additionally, calculate fee prices as a proportion of complete share prices.Whereas this could take a while, you may merely choose the section and select the dates you need the statements from by clicking on “View”. You may obtain the assertion as a spreadsheet for additional reference.
Right here is an excel workbook which I created. Enter your trades in first sheet. Simply choose and drag all of the formulation and the whole lot is calculated. Second sheet comprises all the costs. Earlier than deleting the pattern information be sure to don’t delete the primary row of entry or all of the formulation might be gone.
docs.google.com
Loading Google Sheets
This Sheet is non-public
2 Likes
Google workplace breaks the named checklist performance of Excel. Please obtain this zip model https://drive.google.com/file/d/1u8jE_2AgJMphIvHUmSdwvnhvGuxqllFa/view?usp=sharing
are you able to share the up to date excel sheet for Brokerage calculation of Zerodha If you happen to had any.Thanks in Advance
[ad_2]
Source link