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

» PLC Script dividend @ Rs 14.20.. please mention suggestions...
by ddrperera Yesterday at 4:45 pm

» srilanka regulator charges two over Manipulation
by Capton KIng Cool Yesterday at 3:29 pm

» Dankotuwa pocelin launches-ivory -grade
by Capton KIng Cool Yesterday at 3:23 pm

» Dankotuwa pocelin launches-ivory -grade
by Capton KIng Cool Yesterday at 3:22 pm

» http://www.ft.lk/news/Controversial--Takeover-Act--repealed-by-Parliament/56-680434
by Capton KIng Cool Yesterday at 3:18 pm

» Keep eye on Politics
by samaritan Yesterday at 2:48 pm

» LLUB Pattern reversed. Good buy @60, target +20%
by Teller Yesterday at 11:38 am

» Triple Bottom Reversal
by signals20 Yesterday at 10:31 am

» collect LLUB AND LEDV AND ECL ALONG WITH BFN
by nuwanmja Yesterday at 9:07 am

» LLUB in RISK...Government opened a Plant in Muthurajawela...Becareful
by MarketWch Yesterday at 8:30 am

» USD Bond Issue 3 times over Subscribed.
by ranferdi Tue Jun 25, 2019 3:18 pm

» HEXP 2ND DIVIDEND
by Cricketman Tue Jun 25, 2019 5:21 am

» AEL Recommendation @ 14...
by ddrperera Mon Jun 24, 2019 9:20 pm

» Cut your losses without sinking in it, that's the only way to win in a falling market.
by bhanu Sun Jun 23, 2019 7:38 pm

» Senthilverl Drives Sri Lanka Stock Market Turnover to hit Rs.2 billion
by samaritan Sun Jun 23, 2019 10:57 am

» Dockyard can go beyond 60/-
by hammurabi Sun Jun 23, 2019 10:53 am

» lOFC definitely will hit 6/-
by BANDB Sat Jun 22, 2019 8:31 am

» Why should we elect Naganada kodi..as our next president
by Yahapalanaya Sat Jun 22, 2019 4:56 am

» SAMP Oversubscribed?
by Agape Fri Jun 21, 2019 4:52 pm

» LOFC - LDEV -EXPO ....BULL RUN TIME FOR COLLECTION ..
by Aruna Chandana Fri Jun 21, 2019 1:26 pm

» NEXT RUN People's leasing and Finance WAIT AND WATCH ENJOY RIDE..
by ddrperera Fri Jun 21, 2019 12:04 pm

» SME M&A opportunity
by raheem72@gmail.com Fri Jun 21, 2019 11:41 am

» CIND , 10% guaranteed return
by Teller Fri Jun 21, 2019 2:46 am

» Look PAP Amazing company
by Teller Fri Jun 21, 2019 2:44 am

» Bottom of market
by Teller Thu Jun 20, 2019 10:52 pm

» Triple Top Reversal pattern
by Teller Thu Jun 20, 2019 9:16 pm

» BFN - PRIVATE PLACEMENT ANNOUNCEMENT TO COME SOON
by mahasona2 Thu Jun 20, 2019 1:00 pm

» Why AAIC Should trade above RS.50/-
by wisdom79 Thu Jun 20, 2019 12:38 pm

» PAN ASIA POWER
by Nuwan Samarawickrama Thu Jun 20, 2019 10:33 am

» Aluf will be better
by wisdom79 Thu Jun 20, 2019 8:50 am

» Stop promoting garbage. Don’t get deceived.
by wisdom79 Thu Jun 20, 2019 8:46 am

» RICH is not bad @ 9/-
by Teller Thu Jun 20, 2019 3:18 am

» BFN බොරු සෙලින් දාලා කොහොම හරි 11 වගේ ගානට 500000 එකතු කරගන්න කියලා අර 14 ට ලක්ශයක් සෙලින් දැම්මේ මේ ටේලර් මහත්තයාම තමයි
by Teller Thu Jun 20, 2019 3:16 am

» Be careful with HVA and LITE
by Teller Thu Jun 20, 2019 3:11 am

» WATA future looks good
by Teller Wed Jun 19, 2019 10:00 pm

» If i am the EPF buyer,I will go for PLC
by Teller Wed Jun 19, 2019 9:59 pm

» THE CURSE ON JKH
by Teller Wed Jun 19, 2019 9:04 am

» Why we should buy AEL.N0000…?
by Miss-Sangeetha Wed Jun 19, 2019 7:45 am

» The Curse Of AEL
by Yahapalanaya Tue Jun 18, 2019 11:06 pm

» 8 Finance companaies to be closed very soon
by samaritan Tue Jun 18, 2019 8:52 pm

» Copreus (Pvt) Ltd - Need some Information
by Copreus Tue Jun 18, 2019 12:44 pm

» BALA can come down to 9/-
by Teller Tue Jun 18, 2019 12:27 am

» MARKET UP......BUT BFL....GRAN....TAFL......
by Trader321 Mon Jun 17, 2019 4:31 pm


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 431 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