how to calculate brokerage in execl

A

anees_a

hi i am trying to calculate brokerage for trading stocks intra day and
delivery
Intra day
1) for every 100Rs i am charged 0.05% for intraday brokerage
2) and Service tax of 10.3% on brokrage
3)jobbing charges on turnover 0.0052%
4)Service transation charge of 0.025% on turnover on selling in intraday

Delivery
1) for every 100Rs i am charged 0.5% for intraday brokerage
2) and Service tax of 10.3% on brokerage
3)jobbing charges on turnover 0.0132%
4)Service transaction charge of 0.125% on turnover on selling in intraday

for ex

i purchase XYZ stock for 1000 qty for 55rs how do i calculate these in excel
on 2 separate sheets or a single wher if i give I(intraday or D( Delivery)
charges are calculated and i know my break even
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top