FINANCIAL CHRONICLE™
Dear Reader,

Registration with the Sri Lanka FINANCIAL CHRONICLE™️ 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
FINANCIAL CHRONICLE™️
www.srilankachronicle.com


Join the forum, it's quick and easy

FINANCIAL CHRONICLE™
Dear Reader,

Registration with the Sri Lanka FINANCIAL CHRONICLE™️ 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
FINANCIAL CHRONICLE™️
www.srilankachronicle.com
FINANCIAL CHRONICLE™
Would you like to react to this message? Create an account in a few clicks or log in to continue.
FINANCIAL CHRONICLE™

Encyclopedia of Latest news, reviews, discussions and analysis of stock market and investment opportunities in Sri Lanka

LISTED COMPANIES

Submit Post


ADVERTISE
Poll

EXCHANGE RATE PREDICTION: 2022

Health Check For Your Holdings - Page 3 Vote_lcap11%Health Check For Your Holdings - Page 3 Vote_rcap 11% [ 21 ]
Health Check For Your Holdings - Page 3 Vote_lcap20%Health Check For Your Holdings - Page 3 Vote_rcap 20% [ 37 ]
Health Check For Your Holdings - Page 3 Vote_lcap28%Health Check For Your Holdings - Page 3 Vote_rcap 28% [ 52 ]
Health Check For Your Holdings - Page 3 Vote_lcap40%Health Check For Your Holdings - Page 3 Vote_rcap 40% [ 74 ]

Total Votes : 184

ශ්‍රී ලංකා මූල්‍ය වංශකථාව - සිංහල
Submit Post


CONATCT US


Send your suggestions and comments

* - required fields

Read FINANCIAL CHRONICLE™ Disclaimer



Latest topics

» SGH buys EXPO from retailers
by blindhog Today at 11:04 pm

» LOLC FINANCE PLC (LOFC.N0000)
by Surajmp Today at 8:44 pm

» L G I L - Maharaja special
by Chula Today at 8:13 pm

» HAYLEYS PLC (HAYL.N0000)
by cseboss Today at 11:34 am

» NO FURTHER INCREASE IN TAXES-PRES. RANIL WICKRAMASINGHE
by ADVENTUS Yesterday at 3:48 pm

» AAIC 100 = SCAP 16
by Equity Win Yesterday at 2:11 pm

» CARGO BOAT DEVELOPMENT COMPANY PLC (CABO.N0000)
by Dasun Maduwantha Yesterday at 12:10 pm

» Nestle‚ declares highest ever dividend
by Shiranli Yesterday at 11:24 am

» PRIME LANDS RESIDENCIES PLC (PLR.N0000)
by Anushka Perz Yesterday at 11:15 am

» Buy lofc tomorrow - Maharaja
by Maharaja Yesterday at 9:47 am

» MULTI FINANCE PLC (MFL.N0000)
by Eleven Mon Aug 08, 2022 9:28 pm

» AGSTAR PLC (AGST.N0000)
by Thushara Ayya Mon Aug 08, 2022 4:18 pm

» ACL; MELS; HHL; BIL; LWL- STOCKS TO WATCH
by ADVENTUS Mon Aug 08, 2022 1:43 pm

» LIOC ....Get in soon
by samaritan Mon Aug 08, 2022 11:49 am

» Sinopec likely to enter Lankan fuel market
by samaritan Mon Aug 08, 2022 9:41 am

» RW - Rescue Warrior of Sri Lanka's Economy
by reyaz Mon Aug 08, 2022 8:17 am

» Should Central bank increase Interest rates?
by reyaz Mon Aug 08, 2022 7:52 am

» LPRT and CHOT old and profitable businesses, yet severely undervalued
by sheildskye Sun Aug 07, 2022 12:05 pm

» Day Trader may find a stock attractive if it moves a lot during the day. Stock market for beginners and day traders
by Asoka Samarakone Sat Aug 06, 2022 11:54 am

» Foundation laid for Nestlé Lanka’s Rs.5bn factory expansion
by nilantha suranga Sat Aug 06, 2022 1:57 am

EXPERT CHRONICLE™

MARKET CHAT


CHRONICLE™ ANALYTICS


ECONOMIC CHRONICLE

GROSS DOMESTIC PRODUCT (GDP)


CHRONICLE™ YouTube

LATEST TWEETS

You are not connected. Please login or register

FINANCIAL CHRONICLE™ » EXPERT CHRONICLE™ » Health Check For Your Holdings

Health Check For Your Holdings

Go to page : Previous  1, 2, 3

Go down  Message [Page 3 of 3]

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics

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

Share this post on: redditgoogle

Post Tue Mar 25, 2014 11:26 pm by lux2014

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.

Post Wed Mar 26, 2014 9:39 am by sew

Dileepa wrote:Did some modifications. Download the latest version here.
http://www.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,
http://www.mediafire.com/download/nvv3l9au7w2ri3m/HealthCheck_3_1_0.xlsm

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

Post Sat May 30, 2015 11:31 pm by bullseye

i downloaded this, but its not working!!

Post Fri Oct 02, 2015 2:04 am by bullseye

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

bullseye

Post Fri Oct 02, 2015 2:09 am by bullseye

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

EquityChamp

Post Fri Oct 02, 2015 7:41 am by EquityChamp

Dileepa wrote:Did some modifications. Download the latest version here.
http://www.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?

bullseye

Post Fri Oct 02, 2015 1:08 pm by bullseye

EquityChamp wrote:
Dileepa wrote:Did some modifications. Download the latest version here.
http://www.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

EquityChamp

Post Fri Oct 02, 2015 2:27 pm by EquityChamp

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

EquityChamp

Post Fri Oct 02, 2015 4:32 pm by EquityChamp

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

Any idea.

avatar

Post Fri Oct 02, 2015 6:08 pm by dimuthubasd

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.

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