Zerodha,
Thanks for every help in this regard BUT, BUT to inform you that I have already gone through this file and could NOT understand :-
(1) HOW TO WRITE A FORMULA FOR Rs 440/Crore, & ALSO ........
(2) WHAT FORMULA SHOULD I USE WHEN I DON'T KNOW THE TRANSACTION CHARGES METHOD (Service Tax = 12% on Brokerage+Transaction Charge) - What are the "Transaction Charges" here, please explain.
Hope you (or anybody else) would be able to throw some light upon these things.
shekharz
Thanks for every help in this regard BUT, BUT to inform you that I have already gone through this file and could NOT understand :-
(1) HOW TO WRITE A FORMULA FOR Rs 440/Crore, & ALSO ........
(2) WHAT FORMULA SHOULD I USE WHEN I DON'T KNOW THE TRANSACTION CHARGES METHOD (Service Tax = 12% on Brokerage+Transaction Charge) - What are the "Transaction Charges" here, please explain.
Hope you (or anybody else) would be able to throw some light upon these things.
shekharz
Hmm.. how to write a formulae?
Contract size * price * 0.0044 is the transaction charge for comm..
Contract size * price * 0.0044 is the transaction charge for comm..
Thanks Zerodha,
I have made the calculation sheet, but the fact is, it is NOT perfect yet, especially on the Rs 50 Stamp Duty part, because if one is trading twice-thrice or more in a day, I could not find any way out how to calculate brokerage for these different trades after applying this Rs 50 Stamp Duty once only, hence I have added this Rs 50 in whole calculation whether single trade in a day or multiple trades, it will calculate Rs 50 every time (that is not going to bother me anyhow). Finally, the charges are still a little different than those being shown on your website but that does not matter at all too because the final amount being shown in my calculation sheet is near to actual amount in my account, so it will do the work.
shekharz
I have made the calculation sheet, but the fact is, it is NOT perfect yet, especially on the Rs 50 Stamp Duty part, because if one is trading twice-thrice or more in a day, I could not find any way out how to calculate brokerage for these different trades after applying this Rs 50 Stamp Duty once only, hence I have added this Rs 50 in whole calculation whether single trade in a day or multiple trades, it will calculate Rs 50 every time (that is not going to bother me anyhow). Finally, the charges are still a little different than those being shown on your website but that does not matter at all too because the final amount being shown in my calculation sheet is near to actual amount in my account, so it will do the work.
shekharz
The calculation sheet I made is now WORKING PERFECTLY, and even the "Paisa" (decimal) are matching too. I have also made it to work with the Rs 50 Stamp Duty part, whether one takes 1 Entry+Exit in a day or 10 Entry+Exit, it will deduct only Rs 50 when the date changes, otherwise it will NOT deduct that Rs 50.
NOW MY CONCERN IS :-
Can you give me the calculations for brokerage with the latest changes with effect from 1st June 2013 onwards, so that I may amend the formula & get the latest calculation of new brokerage structure in my excel sheet.
Waiting for your response.
shekharz