Amended Gain Loss Calculator- Amended the Minimum Broker fee & CDS fee removal

opfdo

opfdo

Vice President - Equity Analytics

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

Dear Members, I amended it according to the CSE circular. This is for you & enjoy it again.
My Previous link
http://forum.srilankaequity.com/t14871-gain-loss-calculator-again?highlight=gain+loss+calculator

Attachments

GAIN LOSS CALCULATOR.xls: You don't have permission to download attachments.; (37 Kb) Downloaded 188 times

Redbulls

Redbulls

Director - Equity Analytics

Posts : 6053
Equity Stars : 16078
Reputation : 770
Join date : 2012-02-14

Thanks a lot freind.

Malika1990

Malika1990

Senior Vice President - Equity Analytics

Posts : 1728
Equity Stars : 8988
Reputation : 123
Join date : 2011-10-28

Thank you very much bro

K.Haputantri

K.Haputantri

Co-Admin

Posts : 2274
Equity Stars : 8893
Reputation : 390
Join date : 2011-12-06
Age : 74
Location : Moratuwa

Thanks opsdo for sharing.

prasadrmb

prasadrmb

Manager - Equity Analytics

Posts : 252
Equity Stars : 5225
Reputation : 41
Join date : 2011-04-19
Location : Anuradapura

Thansk

Roboticfx

Roboticfx

Senior Vice President - Equity Analytics

Posts : 1858
Equity Stars : 7922
Reputation : 131
Join date : 2011-07-16
Location : 5° 55'N - 9° 55' N and 79° 42'E - 81° 52E'.

Here is my creation working on your web browser while you are trading. Please bookmark the calculator to access quickly. This has been written in html and java script mainly by me and i was helped by two friends who are very first members of the group.

This is totally compatible with google chrome as we have tested it. Please adjust the zoom size to normal for better view. In other web browser, controls may be misaligned as of their technical varieties.

100% accurate and 100% malware free.

Happy trading! Open for your comments! Cool

Attachments

RFX stock calculator.zip: Download and extract to a folder. open it with your browser and bookmark it.; You don't have permission to download attachments.; (3 Kb) Downloaded 71 times

Last edited by Roboticfx on Wed Jun 20, 2012 8:53 pm; edited 1 time in total (Reason for editing : Attachment attached)

Rizmi

Rizmi

Manager - Equity Analytics

Posts : 220
Equity Stars : 4866
Reputation : 24
Join date : 2012-05-10
Location : London

Really helpful.. Thank a lot..

Kithsiri

Kithsiri

Senior Vice President - Equity Analytics

Posts : 1758
Equity Stars : 7100
Reputation : 132
Join date : 2011-03-25
Age : 66
Location : රජ්ගම

Thanks.

sriranga

sriranga

Co-Admin

Posts : 6822
Equity Stars : 23043
Reputation : 2855
Join date : 2011-02-01
Location : London

Thanks opfdo and Roboticfx(Book marked).
Really appreciate.

opfdo

opfdo

Vice President - Equity Analytics

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

Roboticfx wrote:Here is my creation working on your web browser while you are trading. Please bookmark the calculator to access quickly. This has been written in html and java script mainly by me and i was helped by two friends who are very first members of the group.

This is totally compatible with google chrome as we have tested it. Please adjust the zoom size to normal for better view. In other web browser, controls may be misaligned as of their technical varieties.

100% accurate and 100% malware free.

Happy trading! Open for your comments!

thank you.

K.Haputantri

K.Haputantri

Co-Admin

Posts : 2274
Equity Stars : 8893
Reputation : 390
Join date : 2011-12-06
Age : 74
Location : Moratuwa

Hi opfdo, Your cal is very much improved now. Thanks.

By the way, would you be able to develop a system for drawing a curve (not leiner) depicting multiple share investment risk/return options, one axis giving Standard deviation of annual return and the other expected annual return of various investment options.

https://www.youtube.com/watch?v=-B-24Guwdsm would give you discriptive lecture formule. There may be others who have done this, but its nothing like having a one locally developped, like your cal. Continue the good work. Good luck. Idea

Storm

Storm

Equity Analytic

Posts : 33
Equity Stars : 4742
Reputation : 0
Join date : 2011-07-12

Hi Opfdo,
Thank you for you calculator.
When we calculate the Net Gain/Loss percentage, I think that the field D17 should be
=IF(C13=0,"-",C17/C11)
Not =IF(C13=0,"-",C17/C13)

It should consider the 'Net Cost'. Not 'Net Selling Value'

Correct me if I am wrong.

opfdo

opfdo

Vice President - Equity Analytics

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

Storm wrote:Hi Opfdo,
Thank you for you calculator.
When we calculate the Net Gain/Loss percentage, I think that the field D17 should be
=IF(C13=0,"-",C17/C11)
Not =IF(C13=0,"-",C17/C13)

It should consider the 'Net Cost'. Not 'Net Selling Value'

Correct me if I am wrong.

correct

Sponsored content

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

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

Latest topics

Amended Gain Loss Calculator- Amended the Minimum Broker fee & CDS fee removal

1 Amended Gain Loss Calculator- Amended the Minimum Broker fee & CDS fee removal Wed Jun 20, 2012 6:52 pm

opfdo

2 Re: Amended Gain Loss Calculator- Amended the Minimum Broker fee & CDS fee removal Wed Jun 20, 2012 7:19 pm

Redbulls

3 Re: Amended Gain Loss Calculator- Amended the Minimum Broker fee & CDS fee removal Wed Jun 20, 2012 7:26 pm

Malika1990

4 Re: Amended Gain Loss Calculator- Amended the Minimum Broker fee & CDS fee removal Wed Jun 20, 2012 7:39 pm

K.Haputantri

5 Re: Amended Gain Loss Calculator- Amended the Minimum Broker fee & CDS fee removal Wed Jun 20, 2012 8:36 pm

prasadrmb

6 Re: Amended Gain Loss Calculator- Amended the Minimum Broker fee & CDS fee removal Wed Jun 20, 2012 8:45 pm

Roboticfx

7 Re: Amended Gain Loss Calculator- Amended the Minimum Broker fee & CDS fee removal Wed Jun 20, 2012 9:07 pm

Rizmi

8 Re: Amended Gain Loss Calculator- Amended the Minimum Broker fee & CDS fee removal Wed Jun 20, 2012 9:16 pm

Kithsiri

9 Re: Amended Gain Loss Calculator- Amended the Minimum Broker fee & CDS fee removal Wed Jun 20, 2012 9:17 pm

sriranga

10 Re: Amended Gain Loss Calculator- Amended the Minimum Broker fee & CDS fee removal Wed Jun 20, 2012 10:24 pm

opfdo

11 Re: Amended Gain Loss Calculator- Amended the Minimum Broker fee & CDS fee removal Sun Sep 02, 2012 10:17 am

K.Haputantri

12 Re: Amended Gain Loss Calculator- Amended the Minimum Broker fee & CDS fee removal Sun Sep 02, 2012 8:08 pm

Storm

13 Re: Amended Gain Loss Calculator- Amended the Minimum Broker fee & CDS fee removal Mon Sep 10, 2012 10:01 pm

opfdo

14 Re: Amended Gain Loss Calculator- Amended the Minimum Broker fee & CDS fee removal

Sponsored content

New topics