Gain/Loss Calculator

swan03 · 26 Re: Gain/Loss Calculator Sat May 28, 2011 5:58 pm

swan03

Vice President - Equity Analytics

Posts : 1241
Join date : 2011-01-31

Osmand, I calculated my sold stocks using this and compared them with the slips which I received from the broker. It seemed little bit different. According to this SW the broker charges and other charges are low. But the slips I got seem the charges are little bit high. Could you please explain if you don't mind?

milanka · 27 Re: Gain/Loss Calculator Sat May 28, 2011 6:07 pm

milanka

Vice President - Equity Analytics

Posts : 1102
Join date : 2011-01-28

swan03 wrote:Osmand, I calculated my sold stocks using this and compared them with the slips which I received from the broker. It seemed little bit different. According to this SW the broker charges and other charges are low. But the slips I got seem the charges are little bit high. Could you please explain if you don't mind?

I too noticed this , perticularly on the break even point , I used some test data with small quantities , it was + or - with few cents. Then I thought it could be due to rounding off error.

Good that Swan03 also checked.

Junius · 28 Re: Gain/Loss Calculator Sat May 28, 2011 11:22 pm

Junius

Stock Trader

Posts : 3
Join date : 2011-05-28

Many Thanks.Have u got a spread sheet for share input and to record share trading

Fresher · 29 Re: Gain/Loss Calculator Sat May 28, 2011 11:42 pm

Fresher

Moderator

Posts : 1498
Join date : 2011-02-04

milanka wrote:

swan03 wrote:Osmand, I calculated my sold stocks using this and compared them with the slips which I received from the broker. It seemed little bit different. According to this SW the broker charges and other charges are low. But the slips I got seem the charges are little bit high. Could you please explain if you don't mind?

I too noticed this , perticularly on the break even point , I used some test data with small quantities , it was + or - with few cents. Then I thought it could be due to rounding off error.

Good that Swan03 also checked.

i think the formula is such that the total fees are recalculated instead of adding. in the slips we get they are added.

i once did an excel macro long time ago but i lost that file

opfdo

opfdo

Vice President - Equity Analytics

Posts : 1313
Join date : 2011-05-26

Light of Hope wrote:great peice of work. please share the password with us, so that we can modify the parameters if changed in the future. If any of the tax percentages change this could become useless as no one can modify the formulas, with out the password.

or repost it removing the password. Thanks.

"DEWMINI"

use caplocks. Very Happy

opfdo · 31 explanation to swan03 Sun May 29, 2011 10:29 am

opfdo

Vice President - Equity Analytics

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

swan03 wrote:Osmand, I calculated my sold stocks using this and compared them with the slips which I received from the broker. It seemed little bit different. According to this SW the broker charges and other charges are low. But the slips I got seem the charges are little bit high. Could you please explain if you don't mind?

dear sw,

is that quantity less than or equal to 100? If you can send me the qty and selling price i can check & explain you what was there, if you don't mind. Did you calculate the figures using calculator & check ?

opfdo · 32 password to gain loss calculator Sun May 29, 2011 10:36 am

opfdo

Vice President - Equity Analytics

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

here is the password to unprotect the file.

DEWMINI

now you can modify & change according to the changes & also add value additions Very Happy

the break-even comes nearest + or - to zero.

antxster · 33 Re: Gain/Loss Calculator Sun May 29, 2011 11:53 am

antxster

Senior Equity Analytic

Posts : 60
Equity Stars : 5081
Reputation : 0
Join date : 2011-03-01

Hope to see improvement on this calculator. But thanks for your effort Osmand!

ssb · 34 Re: Gain/Loss Calculator Sun May 29, 2011 7:04 pm

ssb

Manager - Equity Analytics

Posts : 228
Equity Stars : 5262
Reputation : 10
Join date : 2011-04-07
Age : 39

thankx brother bounce

rijayasooriya · 35 Re: Gain/Loss Calculator Sun May 29, 2011 10:14 pm

rijayasooriya

Senior Vice President - Equity Analytics

Posts : 1827
Equity Stars : 7007
Reputation : 134
Join date : 2011-05-25
Location : Matara

This is a great work. Thanks for sharing.

thilankad · 36 Re: Gain/Loss Calculator Mon May 30, 2011 6:14 am

thilankad

Manager - Equity Analytics

Posts : 289
Equity Stars : 5564
Reputation : 10
Join date : 2011-02-02

just see right now keep it up thanking you

stockHunter · 37 Re: Gain/Loss Calculator Sun Jun 12, 2011 8:51 pm

stockHunter

Stock Trader

Posts : 8
Equity Stars : 4929
Reputation : 0
Join date : 2011-06-05

GREAT WORK !
Thank you for sharing .. It is very useful

intelstk · 38 Re: Gain/Loss Calculator Sun Jun 12, 2011 10:45 pm

intelstk

Senior Equity Analytic

Posts : 61
Equity Stars : 5026
Reputation : 5
Join date : 2011-05-26

just see it. useful work. thanks bro

dhanushkapg · 39 Re: Gain/Loss Calculator Mon Jun 13, 2011 9:48 am

dhanushkapg

Senior Equity Analytic

Posts : 72
Equity Stars : 4989
Reputation : 3
Join date : 2011-06-08

Good work. Very Happy

Revolution · 40 Re: Gain/Loss Calculator Tue Jun 14, 2011 4:31 pm

Revolution

Equity Analytic

Posts : 20
Equity Stars : 4940
Reputation : 0
Join date : 2011-06-02

Nice work.. works like a charm. +1

Belgrade · 41 Re: Gain/Loss Calculator Tue Jun 14, 2011 4:47 pm

Belgrade

Manager - Equity Analytics

