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

» Seylan right issue
by ThilinaM Today at 9:52 am

» What's going on about vone
by glad Today at 9:09 am

» POSITIVE ECONOMIC & POLITICAL STABILITY
by CITIZEN Today at 8:53 am

» EAST WEST PROPERTIES PLC (EAST.N0000)
by CITIZEN Today at 8:47 am

» SEYLAN BANK PLC (SEYB.N0000)
by Intrinsicvalue Today at 6:29 am

» Central bankers trigger crises, don’t admit or learn from mistakes: economist at Sri Lanka forum
by fireshelter Yesterday at 11:18 pm

» Sri Lanka targets US$6,500 per capita income by 2025
by fireshelter Yesterday at 11:15 pm

» RENUKA CAPITAL PLC (KZOO.N0000)
by fireshelter Yesterday at 10:49 pm

» RENUKA AGRI FOODS PLC (RAL.N0000)
by fireshelter Yesterday at 10:45 pm

» GALADARI HOTELS (LANKA) PLC (GHLL.N0000)
by fireshelter Yesterday at 10:42 pm

» Banking Sector
by PDH Yesterday at 8:16 pm

» Shares to Buy
by ColomboCSE Yesterday at 6:56 pm

» Dhammika Perera Aquire ALUF @23 Now at 50%Discount
by NZ BOY Yesterday at 2:02 pm

» ALLIANCE FINANCE COMPANY PLC (ALLI.N0000)
by KavinduTM Yesterday at 1:22 pm

» Company එකක් DELIST කරන...
by ColomboCSE Yesterday at 1:03 pm

» CSE RULES (CSE වල දැනට තියන නීති ගැන)
by ColomboCSE Yesterday at 12:49 pm

» Key to staying in the trading game for Day Traders
by NANDANA2012 Yesterday at 11:30 am

» LANKA IOC PLC (LIOC.N0000)
by Teller Yesterday at 10:35 am

» Investment Advice
by Gajaya Yesterday at 9:17 am

» කාලෙකට පස්සෙ එන අවස්තාවක් උදා වෙලා කියලයි - හැබැයි අවදානම තියනවා
by Kipling Sat Dec 14, 2019 9:31 pm

» LOLC FINANCE PLC (LOFC.N0000)
by wealth123 Sat Dec 14, 2019 9:07 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

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 » Health Check For Your Holdings

Health Check For Your Holdings

Go to page : Previous  1, 2, 3

Go down  Message [Page 3 of 3]

41Health Check For Your Holdings - Page 3 Empty Re: Health Check For Your Holdings on Sun Dec 01, 2013 2:42 pm

seek


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
Thanx Dileepa. Waiting for ur Screener as well.

42Health Check For Your Holdings - Page 3 Empty Re: Health Check For Your Holdings on Mon Dec 02, 2013 8:33 pm

nihal123


Manager - Equity Analytics
Manager - Equity Analytics
Dear Dileepa
This 52 week low shares on 02/12/ 2013 as your tool

AHUN       63.10 - -    60 %
ASHO    1301.00 - -    68%
BUKI       625.00 - -     56%
CIC N       48.00 - -      9%
CIC X       32.00 - -      0%
GLAS         4.30 - -    85%
KOTA       36.00 - -     37%
LECM         6.40 - -     0%
MPRH       18.00 - -     55%
PMB         10.90 - -    0%
RAL           3.60 - -     34%
SLND    1100.00 - -    17%
SPRN      106.00 - -      50%
TSML       35.00 - -     26%

43Health Check For Your Holdings - Page 3 Empty Re: Health Check For Your Holdings on Mon Dec 30, 2013 8:02 am

PROPRITER


Equity Analytic
Equity Analytic
I checked with JINS, Dividends data is wrong. it shuold be Rs.1 right?

44Health Check For Your Holdings - Page 3 Empty Re: Health Check For Your Holdings on Mon Dec 30, 2013 8:23 am

smallville


Associate Director - Equity Analytics
Associate Director - Equity Analytics
@Mahawawtta wrote:still i cant use this remarkable:cry:  system.

This is working for most of us. If u can elaborate your problem in detail, perhaps with some screen shots, we can help you out..

