Gain/Loss Calculator

opfdo · 1 Gain/Loss Calculator Fri May 27, 2011 3:14 pm

opfdo

Vice President - Equity Analytics

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

i have created this for my use. this might be helpful to you. pls find the attached file.

Password to unprotect the file is DEWMINI
now you can modify & change according to the changes & also add value additions Very Happy

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

Attachments

GAIN LOSS CALCULATION.xls: this might be helpful to you all.; You don't have permission to download attachments.; (39 Kb) Downloaded 433 times

Slstock · 2 Re: Gain/Loss Calculator Fri May 27, 2011 3:19 pm

Slstock

Director - Equity Analytics

Posts : 6610
Equity Stars : 13386
Reputation : 1158
Join date : 2011-01-22

osmand wrote:i have created this for my use. this might be helpful to you. pls find the attached file.

Rep from me for your effort

Akalanka · 3 Re: Gain/Loss Calculator Fri May 27, 2011 3:37 pm

Akalanka

Manager - Equity Analytics

Posts : 205
Equity Stars : 6133
Reputation : 45
Join date : 2011-04-03
Location : Colmbo

osmand wrote:i have created this for my use. this might be helpful to you. pls find the attached file.

Nice work.. appreciations Very Happy

2011_NewComer · 4 Re: Gain/Loss Calculator Fri May 27, 2011 3:38 pm

2011_NewComer

Senior Manager - Equity Analytics

Posts : 559
Equity Stars : 5573
Reputation : 77
Join date : 2011-03-10
Location : Colombo

Thanks for sharing +rep

specialist · 5 Re: Gain/Loss Calculator Fri May 27, 2011 3:44 pm

specialist

Equity Analytic

Posts : 34
Equity Stars : 4882
Reputation : 9
Join date : 2011-03-01

Very nice and neat. Thanks for sharing.

abra12 · 6 Re: Gain/Loss Calculator Fri May 27, 2011 4:47 pm

abra12

Manager - Equity Analytics

Posts : 139
Equity Stars : 5008
Reputation : 18
Join date : 2011-02-10

Good work.

TortoizePlus · 7 Re: Gain/Loss Calculator Fri May 27, 2011 5:40 pm

TortoizePlus

Manager - Equity Analytics

Posts : 197
Equity Stars : 5124
Reputation : 14
Join date : 2011-02-05

thanks osmand

opfdo · 8 Re: Gain/Loss Calculator Fri May 27, 2011 6:02 pm

opfdo

Vice President - Equity Analytics

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

thank you all for the appreciations

salimts · 9 Re: Gain/Loss Calculator Fri May 27, 2011 7:06 pm

salimts

Senior Equity Analytic

Posts : 69
Equity Stars : 4890
Reputation : -7
Join date : 2011-04-06
Location : Gaborone, Botswana

Saw it just now. Great effort and thanks for sharing.

hunter · 10 Re: Gain/Loss Calculator Fri May 27, 2011 7:17 pm

hunter

Moderator

Posts : 786
Equity Stars : 6949
Reputation : 114
Join date : 2011-04-27

Nice piece!

milanka · 11 Re: Gain/Loss Calculator Fri May 27, 2011 8:50 pm

milanka

Vice President - Equity Analytics

Posts : 1102
Equity Stars : 6864
Reputation : 164
Join date : 2011-01-28
Location : Q Soft.

Thanks for sharing +rep

Intrinsic · 12 Re: Gain/Loss Calculator Fri May 27, 2011 8:52 pm

Intrinsic

Manager - Equity Analytics

Posts : 158
Equity Stars : 5076
Reputation : 18
Join date : 2011-01-29
Location : Nugegoda

osmand wrote:i have created this for my use. this might be helpful to you. pls find the attached file.

Very nice work ! Keep it up !! + rep from me.

Thor · 13 Re: Gain/Loss Calculator Fri May 27, 2011 10:23 pm

Thor

Senior Equity Analytic

Posts : 81
Equity Stars : 4908
Reputation : 21
Join date : 2011-04-19

Many thanks for this!

Light of Hope · 14 Re: Gain/Loss Calculator Fri May 27, 2011 10:35 pm

Light of Hope

Vice President - Equity Analytics

Posts : 1014
Equity Stars : 5904
Reputation : 59
Join date : 2011-04-04

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.

windi5 · 15 Re: Gain/Loss Calculator Sat May 28, 2011 12:53 am

windi5

Moderator

