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

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

Latest topics

» MARKET CRASH - GUARANTEED
by soileconomy Today at 7:44 am

» Enhancing Project Finance via Bank Instrument
by rajanohle Today at 5:44 am

» Daily Stock Market Update
by Insights Equity Yesterday at 8:11 pm

» Acquiring Undervalued Stock for Your Portfolio by Buying on Bad News
by lbnnirmal Yesterday at 6:52 pm

» SFL GOING TO BUY A LEADING BANK ABOVE 50 RUPEE PER SHARE
by karuna2 Yesterday at 6:34 pm

» BFN Private Placement Date
by anges Yesterday at 3:30 pm

» Foreign fund managers back in sri lanka
by ranferdi Yesterday at 8:53 am

» Power cut time table -Ceylon electricity board
by soileconomy Yesterday at 7:30 am

» Earn Over 100% Profit Monthly In Forex Account Management
by faz1 Mon Mar 25, 2019 9:49 pm

» ITS goinng to be UBC -BFN week
by mahasona2 Mon Mar 25, 2019 9:00 am

» Manipulated Data: 95 Percent of Bitcoin Trading is Fake - Study
by Miss-Sangeetha Mon Mar 25, 2019 8:19 am

» HAMBANTOTA'S REAL DEVELOPMENT STARTS
by Yahapalanaya Mon Mar 25, 2019 6:35 am

» HOTEL BRIGHT FUTURE
by Yahapalanaya Mon Mar 25, 2019 5:29 am

» Profitable Forex Copy (over 100% profit monthly)
by faz1 Sun Mar 24, 2019 9:37 pm

» LOLC Story
by Gajaya Sun Mar 24, 2019 1:48 pm

» Now even Holy See, Pope may be concerned of using 'Perpetual' name by Arjun Aloysius' family for Arjun's Shady 'White Collar Criminal' Businesses?
by Gajaya Sun Mar 24, 2019 12:43 pm

» Export Processing Zone -cost of USD 3.95 billion, : Hambantota oil refinery project runs into initial headwinds
by Trader321 Sun Mar 24, 2019 12:41 pm

» කෙටි කාලයක් තුල රාජ්‍ය සේවක වැටුප 145%-200%ක් උන එකම රට
by Uaecoindubai Sun Mar 24, 2019 11:46 am

» CASH RICH REXP
by EPS Sat Mar 23, 2019 9:20 pm

» Weekly Stock Market Roundup
by Insights Equity Sat Mar 23, 2019 4:28 pm

» ලංකාවට වැස්ස කෘතිම වැස්ස..is it required for Sri Lanka?
by Uaecoindubai Sat Mar 23, 2019 12:03 pm

» What Sri Lanka can do to improve the credibility of Rupee
by Sstar Sat Mar 23, 2019 11:30 am

» Sad situation of expressway !!!!
by Yahapalanaya Sat Mar 23, 2019 4:12 am

» GOLDEN ERA
by soileconomy Fri Mar 22, 2019 9:14 pm

» INSURANCE companies finally falling!
by nosf766 Fri Mar 22, 2019 2:00 pm

» Cinnamon Grand now Topless without Rohan Karr
by ChooBoy Fri Mar 22, 2019 1:47 pm

» Dusit Thani Sri Lanka project halted?
by ChooBoy Fri Mar 22, 2019 11:44 am

» UBC - What is going on
by Trader321 Fri Mar 22, 2019 9:39 am

» UBC TO HIT 24 ??
by Trader321 Fri Mar 22, 2019 9:38 am

» SEC Chief welcomes PM’s remark on EPF’s return to stock market
by kalu351 Fri Mar 22, 2019 2:16 am

» පැලවත්ත කිරි සමාගම කොටස් වෙළද පොළට,DRINK pelawaththa milk & help sri lanka
by Miss-Sangeetha Thu Mar 21, 2019 5:39 pm

» CSE is promoting Life Insurance companies whilst Stock Market is crashing.
by ChooBoy Thu Mar 21, 2019 12:35 pm

» Singapore rejects Sri Lankan leader’s allegation on trading scam suspect
by Yahapalanaya Thu Mar 21, 2019 8:18 am

» BALA.N potential
by Yahapalanaya Thu Mar 21, 2019 6:39 am

» Sri lanka tourism income reached 4.4 billion USD 2019
by Yahapalanaya Wed Mar 20, 2019 10:03 pm

» presidential election very soon ?
by Yahapalanaya Wed Mar 20, 2019 10:01 pm

» UBC - Stake up by big invester
by Yahapalanaya Wed Mar 20, 2019 9:57 pm

» AEL.N0000 is the Next AAIC.N0000 -
by Trader321 Wed Mar 20, 2019 12:37 pm

» World Bank approves USD70Mn to Sri Lanka
by Sstar Wed Mar 20, 2019 11:13 am

» Sri Lanka shares end little changed; rupee rises
by Miss-Sangeetha Tue Mar 19, 2019 6:30 pm

» Diversification of Sri Lankan economy, must to garner more economic benefits
by ChooBoy Tue Mar 19, 2019 2:04 pm

» ALHP Right issue......!!!!1
by Miss-Sangeetha Tue Mar 19, 2019 11:47 am

» UBC.N0000- Donnt miss this
by Trader321 Tue Mar 19, 2019 10:13 am

» BFN - DEAL OVER - TO BE DE LISTED SOON AFTER THE PRIVATE PLACEMENT ඩීල් එක ඉවරයි @ 19-59 - කොටස් වෙළදපලෙනුත් ඉවත් කරගන්නා බවට ආරන්චි
by sanjulanka Mon Mar 18, 2019 7:03 am