45Health Check For Your Holdings - Page 3 Empty Re: Health Check For Your Holdings on Mon Dec 30, 2013 2:32 pm

K.Haputantri


Co-Admin
@smallville wrote:
@Mahawawtta wrote:still i cant use this remarkable:cry:  system.

This is working for most of us. If u can elaborate your problem in detail, perhaps with some screen shots, we can help you out..
It works for me. As small said explain your issue in details. There will be some one to help.

46Health Check For Your Holdings - Page 3 Empty Re: Health Check For Your Holdings on Thu Jan 02, 2014 8:59 am

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
Did some modifications. Download the latest version here.
mediafire.com view/fgyg5p72btdf11s/HealthCheck_4_0_0.xlsm
Added 5 year average dividend in to rating criteria.
This is because current dividend yield was giving unusual results for some counters.

47Health Check For Your Holdings - Page 3 Empty Re: Health Check For Your Holdings on Thu Jan 02, 2014 9:28 am

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
@PROPRITER wrote:I checked with JINS, Dividends data is wrong. it shuold be Rs.1 right?
I also noted the problem. Issue is with financial times DB.
http://markets.ft.com/research/Markets/Tearsheets/Summary?s=JINS.N0000:CSE
Dividend data is not there

48Health Check For Your Holdings - Page 3 Empty Re: Health Check For Your Holdings on Thu Jan 02, 2014 12:37 pm

janakatk

janakatk
Senior Equity Analytic
Senior Equity Analytic
Thanks bro.. really useful, i am rocking...

49Health Check For Your Holdings - Page 3 Empty Re: Health Check For Your Holdings on Fri Jan 03, 2014 10:56 am

PROPRITER

PROPRITER
Equity Analytic
Equity Analytic
@Dileepa wrote:
@PROPRITER wrote:I checked with JINS, Dividends data is wrong. it shuold be Rs.1 right?
I also noted the problem. Issue is with financial times DB.
http://markets.ft.com/research/Markets/Tearsheets/Summary?s=JINS.N0000:CSE
Dividend data is not there

If we substitute the JINS dividend, I believe we can categorize JINS under safe & positive counters.

50Health Check For Your Holdings - Page 3 Empty Re: Health Check For Your Holdings on Sat Feb 08, 2014 10:44 pm

KDDND

KDDND
Assistant Vice President - Equity Analytics
Assistant Vice President - Equity Analytics
Dileepaaaaaaaaaaaaaaaaaaaaaaaaaa.....!!!!
Wowwwww....What maxxaaaa...WORKS!

BRILLIANT.....!!!

You know how I feel.....
I have blindly trade in CSE so far......!!!
So many things to know.....
You make it SIMPLE and QUICK to .....!!!
Hard to believe Still!!
Thank you BIG BROTHER!

51Health Check For Your Holdings - Page 3 Empty Re: Health Check For Your Holdings on Tue Mar 25, 2014 11:26 pm

lux2014

lux2014
Manager - Equity Analytics
Manager - Equity Analytics
Dileepa,

Dear Sir, thanks so much for this tool. I have been trying out your CSE Screener.  Now I'm onto this.
 Very Happy  study 
Thanks again.

52Health Check For Your Holdings - Page 3 Empty Re: Health Check For Your Holdings on Wed Mar 26, 2014 9:39 am

sew


Senior Equity Analytic
Senior Equity Analytic
@Dileepa wrote:Did some modifications. Download the latest version here.
mediafire.com view/fgyg5p72btdf11s/HealthCheck_4_0_0.xlsm
Added 5 year average dividend in to rating criteria.
This is because current dividend yield was giving unusual results for some counters.
This does not work for me,
mediafire.com download/nvv3l9au7w2ri3m/HealthCheck_3_1_0.xlsm

but this does,
mediafire.com download/nvv3l9au7w2ri3m/HealthCheck_3_1_0.xlsm

53Health Check For Your Holdings - Page 3 Empty Re: Health Check For Your Holdings on Sat May 30, 2015 11:31 pm

bullseye

bullseye
Manager - Equity Analytics
Manager - Equity Analytics
i downloaded this, but its not working!!