Posts : 118
Equity Stars : 5219
Reputation : -4
Join date : 2011-01-27

Thanks ! nice that you shared with us!

thanujav · 42 Re: Gain/Loss Calculator Tue Jun 14, 2011 5:18 pm

thanujav

Equity Analytic

Posts : 30
Equity Stars : 5008
Reputation : 3
Join date : 2011-04-20

Belgrade wrote:Thanks ! nice that you shared with us!

Good work! it really helpful for me

sas · 43 Re: Gain/Loss Calculator Sun Jul 03, 2011 10:34 am

sas

Senior Manager - Equity Analytics

Posts : 469
Equity Stars : 5416
Reputation : 27
Join date : 2011-07-02
Location : Kandy

great work..thanks a lot

UNI · 44 HOW CAN WE DOWNLOAD THIS? Sun Jul 03, 2011 8:12 pm

UNI

Senior Equity Analytic

Posts : 64
Equity Stars : 5019
Reputation : 2
Join date : 2011-06-10

LINK ?

sas · 45 Re: Gain/Loss Calculator Sun Jul 03, 2011 8:46 pm

sas

Senior Manager - Equity Analytics

Posts : 469
Equity Stars : 5416
Reputation : 27
Join date : 2011-07-02
Location : Kandy

@ UNI
link is in the 1st page
http://forum.srilankaequity.com/download.forum?id=47

sameeramlc · 46 Re: Gain/Loss Calculator Sun Aug 14, 2011 6:43 pm

sameeramlc

Equity Analytic

Posts : 49
Equity Stars : 4974
Reputation : 1
Join date : 2011-06-23
Age : 37
Location : Malabe

Elaz..............

jonny · 47 Re: Gain/Loss Calculator Mon Aug 15, 2011 12:40 pm

jonny

Senior Manager - Equity Analytics

Posts : 347
Equity Stars : 5337
Reputation : 15
Join date : 2011-07-28
Location : UK

Good work.Keep up...!!!! Tks javascript:emoticonp(' Very Happy

')

sas · 48 Re: Gain/Loss Calculator Fri Sep 02, 2011 10:30 pm

sas

Senior Manager - Equity Analytics

Posts : 469
Equity Stars : 5416
Reputation : 27
Join date : 2011-07-02
Location : Kandy

found very useful when I didn't had DFN, keep up the good work, +rep

dewminigamlath · 49 Re: Gain/Loss Calculator Fri Sep 02, 2011 10:40 pm

dewminigamlath

Manager - Equity Analytics

Posts : 126
Equity Stars : 5108
Reputation : 18
Join date : 2011-06-12
Age : 37
Location : Yakkala

Very good work and really appreciate it. But, why 'DEWMINI'? (I mean, that's my name...!)

amilaela · 50 Re: Gain/Loss Calculator Tue Nov 08, 2011 4:39 pm

amilaela

Senior Manager - Equity Analytics

Posts : 430
Equity Stars : 5413
Reputation : 18
Join date : 2011-10-06
Location : colombo

thanks

Sponsored content

Name*:
Phone number:
Email address*:
Comments*:
* - required fields	Learn

Name*:
Phone number:
Email address*:
Comments*:
* - required fields	Learn

Latest topics

Gain/Loss Calculator

26 Re: Gain/Loss Calculator Sat May 28, 2011 5:58 pm

swan03

27 Re: Gain/Loss Calculator Sat May 28, 2011 6:07 pm

milanka

28 Re: Gain/Loss Calculator Sat May 28, 2011 11:22 pm

Junius

29 Re: Gain/Loss Calculator Sat May 28, 2011 11:42 pm

Fresher

30 here is password to unprotect the gain loss calculator Sun May 29, 2011 10:14 am

opfdo

31 explanation to swan03 Sun May 29, 2011 10:29 am

opfdo

32 password to gain loss calculator Sun May 29, 2011 10:36 am

opfdo

33 Re: Gain/Loss Calculator Sun May 29, 2011 11:53 am

antxster

34 Re: Gain/Loss Calculator Sun May 29, 2011 7:04 pm

ssb

35 Re: Gain/Loss Calculator Sun May 29, 2011 10:14 pm

rijayasooriya

36 Re: Gain/Loss Calculator Mon May 30, 2011 6:14 am

thilankad

37 Re: Gain/Loss Calculator Sun Jun 12, 2011 8:51 pm

stockHunter

38 Re: Gain/Loss Calculator Sun Jun 12, 2011 10:45 pm

intelstk

39 Re: Gain/Loss Calculator Mon Jun 13, 2011 9:48 am

dhanushkapg

40 Re: Gain/Loss Calculator Tue Jun 14, 2011 4:31 pm

Revolution

41 Re: Gain/Loss Calculator Tue Jun 14, 2011 4:47 pm

Belgrade

42 Re: Gain/Loss Calculator Tue Jun 14, 2011 5:18 pm

thanujav

43 Re: Gain/Loss Calculator Sun Jul 03, 2011 10:34 am

sas

44 HOW CAN WE DOWNLOAD THIS? Sun Jul 03, 2011 8:12 pm

UNI

45 Re: Gain/Loss Calculator Sun Jul 03, 2011 8:46 pm

sas

46 Re: Gain/Loss Calculator Sun Aug 14, 2011 6:43 pm

sameeramlc

47 Re: Gain/Loss Calculator Mon Aug 15, 2011 12:40 pm

jonny

48 Re: Gain/Loss Calculator Fri Sep 02, 2011 10:30 pm

sas

49 Re: Gain/Loss Calculator Fri Sep 02, 2011 10:40 pm

dewminigamlath

50 Re: Gain/Loss Calculator Tue Nov 08, 2011 4:39 pm

amilaela

51 Re: Gain/Loss Calculator

Sponsored content

New topics