» While waiting for the market to rebound, look for bargains if you can afford the risk. Try to be active at the right time to gain something
by Asoka Samarakone Sun Mar 17, 2019 3:18 pm

» ඉතා ඉක්මනින් සේවක අර්තසාදක අරමුදල නැවත කොටස් වෙළදපල ට
by mahasona2 Sun Mar 17, 2019 3:43 am

» Central Bank targeting early return of EPF to stock market
by mahasona2 Sun Mar 17, 2019 3:24 am

» Lofc delisting??
by Bdcdman Sat Mar 16, 2019 11:16 pm

You are not connected. Please login or register

Sri Lanka Equity Forum » Expert Chamber » CSE Screener

CSE Screener

Go down  Message [Page 1 of 1]

1 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.


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.

2 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

3 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!

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

gamakak


Stock Analytic
Stock Analytic
thanks

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

nihal123

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

6 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 ?

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

prasadrmb

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

8 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

9 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.

10 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.

11 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

12 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...

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

seek


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
Thanks

14 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 

15 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.

16 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..

17 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.

18 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.

19 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/

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

Jake Sully

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

21 Re: CSE Screener on Fri Dec 06, 2013 2:34 pm

K.Haputantri

K.Haputantri
Co-Admin
Dileepa your article copied from your blog post is an eye openner to many. Thanks for sharing a valuable article on value investing.

Just a few suggestions to improve the screener so that priority areas where funds need diversion for maximisation of profits could be easily decided;
1. Addition of a collumn to show price of the share at the time of calculation with the date if possible.
2. Addition of another collumn to calculate "per rupee benifit of ...." using a suitable info such as 5yr average dividend or 5yr average EPS and current share price.

Thank you once again.

22 Re: CSE Screener on Fri Dec 06, 2013 7:28 pm

pathfinder

pathfinder
Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
@Dileepa wrote:
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.
Good one Dileepa,It reminds me one of the great book of investment Very Happy 

23 Re: CSE Screener on Fri Dec 06, 2013 8:57 pm

kas

kas
Manager - Equity Analytics
Manager - Equity Analytics
I tried several days to download this but still failed, Deleepa could you please check the link

24 Re: CSE Screener on Fri Dec 06, 2013 9:19 pm

cseguide

cseguide
Assistant Vice President - Equity Analytics
Assistant Vice President - Equity Analytics
@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.

25 Re: CSE Screener on Fri Dec 06, 2013 10:03 pm

kas

kas
Manager - Equity Analytics
Manager - Equity Analytics
@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.

26 Re: CSE Screener on Sat Dec 07, 2013 12:24 am

ananda95


Equity Analytic
Equity Analytic
Thanks man, this is a great tool!

27 Re: CSE Screener on Sat Dec 07, 2013 3:00 pm

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
@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.
Thanks cseguide, That might be the case for some. But I could download it without logging in. I also uploaded it to dropbox. Those who are having problems can try this too.
https://www.dropbox.com/s/qcknffif3rmj6ye/CSE_Screener_1_4_0.xlsm

I will try to make the changes suggested by you and Hapu.
Anyway Forum is not flexible enough for that type of work.
May be next year I will implement this in a website.

28 Re: CSE Screener on Sat Dec 07, 2013 4:53 pm

K.Haputantri

K.Haputantri
Co-Admin
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.

29 Re: CSE Screener on Sun Dec 08, 2013 4:20 pm

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
@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.

30 Re: CSE Screener on Tue Dec 10, 2013 2:07 pm

K.Haputantri

K.Haputantri
Co-Admin
@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.

My knowledge on data bases is limited. May be Sriranga will be able to help.

31 Re: CSE Screener on Sat Dec 14, 2013 6:03 am

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
Updated the DB yesterday, Download the updated version here.
http://www.mediafire.com/view/qpl6yx07qi34lnf/CSE_Screener_1_4_1.xlsm
There are some slight changes with the release of last quarter results.

32 Re: CSE Screener on Mon Dec 30, 2013 7:30 am

PROPRITER

PROPRITER
Equity Analytic
Equity Analytic
Do Agree.CTC, GLASS, NEST & LLUB are multinationals. Trough the dividend they get pumped money abroad.

33 Re: CSE Screener on Thu Feb 06, 2014 6:40 pm

KDDND

KDDND
Assistant Vice President - Equity Analytics
Assistant Vice President - Equity Analytics
@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.

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

34 Re: CSE Screener on Thu Feb 06, 2014 7:34 pm

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
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.

35 Re: CSE Screener on Thu Feb 06, 2014 9:25 pm

KDDND

KDDND
Assistant Vice President - Equity Analytics
Assistant Vice President - Equity Analytics
@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 Smile
BR!

36 Re: CSE Screener on Thu Feb 06, 2014 9:44 pm

jonta999

jonta999
Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
@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.

Thank you

37 Re: CSE Screener on Sat Feb 08, 2014 12:09 am

KDDND

KDDND
Assistant Vice President - Equity Analytics
Assistant Vice President - Equity Analytics
@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 Smile
BR!

THANK YOU Dileepa!
Its Working WELL!!!
Unbelievable good work!
How frequent we have to re-download or update the DB?
Great help!




38 Re: CSE Screener on Mon Mar 24, 2014 5:26 pm

lux2014

lux2014
Manager - Equity Analytics
Manager - Equity Analytics
Thanks a lot Dileepa for your hard work. A great help!!!

39 Re: CSE Screener on Fri May 09, 2014 2:53 pm

cseguide

cseguide
Assistant Vice President - Equity Analytics
Assistant Vice President - Equity Analytics
@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.
thanks

Back to top  Message [Page 1 of 1]

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