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

» 8 Finance companaies to be closed very soon
by samaritan Today at 6:26 pm

» Copreus (Pvt) Ltd - Need some Information
by jake94 Today at 5:15 pm

» Sri Lanka’s largest pension fund EPF return to Colombo Stocks
by samaritan Today at 4:04 pm

» Why AAIC Should trade above RS.50/-
by Teller Today at 10:36 am

» Head and Shoulders Top
by freeforexsignals2020 Today at 8:49 am

» UNION BANK (UBC) to be takeover by Union bank of india
by aklt Today at 1:20 am

» INVEST ON AAIC, HASU, UAL.... YOU WILL NEVER WORRY......
by wisdom79 Yesterday at 7:42 pm

» Pakistan’s trade with Sri Lanka comes to a halt
by soileconomy Yesterday at 7:35 pm

» Daily Stock Market Update
by Teller Yesterday at 7:18 pm

» Market will test 4700
by karuna2 Yesterday at 12:25 pm

» Keep eye on Politics
by samaritan Yesterday at 11:49 am

» CSE from Dawn of Peace to Rebirth of Terrorism
by Yahapalanaya Yesterday at 9:59 am

» EAST Steady at 18
by mark Yesterday at 9:25 am

» New Support Level 5300
by hammurabi Thu May 23, 2019 8:47 pm

» LIOC upward curve
by karuna2 Thu May 23, 2019 5:57 pm

» SEC yet to publish its 2017 Annual Report
by Teller Thu May 23, 2019 5:10 pm

» HNB Assurance March net down 83-pct
by Teller Thu May 23, 2019 1:18 pm

» PABC net down 13-pct in March; loans contract
by Teller Thu May 23, 2019 1:15 pm

» Indian stocks jumped to record highs
by Teller Thu May 23, 2019 1:13 pm

» modi wins-India to no1 in the world
by Teller Thu May 23, 2019 1:07 pm

» Hayleys revenue up 34% YoY to Rs 219 bn in FY 18/19
by Teller Thu May 23, 2019 1:02 pm

» undervalued stock
by Teller Thu May 23, 2019 1:00 pm

» CIND , 10% guaranteed return
by Teller Thu May 23, 2019 12:57 pm

» INVITATION TO FORUM MODERATORS
by Agape Thu May 23, 2019 8:52 am

» Reputation???
by Uaecoindubai Wed May 22, 2019 7:12 pm

» AIA INSURANCE DE-LISTING (CTCE)
by lokka1 Wed May 22, 2019 12:55 pm

» Sri Lanka’s Top 10 Imports
by Gajaya Wed May 22, 2019 11:16 am

» Top 10 Small Scale Business ideas & Opportunities in Sri Lanka 2019
by Gajaya Wed May 22, 2019 11:15 am

» when bank lending rates put down ?
by nuwanmja Wed May 22, 2019 11:01 am

» Sri Lanka's EPF enters stock market with blood in the streets
by God Father Tue May 21, 2019 8:21 pm

» Sri Lanka caught in the big power conflicts
by God Father Tue May 21, 2019 8:16 pm

» High Profile Selling at EAST
by Uaecoindubai Tue May 21, 2019 4:43 pm

» A Trader’s Guide to FIX Engine
by Brenda John Tue May 21, 2019 11:24 am

» Reasons for market to crash
by Uaecoindubai Tue May 21, 2019 10:08 am

» ගෙවුම් ශේෂය, වාහන බලපත් හා ඩොලරයේ මිල
by ChooBoy Mon May 20, 2019 5:59 pm

» Terrorism and its Impact on the Sri Lankan Economy
by ChooBoy Mon May 20, 2019 5:41 pm

» Sri Lanka Equity Market Place
by Sstar Mon May 20, 2019 4:36 pm

» Sri Lanka Equity Market Talk
by Sstar Mon May 20, 2019 12:23 pm

» Sri Lanka Equity Market Help
by Sstar Mon May 20, 2019 12:18 pm

» LOFC IN FOR A BIG RUN
by stockback Sun May 19, 2019 5:20 pm

» Look PAP Amazing company
by Uaecoindubai Sun May 19, 2019 5:13 pm

» Sri Lanka Equity Market Place
by Uaecoindubai Sun May 19, 2019 5:13 pm

» CSE NOW AND AFTER ELECTION
by Ahcha Sun May 19, 2019 4:40 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

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