Colombo Stock Exchange Share Screener

On a [previous note] I wrote about the share screener 

which I use to scan the entire market for possible dividend investment opportunities.
Today I'm going to share the tool and give you a brief introduction.
 

Introduction

A share screener is a valuble and time saving tool which allows user to scan the market
for a given set of parameters. There are many online screeners including google and yahoo.
Unfortunately I could not find any screener which supports Colombo Stock Exchange(CSE).
I wrote this in March-2013 and being using since then. This is coded in VB macro and
I use a macro enabled excel work book for better representation of results.
Hopefully this will save a lot of time for you.
 

Screening Parameters

You can scan the market for any of the following combinations
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(Yellow Cells)
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.
 

Results

As you can see above, there are 10 counters which matches your search criteria.
We dividend investors do not jump in and buy just for the greediness of dividend income.
There are many things to consider and this tool will list a lot of other data
to help you in the decision making process. Hoping to make a separate post on this.
In the meantime you can have a look at my "Dividend Analysis on NDB Bank PLC"

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.

 

You will be amazed to find out that 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%

You can see to the enormous growth potential CSE offers for
inteligent, value seeking, longterm dividend growers.
I'm pretty sure Dividend Investing will be the next big thing in Sri Lanka.

Download

Download the tool here
--------------------------------------------------
 Update : Above link was updated on 2014/07/21
--------------------------------------------------
Note : You should enable Macro and Data Connection from Excel Trust Center for this to work.
Make sure you subscribed to mailing list and check this page regularly for updates.
I'm still adding more functions to this and there will be a DB update at least once a month.