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

» Undervalued Stocks
by kasun_gimhana Today at 1:06 am

» OVERSEAS REALTY (CEYLON) PLC (OSEA.N000)
by KavinduTM Yesterday at 11:08 pm

» MANUFACTURING OF PORCEIAIN MOSATC TTLES FOR EXPORT MARKET
by engineer Yesterday at 10:17 pm

» Dhammika Perera Aquire ALUF @23 Now at 50%Discount
by engineer Yesterday at 7:36 pm

» LOLC FINANCE PLC (LOFC.N0000)
by NANDANA2012 Yesterday at 7:10 pm

» Shares to Buy
by hammurabi Yesterday at 2:10 pm

» Recognize TRENDS
by target1 Yesterday at 12:57 pm

» LANKA ORIX LEASING COMPANY PLC
by Beta1 Yesterday at 10:59 am

» EAST WEST PROPERTIES PLC (EAST.N0000)
by Winner123 Yesterday at 10:51 am

» Sri Lanka facilitating first US$400mn investment at Port City: Cabraal
by ipo Yesterday at 9:34 am

» POSITIVE ECONOMIC & POLITICAL STABILITY
by Kipling Yesterday at 9:30 am

» COLO and DOCK Moving to 100
by Jay-Jay Yesterday at 9:00 am

» CITRUS LEISURE PLC (REEF.N0000)
by Hope123 Yesterday at 7:30 am

» Saudi Aramco shares surge 10% first day of trading
by Teller Thu Dec 12, 2019 9:39 pm

» Sri Lanka interest rates should go down, currency will not fall: Mark Mobius
by NANDANA2012 Thu Dec 12, 2019 7:03 pm

» C M HOLDINGS PLC (COLO.N0000)
by Jay-Jay Thu Dec 12, 2019 4:41 pm

» Investment Advice
by KavinduTM Thu Dec 12, 2019 3:38 pm

» John Keells Holdings drags down Sri Lanka stocks
by KavinduTM Thu Dec 12, 2019 2:42 pm

» EASTERN MERCHANTS PLC (EMER.N0000)
by ThilinaM Thu Dec 12, 2019 2:39 pm

» E-CHANNELLING PLC (ECL.N0000)
by engineer Thu Dec 12, 2019 12:23 pm

» Some FB friends asking what is the best broker and what is the best amount to invest
by ThilinaM Thu Dec 12, 2019 11:13 am

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

COLOMBO FORT LAND & BUILDING 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 » CSE Screener

CSE Screener

Go to page : 1, 2  Next

Go down  Message [Page 1 of 2]

1CSE Screener Empty CSE Screener on Wed Dec 04, 2013 7:26 pm

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
This share screener will allow you to scan the entire market for any of the following combinations
Hopefully this will save a lot of time for you.

1. P/E Ratio
2. Return On Equity (ROE)
3. Current Dividend Yield
4. Five Year Dividend Growth Rate
5. Five Year EPS Growth Rate
6. Five Year Average Dividend Yield

All you have to do is select the preferred Minimum and Maximum values(YellowCells)
and click on "SCREEN" button.

For example if you want to search for all companies which have,
1)P/E less than 10
2)ROE greater than 20%
3)Current DY greater than 3%
4)Five year dividend growth rate greater than 10%
5)Five year EPS growth rate greater than 10%
6)Five year average dividend yield greater than 3%
Following will be your inputs and screen results.
CSE Screener Scrres10

As you can see above, there are 10 counters which matches your search criteria.
Also it is worth to look at the distribution charts of Screening Parameters.
This will give you the big picture of Colombo Stock Exchange.
Graphs are on "Distribution Charts" sheet.
CSE Screener Chart_10
CSE Screener Chart_11
CSE Screener Chart_12
There are,
・58 counters with five year EPS growth of more than 30%
・51 counters with ROE higher than 20%
・37 counters which are trading P/E below 5
・36 counters which yielded over 5% dividend
・33 counters which paid over 4% dividend for last 5 years
・32 counters with five year dividend growth of more than 30%

Download the tool here
mediafire.com view/prbkigussekmvpy/CSE_Screener_1_4_0.xlsm
Note : You should enable Macro and Data Connection from Excel Trust Center for this to work.

2CSE Screener Empty Re: CSE Screener on Wed Dec 04, 2013 8:43 pm

Gaja


