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

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

Latest topics

» Shares to Buy
by abey Today at 12:07 am

» අගමැති ධූරයෙන් රනිල් ඉවත්වේ - ගෝඨාභයගෙන් ඇමති ධූර15 කින් යුතු භාරකාර රජයක්
by Cma Yesterday at 11:59 pm

» CITRUS LEISURE PLC (REEF.N0000)
by hanuma Yesterday at 11:39 pm

» SMB LEASING PLC (SEMB.N0000)
by Mr-Star Yesterday at 8:22 pm

» Where our leader teller
by Chathuranga55 Yesterday at 7:53 pm

» OPINION POLL: Presidential Elections 2020
by Miss-Sangeetha Yesterday at 7:04 pm

» FIRST CAPITAL HOLDINGS PLC (CFVF.N0000)
by ampm86 Yesterday at 6:45 pm

» Bulk Foreign Buyer for AEL worming up tomorrow (None Varified information)
by cseranga Yesterday at 5:27 pm

» Is Nimal Perera trying to push down East shares using Twitter to buy More at lower price to collect dividend?
by wbslstocks Yesterday at 12:30 pm

» B P P L HOLDINGS PLC (BPPL.N0000)
by Winner123 Yesterday at 12:00 pm

» GR-MR administration ready with economic strategy for Sri Lanka: Cabraal
by samaritan Yesterday at 11:58 am

» ROYAL CERAMICS PLC (RCL.N0000)
by NANDANA2012 Yesterday at 11:52 am

» S&P SL20 Companies
by Quibit Yesterday at 10:50 am

» AEL or RCL ?
by sarathwithana Yesterday at 10:33 am

» LOLC FINANCE PLC (LOFC.N0000)
by Promoney Yesterday at 9:12 am

» GENERAL ELECTION AROUND THE CORNER?
by samaritan Yesterday at 8:57 am

» First monetary policy review under new government on November 29
by fireshelter Mon Nov 18, 2019 10:53 pm

» Asph 100% GAIN... Rs 300 to Rs 600
by vikiperera Mon Nov 18, 2019 9:13 pm

» SIERRA CABLES PLC (SIRA.N0000)
by hammurabi Mon Nov 18, 2019 8:45 pm

» Truncation
by evanpattern Mon Nov 18, 2019 6:32 pm

» MULL trade up possibilities
by Arrowrisk Mon Nov 18, 2019 3:24 pm

POPULAR COMPANIES
A

ABANS ELECTRICALS PLC

ACCESS ENGINEERING PLC Hot

ACL CABLES PLC

ACL PLASTICS PLC

ACME PRINTING & PACKAGING PLC

AGSTAR PLC

AITKEN SPENCE HOTEL HOLDINGS PLC

AITKEN SPENCE PLC

ANILANA HOTELS AND PROPERTIES PLC

ARPICO INSURANCE PLC

ASIA ASSET FINANCE PLC

ASIA CAPITAL PLC

B

BAIRAHA FARMS PLC

BALANGODA PLANTATIONS PLC

BIMPUTH FINANCE PLC

BLUE DIAMONDS JEWELLERY WORLDWIDE PLC

B P P L HOLDINGS PLC

BROWNS BEACH HOTELS PLC

BROWNS INVESTMENTS PLC

C

CARGO BOAT DEVELOPMENT COMPANY PLC

CENTRAL INDUSTRIES PLC

CEYLON COLD STORES PLC

CEYLON GRAIN ELEVATORS PLC Hot

CEYLON TEA BROKERS PLC

CEYLON TOBACCO COMPANY PLC

CHEVRON LUBRICANTS LANKA PLC

COMMERCIAL BANK OF CEYLON PLC

CITRUS LEISURE PLC Hot

COMMERCIAL CREDIT AND FINANCE PLC

D

DANKOTUWA PORCELAIN PLC

DFCC BANK PLC

DIALOG AXIATA PLC

DIALOG FINANCE PLC

DIPPED PRODUCTS PLC

DISTILLERIES COMPANY OF SRI LANKA PLC

DUNAMIS CAPITAL PLC

E

EAST WEST PROPERTIES PLC Hot

EASTERN MERCHANTS PLC

EXPOLANKA HOLDINGS PLC

E-CHANNELLING PLC

F

FIRST CAPITAL HOLDINGS PLC

G

GALADARI HOTELS (LANKA) PLC

GUARDIAN CAPITAL PARTNERS PLC

H

HATTON NATIONAL BANK PLC

