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

Click Link to get instant AI answers to all business queries.
Click Link to find latest Economic Outlook of Sri Lanka
Click Link to view latest Research and Analysis of the key Sectors and Industries of Sri Lanka
Worried about Paying Taxes? Click Link to find answers to all your Tax related matters
Do you have a legal issues? Find instant answers to all Sri Lanka Legal queries. Click Link
Latest images

Latest topics

» FINANCE AND LEASING SECTOR
by SL-INVESTOR Today at 12:48 am

» HSENID BUSINESS SOLUTIONS PLC (HBS.N0000)
by ErangaDS Wed Jun 19, 2024 9:21 pm

» How will proposed Tax Reforms affect Sri Lankans in 2025
by Quibit Wed Jun 19, 2024 9:27 am

» Alibaba & 23 Thieves
by ChooBoy Wed Jun 19, 2024 12:23 am

» Falsified accounts and financial misrepresentation at Arpico Insurance PLC (AINS)
by ChooBoy Tue Jun 18, 2024 11:31 pm

» Impact of IMF reforms to Sri Lanka Economy
by D.G.Dayaratne Mon Jun 17, 2024 6:36 pm

» Richard Pieris Finance Ltd continue to endanger the Depositors with negative performance
by ddindika Mon Jun 17, 2024 3:17 pm

» Richard Pieris Group: Mismanaged?
by Biggy Sun Jun 16, 2024 10:02 am

» Richard Pieris Exports reports 97% decline in Net Profits
by Biggy Sat Jun 15, 2024 11:26 am

» Do your own Stock Market Research using AI Tools
by Quibit Fri Jun 14, 2024 10:50 am

» What will happen tomorrow?
by cheetah Thu Jun 13, 2024 12:07 pm

» Focus on Government controlled entities
by ErangaDS Mon Jun 10, 2024 4:15 pm

» Colombo Stock Market: Over Valued against USD!
by God Father Mon Jun 03, 2024 3:17 pm

» Financial Woes at Richard Pieris Group
by DeepFreakingValue Sat Jun 01, 2024 11:29 pm

» Report a Tax Evasion and Get Rewarded upto 15%
by God Father Fri May 31, 2024 11:51 am

» LankaGPT Platform Launched in Sri Lanka
by God Father Wed May 29, 2024 11:46 pm

» Sri Lanka’s Popularity Is Surging With Travelers. Here’s Where To Go
by ResearchMan Wed May 29, 2024 1:10 pm

» CDB Non voting
by buddikasmart Wed May 29, 2024 8:03 am

» Will share market be taxed after new Gazette
by D.G.Dayaratne Mon May 27, 2024 2:14 pm

» PEOPLE'S INSURANCE PLC (PINS.N0000)
by Ekanayake90 Mon May 27, 2024 7:29 am

» Seylan Bank did not pay final coupon of expired debentures
by Gaudente Wed May 22, 2024 2:32 pm

» Sri Lanka: Stock Market Fraudsters with Criminal Prosecutions
by agentnrox Wed May 22, 2024 1:50 pm

» Richard Pieris Exports PLC (REXP.N0000) future looks bleak!
by God Father Mon May 20, 2024 10:08 pm

LISTED COMPANIES

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


CONATCT US


Send your suggestions and comments

* - required fields

Read FINANCIAL CHRONICLE™ Disclaimer



EXPERT CHRONICLE™

ECONOMIC CHRONICLE

GROSS DOMESTIC PRODUCT (GDP)



CHRONICLE™ YouTube


You are not connected. Please login or register

Health Check For Your Holdings

Go to page : Previous  1, 2, 3  Next

