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
Market Place

Add an ad

View all ads

Latest topics

» ගෝඨාභය නෙමෙයි පුටින් ආවත් market එක ගොඩ ගන්ඩ බෑ
by Miss-Sangeetha Today at 5:08 pm

» Questionnaire on the stock market investor behavior in the Sri Lankan share market
by gayani2018 Today at 9:41 am

» AEL going up short term for gota coming is only chance for trading
by sanjulanka Today at 7:11 am

» Capital trust recommended to buy AEL ..Target Price Rs.24.50
by Eng Krishantha Today at 1:45 am

» NEST going to run?
by Bakka1988 Yesterday at 11:08 pm

» when you invest in a company call that company and ask some thing
by ThilinaM Yesterday at 3:47 pm

» Chevron will go down further in fundamentals
by ThilinaM Yesterday at 2:06 pm

» read this carefully - thease dumb investment advisors will advise when gsp received teejay operation would be better
by ThilinaM Yesterday at 1:21 pm

» Rocell undervalued
by ThilinaM Yesterday at 12:36 pm

» Friends I read a book traders are loosers
by ThilinaM Yesterday at 12:34 pm

» Central Bank Reduces Its Policy Interest Rates
by Miss-Sangeetha Yesterday at 10:46 am

» Scared of silence of MS and next 2 Fridays
by samaritan Yesterday at 9:11 am

» Positive News
by Capton KIng Cool Yesterday at 8:37 am

» The Central Bank of Sri Lanka Reduces its Policy Interest Rates
by TraderCSE Yesterday at 7:50 am

» AAIC - Profit over one billion!!!!!
by wisdom79 Yesterday at 7:44 am

» Why AAIC Should trade above RS.50/-
by wisdom79 Yesterday at 7:43 am

» CIND බලාගෙනයි
by ThilinaM Thu Aug 22, 2019 3:50 pm

» PAP (Pan Asia Power PLC) Dealings Directors
by Capton KIng Cool Thu Aug 22, 2019 8:54 am

» JKH will touch 175 very soon
by soileconomy Thu Aug 22, 2019 7:27 am

» EMER...?????
by roshan1039 Thu Aug 22, 2019 12:16 am

» What is your trading preference?
by biglivetrade Wed Aug 21, 2019 4:24 pm

» RENUKA HOLDINGS Target 50.00
by ThilinaM Wed Aug 21, 2019 1:34 pm

» CIND , 10% guaranteed return
by Bakka1988 Wed Aug 21, 2019 12:51 pm

» lOFC definitely will hit 6/-
by Winner123 Wed Aug 21, 2019 11:18 am

» ASHO අර්ජුන් මහේන්ද්‍රගේ බෑන විකුණනවද කොහෙද
by Bakka1988 Wed Aug 21, 2019 11:11 am

» PAP (Pan Asia Power PLC) Apointiment of Director Mr.Sangith Senaka Kakiriwargodage.
by samaritan Wed Aug 21, 2019 10:03 am

» SEC charges four stockbrokers over market manipulation
by player Wed Aug 21, 2019 9:40 am

» Sri Lankan Billionaire Dhammika Perera may Spend Rs. 10 Billion for a Presidential Campaign without any Risk! His Daily Casino Profits said to be over Rs. 50 Million
by nuwanmja Wed Aug 21, 2019 9:39 am

» MGT - Collect n keep
by samaritan Wed Aug 21, 2019 8:05 am

» Browns investments
by Winner123 Tue Aug 20, 2019 9:35 pm

» ASHO will hit moon. Deal with SLTB
by Bakka1988 Tue Aug 20, 2019 9:11 pm

» GLASS (piramal glass ceylon plc) from
by MarketWch Tue Aug 20, 2019 10:20 am

» Elcection Commisioner( MACO)
by Capton KIng Cool Tue Aug 20, 2019 8:59 am

» Presidential election will be held on 16 th of November to 7th of December
by rukshan1234 Mon Aug 19, 2019 11:30 pm

» Which Trading System Or Strategy Is The Most Profitable?
by Teller Mon Aug 19, 2019 8:13 pm

» NEST will touch Rs2000 soon
by Bakka1988 Mon Aug 19, 2019 5:41 pm

» Gotabaya Rajapaksha will named after 10th August. Aspi will move above 6500
by samaritan Mon Aug 19, 2019 11:59 am

» CFVF.N0000 - Target price Rs.60- Donnt sell
by Trader321 Mon Aug 19, 2019 10:06 am

» CFVF.N0000 - Really started Again ..........
by Trader321 Mon Aug 19, 2019 9:59 am

» LOLC Holding( LOLC N.0000)
by Capton KIng Cool Mon Aug 19, 2019 8:45 am

» LOLC Holding( LOLC N.0000) MICRO FINACE In Cambodia
by Capton KIng Cool Mon Aug 19, 2019 8:43 am

» PAN ASIA BANK
by samaritan Mon Aug 19, 2019 8:17 am

» CFVF.N0000 - Deal at What price?
by Winner123 Fri Aug 16, 2019 8:35 pm


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

Go down  Message [Page 2 of 2]

1Health Check For Your Holdings - Page 2 Empty Health Check For Your Holdings on Sun Nov 24, 2013 5:00 pm

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
First topic message reminder :

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


41Health Check For Your Holdings - Page 2 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 2 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 2 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 2 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 2 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 2 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 2 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 2 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 2 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 2 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 2 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 2 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 2 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 2 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 2 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 2 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 2 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 2 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 2 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 2 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 2 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 2 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 2 of 2]

Go to page : Previous  1, 2

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