HAYLEYS PLC

HAYLEYS FABRIC PLC

HAYLEYS FIBRE PLC Hot

HEMAS HOLDINGS PLC

HIKKADUWA BEACH RESORT PLC

HNB ASSURANCE PLC

HVA FOODS PLC

J

JANASHAKTHI INSURANCE COMPANY PLC

JOHN KEELLS HOLDINGS PLC Hot

JOHN KEELLS HOTELS PLC

L

LANKA ASHOK LEYLAND PLC

LANKA IOC PLC

LANKEM CEYLON PLC

LANKEM DEVELOPMENTS PLC

LAUGFS GAS PLC

LAUGFS POWER LIMITED

LOLC FINANCE PLC

LOLC HOLDINGS PLC

LUCKY LANKA MILK PROCESSING COMPANY PLC

M

MELSTACORP PLC

N

NATIONAL DEVELOPMENT BANK PLC

NATION LANKA FINANCE PLC

NESTLE LANKA PLC

O

ORIENT FINANCE PLC

OVERSEAS REALTY (CEYLON) PLC

P

PANASIAN POWER PLC

PEOPLE'S LEASING & FINANCE PLC

PIRAMAL GLASS CEYLON PLC

PRIME FINANCE PLC

R

RAIGAM WAYAMBA SALTERNS PLC

RENUKA AGRI FOODS PLC

RENUKA CAPITAL PLC

RENUKA HOLDINGS PLC

RICHARD PIERIS AND COMPANY PLC

RICHARD PIERIS EXPORTS PLC Hot

ROYAL CERAMICS PLC

S

SAMPATH BANK PLC

SEYLAN BANK PLC

SIERRA CABLES PLC

SINGHE HOSPITALS PLC Hot

SMB LEASING PLC

SOFTLOGIC HOLDINGS PLC

SOFTLOGIC LIFE INSURANCE PLC

SRI LANKA TELECOM PLC

SWISSTEK (CEYLON) PLC Hot

T

TEEJAY LANKA PLC

TESS AGRO PLC

THREE ACRE FARMS PLC

TOKYO CEMENT COMPANY (LANKA) PLC Hot

U

UNION BANK OF COLOMBO PLC

V

VALLIBEL FINANCE PLC

VALLIBEL ONE PLC Hot

VALLIBEL POWER ERATHNA PLC

W

WASKADUWA BEACH RESORT PLC

Advertise

You are not connected. Please login or register

Sri Lanka Equity Forum » Stock Market Talk » Expert Chamber » Health Check For Your Holdings

Health Check For Your Holdings

Go to page : 1, 2, 3  Next

Go down  Message [Page 1 of 3]

1Health Check For Your Holdings Empty Health Check For Your Holdings on Sun Nov 24, 2013 5:00 pm

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
This is a simple tool to check the fundamental value of your counters.
This will fetch data from Financial Times(need internet access) and
rank the counters based on several parameters and CSE norms.

Download the tool here:
mediafire.com view/utfewtjjpv608j2/HealthCheck_3_0_0.xlsm
1. Select the counter in C2 (Yellow cell)
2. Click on "Fetch Financials"

Health Check For Your Holdings Rating10

Originally this was developed to keep me away from troubles.
Although I'm still testing the ranking parameters,
easy access to important data will be helpful to many.
#I usually pick counters which score over 60 and avoid which are bellow 40.
This may not work on some counters.
Let me know if you have difficulties getting it to work.

Cheers..

2Health Check For Your Holdings Empty Re: Health Check For Your Holdings on Sun Nov 24, 2013 5:12 pm

Kithsiri

Kithsiri
Senior Vice President - Equity Analytics
Senior Vice President - Equity Analytics
Thanks.
Let me know how to fetch the financials ?

3Health Check For Your Holdings Empty Re: Health Check For Your Holdings on Sun Nov 24, 2013 5:16 pm

Jiggysaurus

Jiggysaurus
Assistant Vice President - Equity Analytics
Assistant Vice President - Equity Analytics
Your spreadsheet gives a ranking of 36 for JKH, it may be that your ranking parameters are giving undue weightage to dividend yield. It may be better to give the user the option to change the ranking parameters.

4Health Check For Your Holdings Empty Re: Health Check For Your Holdings on Sun Nov 24, 2013 5:33 pm

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
>Kithsiri, Just click on "Fetch Financials" button.