Go down  Message [Page 2 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 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..

Share this post on: reddit

Post Tue Nov 26, 2013 8:54 pm by sriranga

Great.Thanks Dileepa, really valuable. Appreciate your commitment and effort.

Post Tue Nov 26, 2013 9:02 pm by Backstage

Thanks Dileepa, you, Hunter and Kalum are adding some much needed freshness to the forum. Much appreciated.

Post Wed Nov 27, 2013 11:19 am by kalum

Thanks Dileepa,

This is a brief input of my findings.

I have gone though shares randomly and some of them reflect wrong values.
ex: LMF,KAHA

How ever some shares work perfect.
(based on 2013 audited annual report), Im not sure how to calculate TTM values, but they seems ok when consider the past figures of financial reports.
ex: ALLI,ASIR, etc:

As i have mentioned, it is awesome effort, and i highly appreciate your effort. please keep it up!



Post Wed Nov 27, 2013 11:29 am by kalum

Backstage wrote:Thanks Dileepa, you, Hunter and Kalum are adding some much needed freshness to the forum. Much appreciated.
Thanks Backstage. It's a pleasure if i could help someway to this forum.
But i honestly think my contribution to the forum is less significant compared to the effort of this forums admins and moderators and senior members. Smile

K.Haputantri

Post Wed Nov 27, 2013 12:32 pm by K.Haputantri

Fantastic Dileepa!!!
No more research, no more reading of lengthy financial reports spending valuable hours. ?Will it make us lazy couch potetos. Any way, you are an asset to the forum. Continue the Good work bro. I know you can do much more and we support your yomen service.cheers

avatar

Post Wed Nov 27, 2013 2:46 pm by chap

Health Check For Your Holdings - Page 2 Microsoft_Excel_Health_Check_3_0_0_2013_11_27_1

avatar

Post Wed Nov 27, 2013 5:59 pm by Dileepa

chap wrote:Health Check For Your Holdings - Page 2 Microsoft_Excel_Health_Check_3_0_0_2013_11_27_1
Dileepa wrote:
Download the new version here ↓
http://www.mediafire.com/download/nvv3l9au7w2ri3m/

4. You should enable macros from Trust Center settings for it to work.

avatar

Post Wed Nov 27, 2013 6:31 pm by Dileepa

K.Haputantri wrote:Fantastic Dileepa!!!
No more research, no more reading of lengthy financial reports spending valuable hours. ?
That is exactly what I wanted to do study 
It is very difficult to find valuable counters in CSE.
There is no stock screener in CSE.
A proper screener should be able to filter out any of the following combinations.
Image hosted by servimg.com

Hoping to release a full screener for CSE soon.
There are couple of issues to be sorted out first.

Cheers...

nihal123

Post Wed Nov 27, 2013 9:48 pm by nihal123

Thanks Dileepa.
It is very  useful.
bounce  bounce  bounce

avatar

Post Wed Nov 27, 2013 11:04 pm by chap

Dileepa wrote:
chap wrote:Health Check For Your Holdings - Page 2 Microsoft_Excel_Health_Check_3_0_0_2013_11_27_1
Dileepa wrote:
Download the new version here ↓
http://www.mediafire.com/download/nvv3l9au7w2ri3m/

4. You should enable macros from Trust Center settings for it to work.
Now Working..TFS.Very Happy 

avatar

Post Thu Nov 28, 2013 8:32 am by gamakak

thank you

avatar

Post Thu Nov 28, 2013 4:04 pm by Mahawawtta

still i cant use this remarkable:cry:  system.

nihal123

Post Fri Nov 29, 2013 8:24 am by nihal123

Dileepa
In the counter cell has CIC N. where is CIC X ?
Question 

avatar

Post Sun Dec 01, 2013 1:34 pm by Dileepa

>Mahawawtta
If you could be bit more specific, may be somebody will be able to help you.

>nihal123
Thank you for asking the question. I haven't really thought about it.
Just check the data base. I thought X, R and W are not available.
But that data is actually there.
Will make the necessary modification and post here later.
That will take some time though.
#Bit busy with share screener and some other business plans Smile

nihal123

Post Sun Dec 01, 2013 2:14 pm by nihal123

Thanks Dileepa.
Very Happy 

avatar

Post Sun Dec 01, 2013 2:42 pm by seek

Thanx Dileepa. Waiting for ur Screener as well.

nihal123

Post Mon Dec 02, 2013 8:33 pm by nihal123

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%

PROPRITER

Post Mon Dec 30, 2013 8:02 am by PROPRITER

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

smallville

Post Mon Dec 30, 2013 8:23 am by smallville

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

K.Haputantri

Post Mon Dec 30, 2013 2:32 pm by K.Haputantri

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.

avatar

Post Thu Jan 02, 2014 8:59 am by Dileepa

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.

avatar

Post Thu Jan 02, 2014 9:28 am by Dileepa

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

janakatk

Post Thu Jan 02, 2014 12:37 pm by janakatk

Thanks bro.. really useful, i am rocking...

PROPRITER

Post Fri Jan 03, 2014 10:56 am by PROPRITER

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.

KDDND

Post Sat Feb 08, 2014 10:44 pm by KDDND

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!

lux2014

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.

avatar

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

bullseye

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

i downloaded this, but its not working!!

bullseye

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

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

Post  by Sponsored content

Back to top  Message [Page 2 of 3]

Go to page : Previous  1, 2, 3  Next

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