Posts : 1549
Equity Stars : 7885
Reputation : 157
Join date : 2011-05-21

appreciate your generosity. good work

DESPERADO · 16 Re: Gain/Loss Calculator Sat May 28, 2011 1:32 am

DESPERADO

Stock Trader

Posts : 6
Equity Stars : 4755
Reputation : 3
Join date : 2011-05-25

Thanks for sharing..

gayannadeeka · 17 Re: Gain/Loss Calculator Sat May 28, 2011 7:52 am

gayannadeeka

Manager - Equity Analytics

Posts : 110
Equity Stars : 4951
Reputation : 6
Join date : 2011-03-24
Age : 40
Location : Colombo

Thanks

ishnet · 18 Re: Gain/Loss Calculator Sat May 28, 2011 8:53 am

ishnet

Manager - Equity Analytics

Posts : 148
Equity Stars : 5077
Reputation : 6
Join date : 2011-03-11

Well done,

swan03 · 19 Re: Gain/Loss Calculator Sat May 28, 2011 10:42 am

swan03

Vice President - Equity Analytics

Posts : 1241
Equity Stars : 6740
Reputation : 84
Join date : 2011-01-31

osmand wrote:i have created this for my use. this might be helpful to you. pls find the attached file.

Thanks brother. This is what I have been searching for a long time. You did a good job. One + rep from me.

samank · 20 Re: Gain/Loss Calculator Sat May 28, 2011 10:50 am

samank

Stock Analytic

Posts : 14
Equity Stars : 4866
Reputation : 3
Join date : 2011-02-15

Nice one. Thanks

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

swan03

Vice President - Equity Analytics

Posts : 1241
Equity Stars : 6740
Reputation : 84
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 · 22 Re: Gain/Loss Calculator Sat May 28, 2011 6:07 pm

milanka

Vice President - Equity Analytics

Posts : 1102
Equity Stars : 6864
Reputation : 164
Join date : 2011-01-28
Location : Q Soft.

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 · 23 Re: Gain/Loss Calculator Sat May 28, 2011 11:22 pm

Junius

Stock Trader

Posts : 3
Equity Stars : 4746
Reputation : 0
Join date : 2011-05-28

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

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

Fresher

Moderator

Posts : 1498
Equity Stars : 7523
Reputation : 163
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
Equity Stars : 7890
Reputation : 136
Join date : 2011-05-26
Location : Sri Lanka

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

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

1 Gain/Loss Calculator Fri May 27, 2011 3:14 pm

opfdo

2 Re: Gain/Loss Calculator Fri May 27, 2011 3:19 pm

Slstock

3 Re: Gain/Loss Calculator Fri May 27, 2011 3:37 pm

Akalanka

4 Re: Gain/Loss Calculator Fri May 27, 2011 3:38 pm

2011_NewComer

5 Re: Gain/Loss Calculator Fri May 27, 2011 3:44 pm

specialist

6 Re: Gain/Loss Calculator Fri May 27, 2011 4:47 pm

abra12

7 Re: Gain/Loss Calculator Fri May 27, 2011 5:40 pm

TortoizePlus

8 Re: Gain/Loss Calculator Fri May 27, 2011 6:02 pm

opfdo

9 Re: Gain/Loss Calculator Fri May 27, 2011 7:06 pm

salimts

10 Re: Gain/Loss Calculator Fri May 27, 2011 7:17 pm

hunter

11 Re: Gain/Loss Calculator Fri May 27, 2011 8:50 pm

milanka

12 Re: Gain/Loss Calculator Fri May 27, 2011 8:52 pm

Intrinsic

13 Re: Gain/Loss Calculator Fri May 27, 2011 10:23 pm

Thor

14 Re: Gain/Loss Calculator Fri May 27, 2011 10:35 pm

Light of Hope

15 Re: Gain/Loss Calculator Sat May 28, 2011 12:53 am

windi5

16 Re: Gain/Loss Calculator Sat May 28, 2011 1:32 am

DESPERADO

17 Re: Gain/Loss Calculator Sat May 28, 2011 7:52 am

gayannadeeka

18 Re: Gain/Loss Calculator Sat May 28, 2011 8:53 am

ishnet

19 Re: Gain/Loss Calculator Sat May 28, 2011 10:42 am

swan03

20 Re: Gain/Loss Calculator Sat May 28, 2011 10:50 am

samank

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

swan03

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

milanka

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

Junius

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

Fresher

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

opfdo

26 Re: Gain/Loss Calculator

Sponsored content

New topics