Sri Lanka Equity Forum
Dear Reader,

Registration with the Sri Lanka Equity Forum would enable you to enjoy an array of other services such as Member Rankings, User Groups, Own Posts & Profile, Exclusive Research, Live Chat Box etc..

All information contained in this forum is subject to Disclaimer Notice published.


Thank You
Sri Lanka Equity Forum

Discussion Forum for Stock Market Investors in Sri Lanka

සිංහල පරිවර්තනය
Submit Post
Submit Post
Market Place

Add an ad

View all ads

Latest topics

» lOFC definitely will hit 6/-
by Teller Today at 12:33 am

» PAP (Pan Asia Power PLC) Apointiment of Director Mr.Sangith Senaka Kakiriwargodage.
by Teller Today at 12:31 am

» MGT - Collect n keep
by Teller Today at 12:30 am

» EMER...?????
by Teller Today at 12:26 am

» CIND , 10% guaranteed return
by Teller Today at 12:25 am

» SEC charges four stockbrokers over market manipulation
by Teller Today at 12:25 am

» Browns investments
by Winner123 Yesterday at 9:35 pm

» ASHO will hit moon. Deal with SLTB
by Bakka1988 Yesterday at 9:11 pm

» CIND බලාගෙනයි
by Bakka1988 Yesterday at 9:03 pm

» JKH will touch 175 very soon
by Bakka1988 Yesterday at 3:24 pm

» Positive News
by Promoney Yesterday at 2:21 pm

» Why AAIC Should trade above RS.50/-
by nosf76677 Yesterday at 2:01 pm

» GLASS (piramal glass ceylon plc) from
by MarketWch Yesterday at 10:20 am

» Capital trust recommended to buy AEL ..Target Price Rs.24.50
by wisdom79 Yesterday at 9:27 am

» Elcection Commisioner( MACO)
by Capton KIng Cool Yesterday at 8:59 am

» Presidential election will be held on 16 th of November to 7th of December
by rukshan1234 Mon Aug 19, 2019 11:30 pm

» Which Trading System Or Strategy Is The Most Profitable?
by Teller Mon Aug 19, 2019 8:13 pm

» NEST will touch Rs2000 soon
by Bakka1988 Mon Aug 19, 2019 5:41 pm

» Gotabaya Rajapaksha will named after 10th August. Aspi will move above 6500
by samaritan Mon Aug 19, 2019 11:59 am

» CFVF.N0000 - Target price Rs.60- Donnt sell
by Trader321 Mon Aug 19, 2019 10:06 am

» CFVF.N0000 - Really started Again ..........
by Trader321 Mon Aug 19, 2019 9:59 am

» LOLC Holding( LOLC N.0000)
by Capton KIng Cool Mon Aug 19, 2019 8:45 am

» LOLC Holding( LOLC N.0000) MICRO FINACE In Cambodia
by Capton KIng Cool Mon Aug 19, 2019 8:43 am

» PAN ASIA BANK
by samaritan Mon Aug 19, 2019 8:17 am

» CFVF.N0000 - Deal at What price?
by Winner123 Fri Aug 16, 2019 8:35 pm

» Profitability of all the banks slides down on bigger margins
by hammurabi Fri Aug 16, 2019 8:25 pm

» කව්ද පකීර් ?(who is the Veteran)
by reyaz Fri Aug 16, 2019 7:32 pm

» News AEL super report in this quarter Don't sell ..
by sheildskye Fri Aug 16, 2019 6:59 pm

» HEXP : GOOD TO COLLECT BELOW RS.85
by Trader321 Fri Aug 16, 2019 10:20 am

» CFVF.N0000 :Amazing Result- Quarter Profit more than Half Billion
by Winner123 Thu Aug 15, 2019 12:43 pm

» Kzoo vs onal
by wisdom79 Wed Aug 14, 2019 9:45 pm

» GREG is back
by wisdom79 Wed Aug 14, 2019 9:42 pm

» AAIC - Profit over one billion!!!!!
by wisdom79 Wed Aug 14, 2019 9:39 pm

» Sri Lankan Billionaire Dhammika Perera may Spend Rs. 10 Billion for a Presidential Campaign without any Risk! His Daily Casino Profits said to be over Rs. 50 Million
by Teller Wed Aug 14, 2019 8:40 am

» CFVF : Another dividend ?
by Promoney Tue Aug 13, 2019 7:28 pm

» CFVF.N0000 & PARQ.N0000 - These two counters Must be in your Portfolios
by Trader321 Tue Aug 13, 2019 6:39 pm

» PARQ.N0000 : Target Price Rs. 50 /=
by Hewagak Tue Aug 13, 2019 5:01 pm

» TAP Less than 1% Shares in the Market
by sanjulanka Tue Aug 13, 2019 12:10 pm

» AEL PRICE TUESDAY
by Winner123 Tue Aug 13, 2019 12:09 pm

» what is the future of KHL (JOHN KEELES HOTELS)
by bhanu Mon Aug 12, 2019 9:03 pm

» TKYO.X0000 will it move furthur?
by bhanu Mon Aug 12, 2019 5:00 pm

» stock market investors and cheated those who approached them.
by Asoka Samarakone Mon Aug 12, 2019 10:14 am

» LLMP can run in present market
by wealth123 Mon Aug 12, 2019 10:03 am


You are not connected. Please login or register

Sri Lanka Equity Forum » Stock Market Talk » Gain/Loss Calculator

Gain/Loss Calculator

Go to page : 1, 2  Next

Go down  Message [Page 1 of 2]

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

opfdo

opfdo
Vice President - Equity Analytics
Vice President - Equity Analytics
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 Calculator AttachmentGAIN LOSS CALCULATION.xls
this might be helpful to you all.
You don't have permission to download attachments.
(39 Kb) Downloaded 433 times

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

