CSE Screener

Dileepa wrote:
I know that many people want to get rich quickly  
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.

kas wrote:I tried several days to download this but still failed, Deleepa could you  please check the link          

cseguide wrote:

kas wrote:I tried several days to download this but still failed, Deleepa could you  please check the link          

I faced the same. But finally identified the reason. It was due to not logging in before download. Kas please check your reason, may be the same. Thanks Deleepa.
Please check you can develop this tool in a website. so that it would be update regularly. may be in the forum itself if possible, may be as a different section.

cseguide wrote:I faced the same. But finally identified the reason. It was due to not logging in before download. Kas please check your reason, may be the same. Thanks Deleepa.
Please check you can develop this tool in a website. so that it would be update regularly. may be in the forum itself if possible, may be as a different section.

K.Haputantri wrote:Dileepa, I noticed that certain results under some shares are zero. ?Is it due to data down load issue or un-availability of necessary info. in the data base.

Dileepa wrote:

K.Haputantri wrote:Dileepa, I noticed that certain results under some shares are zero. ?Is it due to data down load issue or un-availability of necessary info. in the data base.

I also noticed that. It is because data is not available at Financial Times DB.
For example, AEL financial data is not available at @
http://markets.ft.com/research/Markets/Tearsheets/Financials?s=AEL.N0000:CSE

I think it is better to use couple of data sources. Any good suggestions?
Earlier I was using Bloomberg but they don't support CSE now.

Dileepa wrote: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.


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.



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
http://www.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.

KDDND wrote:
I tried this version....
I get a message "error in loading DLL"
how can i get rid of this....
pls help!

Dileepa wrote:Updated the DB. Please download the updated version here.
http://www.mediafire.com/view/3csw669o3wseh6m/CSE_Screener_1_4_1_20140203.xlsm
Received a lot of requests to allow the search results to be sorted. I have unlocked the search results.
Just copy the search results to a separate sheet and do sort/filtering as you wish.

KDDND wrote:
I tried this version....
I get a message "error in loading DLL"
how can i get rid of this....
pls help!

KDDND
Sorry I could not trace the problem.
Please try the updated DB and let me know if you still receive the same error.

Dileepa wrote:Updated the DB. Please download the updated version here.
http://www.mediafire.com/view/3csw669o3wseh6m/CSE_Screener_1_4_1_20140203.xlsm
Received a lot of requests to allow the search results to be sorted. I have unlocked the search results.
Just copy the search results to a separate sheet and do sort/filtering as you wish.

KDDND wrote:
I tried this version....
I get a message "error in loading DLL"
how can i get rid of this....
pls help!

KDDND
Sorry I could not trace the problem.
Please try the updated DB and let me know if you still receive the same error.

KDDND wrote:

Dileepa wrote:Updated the DB. Please download the updated version here.
http://www.mediafire.com/view/3csw669o3wseh6m/CSE_Screener_1_4_1_20140203.xlsm
Received a lot of requests to allow the search results to be sorted. I have unlocked the search results.
Just copy the search results to a separate sheet and do sort/filtering as you wish.

KDDND wrote:
I tried this version....
I get a message "error in loading DLL"
how can i get rid of this....
pls help!

KDDND
Sorry I could not trace the problem.
Please try the updated DB and let me know if you still receive the same error.

Many thx Dileepa!
I will try it from my desktop tomorrow and let u know!
Happy to hv ur reply for me
BR!

kas wrote:

cseguide wrote:

kas wrote:I tried several days to download this but still failed, Deleepa could you  please check the link          

I faced the same. But finally identified the reason. It was due to not logging in before download. Kas please check your reason, may be the same. Thanks Deleepa.
Please check you can develop this tool in a website. so that it would be update regularly. may be in the forum itself if possible, may be as a different section.

Thanks cseguide it worked. Thanks a lot Dileepa great work.