Day Trading Profit calculation issue

bestofluck · 1 Day Trading Profit calculation issue Thu Sep 13, 2012 9:27 pm

bestofluck

Equity Analytic

Posts : 39
Equity Stars : 4401
Reputation : 0
Join date : 2012-07-20

Today I bought 1650 share at Rs.11.6 and sold all of them at Rs.11.9 expecting a profit of Rs. 221.32. But when I check my online statement the actual profit is Rs. 60.73. Is this calculation correct for day trading?

Actual figures in my statement are as follows;
Value
(Purchase ) 1000 shares x Rs. 11.6 = Rs. 19,354.40
(Sale) 1000 shares x Rs. 11.9 = Rs. 19,415.09

Last edited by bestofluck on Thu Sep 13, 2012 10:12 pm; edited 1 time in total

bestofluck · 2 Re: Day Trading Profit calculation issue Thu Sep 13, 2012 10:02 pm

bestofluck

Equity Analytic

Posts : 39
Equity Stars : 4401
Reputation : 0
Join date : 2012-07-20

where all experts? sleeping............still no answer....

kav4 · 3 Re: Day Trading Profit calculation issue Thu Sep 13, 2012 10:12 pm

kav4

Senior Manager - Equity Analytics

Posts : 369
Equity Stars : 5251
Reputation : 36
Join date : 2011-06-17

Check when you get the printed copy of the brought & sold notes. 221/- is the correct amount.

bestofluck · 4 Re: Day Trading Profit calculation issue Thu Sep 13, 2012 10:14 pm

bestofluck

Equity Analytic

Posts : 39
Equity Stars : 4401
Reputation : 0
Join date : 2012-07-20

kav4 wrote:Check when you get the printed copy of the brought & sold notes. 221/- is the correct amount.

Does that mean my broker has done a mistake?

kav4 · 5 Re: Day Trading Profit calculation issue Thu Sep 13, 2012 10:20 pm

kav4

Senior Manager - Equity Analytics

Posts : 369
Equity Stars : 5251
Reputation : 36
Join date : 2011-06-17

Sometimes online version need the night run to update the figures correctly

bestofluck · 6 Re: Day Trading Profit calculation issue Thu Sep 13, 2012 10:22 pm

bestofluck

Equity Analytic

Posts : 39
Equity Stars : 4401
Reputation : 0
Join date : 2012-07-20

kav4 wrote:Sometimes online version need the night run to update the figures correctly

Thanks kav4.. lets check that on 2moro then........no need to be panic...

opfdo · 7 Re: Day Trading Profit calculation issue Thu Sep 13, 2012 10:26 pm

opfdo

Vice President - Equity Analytics

Posts : 1313
Equity Stars : 7890
Reputation : 136
Join date : 2011-05-26
Location : Sri Lanka

It should be 221.32.

if you want use this,

http://forum.srilankaequity.com/t19195-amended-gain-loss-calculator-amended-the-minimum-broker-fee-cds-fee-removal?highlight=gain+loss

just change cell D17 as =IF(C11=0,"-",C17/C11) it is C13 there instead of C11
Smile

bestofluck wrote:Today I bought 1650 share at Rs.11.6 and sold all of them at Rs.11.9 expecting a profit of Rs. 221.32. But when I check my online statement the actual profit is Rs. 60.73. Is this calculation correct for day trading?

Actual figures in my statement are as follows;
Value
(Purchase ) 1000 shares x Rs. 11.6 = Rs. 19,354.40
(Sale) 1000 shares x Rs. 11.9 = Rs. 19,415.09

reez · 8 Re: Day Trading Profit calculation issue Thu Sep 13, 2012 10:37 pm

reez

Manager - Equity Analytics

Posts : 109
Equity Stars : 4811
Reputation : 6
Join date : 2011-09-18
Age : 38
Location : colombo

11.9*1650-(11.6*1650*101.4%)=274.56

opfdo · 9 Re: Day Trading Profit calculation issue Thu Sep 13, 2012 10:43 pm

opfdo

Vice President - Equity Analytics

Posts : 1313
Equity Stars : 7890
Reputation : 136
Join date : 2011-05-26
Location : Sri Lanka

When buying 1.120% charged but selling only 0.3000% (Government cess)

this is wrong i think,

reez wrote:11.9*1650-(11.6*1650*101.4%)=274.56

sahan8896 · 10 Re: Day Trading Profit calculation issue Fri Sep 14, 2012 4:43 am

sahan8896

Assistant Vice President - Equity Analytics

Posts : 933
Equity Stars : 5778
Reputation : 53
Join date : 2011-08-27

(Purchase ) 1650shares x Rs. 11.6 = Rs. 19140
19140*1.12=214.368

(Sale) 1650 shares x Rs. 11.9 = Rs. 19635
19635*0.3 (STL)= 58.905

profit=19635-19140-( 214.368+58.905) = 221.727

Big mistake.

hasintha · 11 Re: Day Trading Profit calculation issue Fri Sep 14, 2012 11:07 am

hasintha

Senior Equity Analytic

Posts : 89
Equity Stars : 4794
Reputation : 4
Join date : 2011-07-15
Age : 37
Location : LonelyPlanet

Your profit is = 221.73/=
Profit per share = 0.134/=
Percentage profit = 1.15%
Break even = 11.77

Don't bother yourself with some crude Excel sheets , use my P&L calculator it's easy to use, Cool