Slstock

Slstock
Director - Equity Analytics
Director - Equity Analytics
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

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

Akalanka

Akalanka
Manager - Equity Analytics
Manager - Equity Analytics
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 Very Happy

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

2011_NewComer

2011_NewComer
Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
Thanks for sharing +rep

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

specialist

specialist
Equity Analytic
Equity Analytic
Very nice and neat. Thanks for sharing.

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

abra12


Manager - Equity Analytics
Manager - Equity Analytics
Good work.

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

TortoizePlus

TortoizePlus
Manager - Equity Analytics
Manager - Equity Analytics
thanks osmand

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

opfdo

opfdo
Vice President - Equity Analytics
Vice President - Equity Analytics
thank you all for the appreciations

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

salimts


Senior Equity Analytic
Senior Equity Analytic
Saw it just now. Great effort and thanks for sharing.

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

hunter

hunter
Moderator
Moderator
Nice piece!

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

milanka

milanka
Vice President - Equity Analytics
Vice President - Equity Analytics
Thanks for sharing +rep

http://forum.srilankaequity.com/u188

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

Intrinsic


Manager - Equity Analytics
Manager - Equity Analytics
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.


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

Thor


Senior Equity Analytic
Senior Equity Analytic
Many thanks for this!

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

Light of Hope


Vice President - Equity Analytics
Vice President - Equity Analytics
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.

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

windi5

windi5
Moderator
Moderator
appreciate your generosity. good work

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

DESPERADO

DESPERADO
Stock Trader
Thanks for sharing..

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

gayannadeeka


Manager - Equity Analytics
Manager - Equity Analytics
Thanks

http://nadeekacf@facebook.com

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

ishnet

ishnet
Manager - Equity Analytics
Manager - Equity Analytics
Well done,

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

swan03


Vice President - Equity Analytics
Vice President - Equity Analytics
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.

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

samank


Stock Analytic
Stock Analytic
Nice one. Thanks

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

swan03


Vice President - Equity Analytics
Vice President - Equity Analytics
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?

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

milanka

milanka
Vice President - Equity Analytics
Vice President - Equity Analytics
@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.

http://forum.srilankaequity.com/u188

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

Junius


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

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

Fresher


Moderator
Moderator
@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
Vice President - Equity Analytics
@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

26Gain/Loss Calculator Empty explanation to swan03 on Sun May 29, 2011 10:29 am

opfdo

opfdo
Vice President - Equity Analytics
Vice President - Equity Analytics
@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 ?


27Gain/Loss Calculator Empty password to gain loss calculator on Sun May 29, 2011 10:36 am

opfdo

opfdo
Vice President - Equity Analytics
Vice President - Equity Analytics
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.

28Gain/Loss Calculator Empty Re: Gain/Loss Calculator on Sun May 29, 2011 11:53 am

antxster


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

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

ssb

ssb
Manager - Equity Analytics
Manager - Equity Analytics
thankx brother bounce

30Gain/Loss Calculator Empty Re: Gain/Loss Calculator on Sun May 29, 2011 10:14 pm

rijayasooriya

rijayasooriya
Senior Vice President - Equity Analytics
Senior Vice President - Equity Analytics
This is a great work. Thanks for sharing.

31Gain/Loss Calculator Empty Re: Gain/Loss Calculator on Mon May 30, 2011 6:14 am

thilankad

thilankad
Manager - Equity Analytics
Manager - Equity Analytics
just see right now keep it up thanking you

http://thilankadinush.blogspot.com/

32Gain/Loss Calculator Empty Re: Gain/Loss Calculator on Sun Jun 12, 2011 8:51 pm

stockHunter


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

33Gain/Loss Calculator Empty Re: Gain/Loss Calculator on Sun Jun 12, 2011 10:45 pm

intelstk


Senior Equity Analytic
Senior Equity Analytic
just see it. useful work. thanks bro

34Gain/Loss Calculator Empty Re: Gain/Loss Calculator on Mon Jun 13, 2011 9:48 am

dhanushkapg


Senior Equity Analytic
Senior Equity Analytic
Good work. Very Happy

35Gain/Loss Calculator Empty Re: Gain/Loss Calculator on Tue Jun 14, 2011 4:31 pm

Revolution


Equity Analytic
Equity Analytic
Nice work.. works like a charm. +1

36Gain/Loss Calculator Empty Re: Gain/Loss Calculator on Tue Jun 14, 2011 4:47 pm

Belgrade

Belgrade
Manager - Equity Analytics
Manager - Equity Analytics
Thanks ! nice that you shared with us!

37Gain/Loss Calculator Empty Re: Gain/Loss Calculator on Tue Jun 14, 2011 5:18 pm

thanujav

thanujav
Equity Analytic
Equity Analytic
@Belgrade wrote:Thanks ! nice that you shared with us!

Good work! it really helpful for me

38Gain/Loss Calculator Empty Re: Gain/Loss Calculator on Sun Jul 03, 2011 10:34 am

sas

sas
Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
great work..thanks a lot

39Gain/Loss Calculator Empty HOW CAN WE DOWNLOAD THIS? on Sun Jul 03, 2011 8:12 pm

UNI


Senior Equity Analytic
Senior Equity Analytic
LINK ?

40Gain/Loss Calculator Empty Re: Gain/Loss Calculator on Sun Jul 03, 2011 8:46 pm

sas

sas
Senior Manager - Equity Analytics
Senior Manager - Equity Analytics

Sponsored content


Back to top  Message [Page 1 of 2]

Go to page : 1, 2  Next

Permissions in this forum:
You cannot reply to topics in this forum