>Jiggysaurus,
Yes, that is due to poor dividend yield, growth rate and ROE.
I use this to find absolute safe counters.
JKH rated below 40 does not mean it is a bad investment.
(But that tiny margins and returns are a concern to me)

5Health Check For Your Holdings Empty Re: Health Check For Your Holdings on Sun Nov 24, 2013 6:04 pm

kalum


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
Thanks Dileepa. I found this very much useful. Thank you.

I have few questions tough.

ex:
when i tired to analyze KAHA, it gave me rank 0. EPS /Book value and figures are wrong.

As Jiggysaurus suggested, can you please release another version where we can input some values and thresholds?

Health Check For Your Holdings Kaha11

Appreciate your effort and please keep it up. Smile

6Health Check For Your Holdings Empty Re: Health Check For Your Holdings on Sun Nov 24, 2013 6:42 pm

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
Thank you for pointing out,
As you said Book value per share, Current ratio, Quick ratio, etc are wrong
It seems like FT data order is different for non dividend paying counters.
Will correct that next time.

Any way EPS(-0.5106 LKR ) is correct as per FT.
What is the EPS as per financial reports?
If this is wrong, need to write to FT scratch 

@kalum wrote:
when i tired to analyze KAHA, it gave me rank 0. EPS /Book value and figures are wrong.

As Jiggysaurus suggested, can you please release another version where we can input some values and thresholds?

7Health Check For Your Holdings Empty Re: Health Check For Your Holdings on Sun Nov 24, 2013 8:10 pm

kalum


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
Thanks Dileepa.
As per the last quarter report the month ended 30th sep. KAHA
http://www.cse.lk/cmt/upload_report_file/710_1384429899438.pdf

EPS is 0.22

09 months ended - 0.24

I''m not sure if this report considering annualized value?

Sorry i didn't get what is mean by TTM.

BTW, this sort of tools that we needed. I wish you could improve this and share with us soon. This will be very much beneficial for us.Keep it up.

8Health Check For Your Holdings Empty Re: Health Check For Your Holdings on Sun Nov 24, 2013 8:30 pm

K.Haputantri

K.Haputantri
Co-Admin
Thanks Dileepa, but unable to down load. I get "author version" without some cells shown in the post.

9Health Check For Your Holdings Empty Re: Health Check For Your Holdings on Sun Nov 24, 2013 9:31 pm

worthiness


Senior Vice President - Equity Analytics
Senior Vice President - Equity Analytics
@Dileepa.
It seems that the application is not workable in Windows 8 operating system. Please advise.

10Health Check For Your Holdings Empty Re: Health Check For Your Holdings on Mon Nov 25, 2013 11:12 am

prasadrmb

prasadrmb
Manager - Equity Analytics
Manager - Equity Analytics
Thanks Deleep, Valuable one.

11Health Check For Your Holdings Empty Re: Health Check For Your Holdings on Mon Nov 25, 2013 11:40 am

micomgi


Stock Trader
Thank you very much Deleep. Could you please provide the password for source code, I like to change little.

12Health Check For Your Holdings Empty Re: Health Check For Your Holdings on Mon Nov 25, 2013 4:01 pm

maurya


Stock Analytic
Stock Analytic
it does not working in my lap?? any specific system requirements??

13Health Check For Your Holdings Empty Re: Health Check For Your Holdings on Tue Nov 26, 2013 2:43 am

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
@kalum wrote:Thanks Dileepa.
As per the last quarter report the month ended 30th sep. KAHA
http://www.cse.lk/cmt/upload_report_file/710_1384429899438.pdf

EPS is 0.22

09 months ended - 0.24

I''m not sure if this report considering annualized value?

Sorry i didn't get what is mean by TTM.

BTW, this sort of tools that we needed. I wish you could improve this and share with us soon. This will be very much beneficial for us.Keep it up.
TTM means Trailing Twelve Months.
Will do the necessary update asap.
Regards

14Health Check For Your Holdings Empty Re: Health Check For Your Holdings on Tue Nov 26, 2013 2:53 am

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
Those who had problems,

There are some data connection problems.
Will sort that out asap and post here a new update.

Cheers..

15Health Check For Your Holdings Empty Re: Health Check For Your Holdings on Tue Nov 26, 2013 6:11 am

smallville

smallville
Associate Director - Equity Analytics
Associate Director - Equity Analytics
@Dileepa wrote:>Kithsiri, Just click on "Fetch Financials" button.

