Share Transaction Record In Excel Sheet

M

Mr_Market

Member
#1
#1
Dear Friends
I purchased 200 shares of AXIS BANK on 26/03/2008 at 808.00 and sold them same day at 830.00 I have kept all my shares transaction on an excel sheet for calculation.But I am not able to calculate exactly the STT .
STT for Intraday is :0 for buy and 0.025% for sell
STT for delivery is 0.125% for buy and 0.125% for sell

Here the calculation should be:
830*200=166000.00
166000.00*0.025/100=41.50(STT)
But the digital contract sent by my broker share khan shows 40.95 as STT
Please tell me if I am wrong in my calculation.

Here is excel sheet of my transactions please tell me if it needs any correction
 
C

cbosein

Active Member
#2
#2
Mr_Market said:
Dear Friends
I purchased 200 shares of AXIS BANK on 26/03/2008 at 808.00 and sold them same day at 830.00 I have kept all my shares transaction on an excel sheet for calculation.But I am not able to calculate exactly the STT .
STT for Intraday is :0 for buy and 0.025% for sell
STT for delivery is 0.125% for buy and 0.125% for sell

Here the calculation should be:
830*200=166000.00
166000.00*0.025/100=41.50(STT)
But the digital contract sent by my broker share khan shows 40.95 as STT
Please tell me if I am wrong in my calculation.

Here is excel sheet of my transactions please tell me if it needs any correction
Click to expand...
Hi Mr Market,

Do you have latest Excel sheet for trading (cash and F&O - Intraday & delivery based) trandactions. Posted file is too old to refer.

Kindly post latest file, please.

Regards,
Keerthi
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
P Taxation of Share Transaction Introductions 0
M Taxes with respect to different kinds of shares transactions Taxation Matters 5
S transaction in sharekhan Brokers & Trading Platforms 34
J Importing Share Transactions of ICICI direct into Tally Development of Software Utilities 0
iTrade Sharekhan - How to find brokerage per transaction? Brokers & Trading Platforms 2

Similar threads