54Health Check For Your Holdings - Page 3 Empty Re: Health Check For Your Holdings on Fri Oct 02, 2015 2:04 am

bullseye

bullseye
Manager - Equity Analytics
Manager - Equity Analytics
@Dileepa wrote: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 - Page 3 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..
Great work mr.dileepa

i followed macro class but couldnt understand the coding etc...

can you pleas explain for what we can use these data (which are shown in the excel sheet)

for an example, RATING say 45 for company BLI. what does that mean? and also are alll the financial fetched informations upto date??

please explain your KPIs which is mentioned in your exel & also how we can use these data for decision making??

PLEASE EXPLAIN SIR!! EAGERLY WAITING TO LEARN!!

55Health Check For Your Holdings - Page 3 Empty Re: Health Check For Your Holdings on Fri Oct 02, 2015 2:09 am

bullseye

bullseye
Manager - Equity Analytics
Manager - Equity Analytics
@Dileepa wrote: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 - Page 3 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..
Great work mr.dileepa

i followed macro class but couldnt understand the coding etc...

can you pleas explain for what we can use these data (which are shown in the excel sheet)

for an example, RATING say 45 for company BLI. what does that mean? and also are alll the financial fetched informations upto date??

please explain your KPIs which is mentioned in your exel & also how we can use these data for decision making??

PLEASE EXPLAIN SIR!! EAGERLY WAITING TO LEARN!!

56Health Check For Your Holdings - Page 3 Empty Re: Health Check For Your Holdings on Fri Oct 02, 2015 7:41 am

EquityChamp

EquityChamp
Moderator
Moderator
@Dileepa wrote:Did some modifications. Download the latest version here.
mediafire.com view/fgyg5p72btdf11s/HealthCheck_4_0_0.xlsm
Added 5 year average dividend in to rating criteria.
This is because current dividend yield was giving unusual results for some counters.

Hi Dileepa,
At what frequency this sheet get updated. I mean are we need to download it when ever we want to use it or one time download is enough.

On the other hand what is the meaning of 'Rating'. When it is going high what would that mean?

57Health Check For Your Holdings - Page 3 Empty Re: Health Check For Your Holdings on Fri Oct 02, 2015 1:08 pm

bullseye

bullseye
Manager - Equity Analytics
Manager - Equity Analytics
@EquityChamp wrote:
@Dileepa wrote:Did some modifications. Download the latest version here.
mediafire.com view/fgyg5p72btdf11s/HealthCheck_4_0_0.xlsm
Added 5 year average dividend in to rating criteria.
This is because current dividend yield was giving unusual results for some counters.

Hi Dileepa,
At what frequency this sheet get updated. I mean are we need to download it when ever we want to use it or one time download is enough.

On the other hand what is the meaning of 'Rating'. When it is going high what would that mean?
its only one time download & u need internet access to fetch data.

but the data is not exactly accurate but very helpful

58Health Check For Your Holdings - Page 3 Empty Re: Health Check For Your Holdings on Fri Oct 02, 2015 2:27 pm

EquityChamp

EquityChamp
Moderator
Moderator
Seems that new company data such as SFL is not captured here.

59Health Check For Your Holdings - Page 3 Empty Re: Health Check For Your Holdings on Fri Oct 02, 2015 4:32 pm

EquityChamp

EquityChamp
Moderator
Moderator
@EquityChamp wrote:Seems that new company data such as SFL is not captured here.

Any idea.

60Health Check For Your Holdings - Page 3 Empty Re: Health Check For Your Holdings on Fri Oct 02, 2015 6:08 pm

dimuthubasd


Senior Equity Analytic
Senior Equity Analytic
wow nice work. but the rating for poultry trio (bfl/tafl/gran) is  disappointing. we know they will rock in the future. but based on this all are not good. isn't it? . one thing i learn from cse is, its not about value but the investors sentiments is the key. (i have bought some valued fundamantal stocks but the price go down day by day, and i sold all of them and buy poultry trio, i cover my all loss and now in profit zone.

Sponsored content


Back to top  Message [Page 3 of 3]

Go to page : Previous  1, 2, 3

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