>Jiggysaurus,
Yes, that is due to poor dividend yield, growth rate and ROE.
I use this to find absolute safe counters.
JKH rated below 40 does not mean it is a bad investment.
(But that tiny margins and returns are a concern to me)
Jiggy,

With JKH we always will have to make judgement calls. Automated tools and even sometimes ctock charts cannot be taken as guidence too..

Deleepa,

Your tremendous efforts in developing these kinda timely inventions need applause.. Thanks for the valueable tool. I found few issues with some counters, as Kalum pointed out KAHA was one and few others also missing data. At the time of writing I did not have time to analyse and tell u all this, but its good to have a look.

Also, counters like JKH - Can you modify it to add a % or a value for 'future prospects' so that we can give a certain amount of value that we think appropriate for its press releases. Like JKH casino project, how it will add revenue to them and the impact it can have for their hotels.
This is kind of a 'mind value' but I donno whether this is possible. Cool 

16Health Check For Your Holdings Empty Re: Health Check For Your Holdings on Tue Nov 26, 2013 5:58 pm

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
@Dileepa wrote:Those who had problems,
There are some data connection problems.
Will sort that out asap and post here a new update.
Cheers..
Fixed the above issue.
Now this should work with any counter, hopefully with accurate data.
Download the new version here ↓
mediafire.com download/nvv3l9au7w2ri3m/

1. If you can't download, Try Firefox or Chrome browser.
2. This is a macro enabled work book. Once you download check the extension.
   It should be ".xlsm"
3. Don't use "Open with" option, Download first and then double click to open.
4. You should enable macros from Trust Center settings for it to work.
Image hosted by servimg.com

5. This need data connectivity to work. Enable data connections from Trust Center
Image hosted by servimg.com

Let me know if receive any error messages or inaccurate data.

17Health Check For Your Holdings Empty Re: Health Check For Your Holdings on Tue Nov 26, 2013 6:11 pm

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
@smallville wrote:

Your tremendous efforts in developing these kinda timely inventions need applause.. Thanks for the valueable tool. I found few issues with some counters, as Kalum pointed out KAHA was one and few others also missing data. At the time of writing I did not have time to analyse and tell u all this, but its good to have a look.

Also, counters like JKH - Can you modify it to add a % or a value for 'future prospects' so that we can give a certain amount of value that we think appropriate for its press releases. Like JKH casino project, how it will add revenue to them and the impact it can have for their hotels.
This is kind of a 'mind value' but I donno whether this is possible. Cool 
small,

Thanks for the feed back. I think data issue is almost fixed now.
Will think about the future prospects issue.
Currently I'm thinking about a statistical method analyses the entire market at once.

Cheers..

18Health Check For Your Holdings Empty Re: Health Check For Your Holdings on Tue Nov 26, 2013 6:25 pm

cseguide

cseguide
Assistant Vice President - Equity Analytics
Assistant Vice President - Equity Analytics
@Dileepa wrote:
@smallville wrote:

Your tremendous efforts in developing these kinda timely inventions need applause.. Thanks for the valueable tool. I found few issues with some counters, as Kalum pointed out KAHA was one and few others also missing data. At the time of writing I did not have time to analyse and tell u all this, but its good to have a look.

Also, counters like JKH - Can you modify it to add a % or a value for 'future prospects' so that we can give a certain amount of value that we think appropriate for its press releases. Like JKH casino project, how it will add revenue to them and the impact it can have for their hotels.
This is kind of a 'mind value' but I donno whether this is possible. Cool 
small,

Thanks for the feed back. I think data issue is almost fixed now.
Will think about the future prospects issue.
Currently I'm thinking about a statistical method analyses the entire market at once.

Cheers..
Thanks Dileepa and keep it up and best wishes for developing a statistical method analyses that you hope to do.

19Health Check For Your Holdings Empty Re: Health Check For Your Holdings on Tue Nov 26, 2013 8:41 pm

smallville

smallville
Associate Director - Equity Analytics
Associate Director - Equity Analytics
@Dileepa wrote:

Currently I'm thinking about a statistical method analyses the entire market at once.

Cheers..
Fantastic news mate.. Keep it up Wink

20Health Check For Your Holdings Empty Re: Health Check For Your Holdings on Tue Nov 26, 2013 8:51 pm

kalum


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
Thanks Dileepa. I will download this now and come back to you with feedback. As small has mentioned this type of commitment need to be appreciate and it is very much valuable for us. I wish you happy trade. keep it up. Smile

Sponsored content


Back to top  Message [Page 1 of 3]

Go to page : 1, 2, 3  Next

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