Associate Director - Equity Analytics
Associate Director - Equity Analytics
Really good article friends, but i don't think most of them forum is willing to wait for sometime, wanted the return immediately

3CSE Screener Empty Re: CSE Screener on Wed Dec 04, 2013 9:24 pm

kalum


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
bro this is amazing!

Thank you for your effort and it's a valuable work you are doing for us. please keep it up!

4CSE Screener Empty Re: CSE Screener on Wed Dec 04, 2013 9:43 pm

gamakak


Stock Analytic
Stock Analytic
thanks

5CSE Screener Empty Re: CSE Screener on Wed Dec 04, 2013 9:56 pm

nihal123

nihal123
Manager - Equity Analytics
Manager - Equity Analytics
Thanks
Very Happy 

6CSE Screener Empty Re: CSE Screener on Wed Dec 04, 2013 10:34 pm

cseguide

cseguide
Assistant Vice President - Equity Analytics
Assistant Vice President - Equity Analytics
Why I can't download it. I get sponsors add page. could you please help me to resolve this issue ?

7CSE Screener Empty Re: CSE Screener on Thu Dec 05, 2013 10:28 am

prasadrmb

prasadrmb
Manager - Equity Analytics
Manager - Equity Analytics
Thanks, It's valuable...

8CSE Screener Empty Re: CSE Screener on Thu Dec 05, 2013 11:57 am

K.Haputantri

K.Haputantri
Co-Admin
Well done Dileepa. This is what we were waiting for. Its excellant!!!cheers

9CSE Screener Empty Re: CSE Screener on Thu Dec 05, 2013 12:00 pm

K.Haputantri

K.Haputantri
Co-Admin
Dileepa I get Author version again. ?Can you fix it. I remember you fixed it last time. Thanks.

10CSE Screener Empty Re: CSE Screener on Thu Dec 05, 2013 12:33 pm

Deva


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
Very useful tool for analysis. Thanks Dileepa.

11CSE Screener Empty Re: CSE Screener on Thu Dec 05, 2013 3:36 pm

K.Haputantri

K.Haputantri
Co-Admin
Wow, its Good. Dileepa there are restrictions in entering values and updating data base. Also how to draw distribution charts shown in the post. ?Can you comment on this. Thanks a lot.cheers

12CSE Screener Empty Re: CSE Screener on Thu Dec 05, 2013 4:53 pm

Jana1


Assistant Vice President - Equity Analytics
Assistant Vice President - Equity Analytics
Good one mate...

13CSE Screener Empty Re: CSE Screener on Thu Dec 05, 2013 4:56 pm

seek


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
Thanks

14CSE Screener Empty Re: CSE Screener on Thu Dec 05, 2013 5:37 pm

pathfinder

pathfinder
Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
Excellent tool Dileepa,Thank you,you saved my time cheers 

15CSE Screener Empty Re: CSE Screener on Thu Dec 05, 2013 6:49 pm

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
@cseguide wrote:Why I can't download it. I get sponsors add page. could you please help me to resolve this issue ?
MediaFire may be busy some times. Try refreshing the page or using a different browser.

16CSE Screener Empty Re: CSE Screener on Thu Dec 05, 2013 7:01 pm

smallville

smallville
Associate Director - Equity Analytics
Associate Director - Equity Analytics
Thanks for your efforts now we see hassle free CSE investments Wink Another great work.. Keep it up..

17CSE Screener Empty Re: CSE Screener on Thu Dec 05, 2013 7:14 pm

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
@K.Haputantri wrote:Wow, its Good. Dileepa there are restrictions in entering values and updating data base. Also how to draw distribution charts shown in the post. ?Can you comment on this. Thanks a lot.cheers
Hope you managed to download it.
Values have to be selected from drop down list.
I decided the values after considering standard deviation of each distribution.
Values in the drop down list covers the entire range.

You don't have to do anything to generate the charts. It is there in the "Distribution_Charts" sheet.
They get updated automatically with the data base.
However that update button is disabled for the time being.
Many people trying to update the DB at once may cause unnecessary problems.
Actually one or two updates per quarter will be more than enough.
Need some time to test this properly.
May be later on you will be able to perform the update by your self.

Alternatively, You can use the HealthCheck tool get real time data.
#Just do the screening here and use HealthCheck tool to double check.

18CSE Screener Empty Re: CSE Screener on Thu Dec 05, 2013 7:21 pm

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
@Gaja wrote:Really good article friends, but i don't think most of them forum is willing to wait for sometime, wanted the return immediately
I know that many people want to get rich quickly cheers 
Just copy pasting from my blog:


Why Dividends Are Important
When making a investment decision, Dividend Yield is the fist thing I look at. I consider many other factors, but I never invest on non dividend paying companies. This is why dividends are so important to me.

1. A Guarantee Of Safety
Generally companies which pay dividends are well established and managed professionally.
A company can not pay dividends (and keep on increasing it for years) if their core business is at risk. Financials can be manipulated but dividends are not. If they don't have cash, then they can't pay you. Once they pay it, it is cash in your pocket and it is yours to spend.

Dividends are the best feedback I can get from a company. Look at the companies like LLUB, NEST, CTC, GLAS, etc. They have been doing something right for decades. If you are holding a dividend paying stock, there is a team of professionals working tirelessly for you. They will worry about the economy, government policy, inflation, war or even zombi attacks for you. When I receive a dividend check, it is not just a check. It's a Certificate of Safety.

2. Beating The Inflation
Investors must keep a close eye on the inflation. Inflation eat up the wealth without you being noticed. However dividend investors can protect their income against inflation by carefully selecting companies which increase dividend at a rate higher than the inflation.
If you are going to retire one day(we all will) and live off the dividend income,
then you have to make sure your dividend check get bigger in every year.

Sri Lanka is a high inflation(10%) country. I always look for companies with a track record of increasing dividends at a rate higher than 10%. This is where [Share Screener] becomes a great asset to me. There are 32 companies which have 5 year dividend growth rate of 30% or more. All of them may not suitable for dividend investors. But there a plenty of opportunities to explore. I do share my dividend analysis here. make sure to subscribe or visit this page frequently to get the updates.

3. Passive Income Generation
This is the ultimate goal of dividend investing. Idea is to collect enough dividend paying shares over the time, to a level where annual dividend received is higher than your annual salary. Imagine what it would be like if you can live off the dividend without touching capital investment. You will never run out of money and one day you can hand over your entire wealth to your grand kids.

I hate to wake up and go to office every morning. I hate rush hour traffic. My dream day will begin when I quit my job and start living off the dividend income. Dividend investors do plan for retirement 10-20 years ahead of time. My parents worked till their 60's to get a pension which became worthless in less than 5 years due to inflation. I'm not going to do the same mistake.  I will go on to details of my retirement plan in a separate post.

4. Magic Of Compounding
Albert Einstein is a true genius. He said, "Compounding Interest is the Greatest Force in the Universe. He who understand it, earns it and he who doesn't, pays it". Dividend investors can reinvest their dividends and earn more from reinvested dividends. Over the years compounding will have a staggering effect on your portfolio.

Actually my favorite part of investing is re-investing the dividends. LLUB is a perfect example for Compounding effect. They pay dividend quarterly. I buy 100+ new shares in every quarter by reinvesting the dividends. If you do the match, my actual dividend yield is considerably higher than the indicated yield. Compounding is a nice topic to discuss and I'm going to make a separate post on this in the future.

5. It Teach Financial Discipline
Perhaps this it the most important part of dividend investing. Dividends will teach you the time value of money. It will prevent you from over trading. You will not do any stupid mistakes. Noise in the market will not effect your decisions. You will have more time to read and think than clicking the mouse. Eventually you will learn to live below your means and save for the future.

I learned that buying new stuff and posting on Facebook will not help in me a long time ago. For many, first thing on the list is a new vehicle after getting first salary. Then maybe a housing loan which you will pay for next 20-30 years. Add a insanely expensive wedding to that and your financial future will be seald for ever. Most professionals I know lives from pay check to pay check. There is no retirement plan in the horizon, let alone an early retirement. Dividend investors will never fall in to traps like this. That alone is enough for me to invest on dividend paying companies.

19CSE Screener Empty Re: CSE Screener on Fri Dec 06, 2013 2:58 am

sriranga

sriranga
Co-Admin
Great stuff Dileepa. Really appreciate your effort.
Keep it up.

http://sharemarket-srilanka.blogspot.co.uk/

20CSE Screener Empty Re: CSE Screener on Fri Dec 06, 2013 3:24 am

Jake Sully

Jake Sully
Manager - Equity Analytics
Manager - Equity Analytics
Thanks a lot.

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