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

» Maharaja Foods PLC (MFL) ready for the Fall!
by ChooBoy Today at 12:27 am

» කොළඹ කොටස් වෙළඳපොල විශ්ලේෂණය - 2024
by ChooBoy Fri Jul 19, 2024 11:53 am

» Winds of Change: Sri Lanka's Banking Crisis is Stalling Renewable Energy Ambitions of Local Stalwarts of Wind & Solar Power
by God Father Wed Jul 17, 2024 10:11 pm

» Banking Sector Analysis
by God Father Sat Jul 13, 2024 7:57 am

» Impact of Elections on Colombo Stock Market Sentiment
by Quibit Tue Jul 09, 2024 9:01 am

» LankaBIZ Unveils AI-Driven On-Demand Financial Research and Analysis Service
by Quibit Thu Jul 04, 2024 12:49 pm

» CDB Non voting
by Nandun Sun Jun 30, 2024 9:45 pm

» The Parsi Power Play: How a Small Community of Iranian Parsis are Controling Sri Lanka's US $ 85 billion Economy & 22 Million Population & Politics driving away FDIs
by MalakaDesmond Sun Jun 30, 2024 10:19 am

» Richard Pieris Group: Mismanaged?
by Walbaba Sat Jun 29, 2024 7:04 pm

» සොෆ්ට්ලොජික් හෝල්ඩිංග්ස් පීඑල්සී: අඳුරු අපේක්ෂාවන් සහිත ඉහළ අවදානම් ආයෝජනයක්
by D.G.Dayaratne Tue Jun 25, 2024 5:45 am

» සොෆ්ට්ලොජික් ප්‍රාග්ධනයට වන්දි ගෙවන Share BuyBack නිසා Softlogic ජීවිත රක්‍ෂණය බංකොලොත් වීමේ අවදානමක
by MalakaDesmond Tue Jun 25, 2024 1:49 am

» Softlogic Life insurance face Danger of Bankruptcy due to Share BuyBack that compensate Softlogic Capital
by MalakaDesmond Tue Jun 25, 2024 1:33 am

» Softlogic Holdings PLC: A High-Risk Investment with Bleak Prospects
by MalakaDesmond Tue Jun 25, 2024 12:52 am

» FINANCE AND LEASING SECTOR
by SL-INVESTOR Sat Jun 22, 2024 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

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

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 : 1, 2, 3  Next

Go down  Message [Page 1 of 3]

Dileepa

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

Kithsiri

Post Sun Nov 24, 2013 5:12 pm by Kithsiri

Thanks.
Let me know how to fetch the financials ?

Jiggysaurus

Post Sun Nov 24, 2013 5:16 pm by Jiggysaurus

Your spreadsheet gives a ranking of 36 for JKH, it may be that your ranking parameters are giving undue weightage to dividend yield. It may be better to give the user the option to change the ranking parameters.

avatar

Post Sun Nov 24, 2013 5:33 pm by Dileepa

>Kithsiri, Just click on "Fetch Financials" button.

>Jiggysaurus,
Yes, that is due to poor dividend yield, growth rate and ROE.
I use this to find absolute safe counters.
JKH rated below 40 does not mean it is a bad investment.
(But that tiny margins and returns are a concern to me)

avatar

Post Sun Nov 24, 2013 6:04 pm by kalum

Thanks Dileepa. I found this very much useful. Thank you.

I have few questions tough.

ex:
when i tired to analyze KAHA, it gave me rank 0. EPS /Book value and figures are wrong.

As Jiggysaurus suggested, can you please release another version where we can input some values and thresholds?

Health Check For Your Holdings Kaha11

Appreciate your effort and please keep it up. Smile

avatar

Post Sun Nov 24, 2013 6:42 pm by Dileepa

Thank you for pointing out,
As you said Book value per share, Current ratio, Quick ratio, etc are wrong
It seems like FT data order is different for non dividend paying counters.
Will correct that next time.

Any way EPS(-0.5106 LKR ) is correct as per FT.
What is the EPS as per financial reports?
If this is wrong, need to write to FT scratch 

kalum wrote:
when i tired to analyze KAHA, it gave me rank 0. EPS /Book value and figures are wrong.

As Jiggysaurus suggested, can you please release another version where we can input some values and thresholds?

avatar

Post Sun Nov 24, 2013 8:10 pm by kalum

Thanks Dileepa.
As per the last quarter report the month ended 30th sep. KAHA
http://www.cse.lk/cmt/upload_report_file/710_1384429899438.pdf

EPS is 0.22

09 months ended - 0.24

I''m not sure if this report considering annualized value?

Sorry i didn't get what is mean by TTM.

BTW, this sort of tools that we needed. I wish you could improve this and share with us soon. This will be very much beneficial for us.Keep it up.

K.Haputantri

Post Sun Nov 24, 2013 8:30 pm by K.Haputantri

Thanks Dileepa, but unable to down load. I get "author version" without some cells shown in the post.

avatar

Post Sun Nov 24, 2013 9:31 pm by worthiness

@Dileepa.
It seems that the application is not workable in Windows 8 operating system. Please advise.

prasadrmb

Post Mon Nov 25, 2013 11:12 am by prasadrmb

Thanks Deleep, Valuable one.

avatar

Post Mon Nov 25, 2013 11:40 am by micomgi

Thank you very much Deleep. Could you please provide the password for source code, I like to change little.

avatar

Post Mon Nov 25, 2013 4:01 pm by maurya

it does not working in my lap?? any specific system requirements??

avatar

Post Tue Nov 26, 2013 2:43 am by Dileepa

kalum wrote:Thanks Dileepa.
As per the last quarter report the month ended 30th sep. KAHA
http://www.cse.lk/cmt/upload_report_file/710_1384429899438.pdf

EPS is 0.22

09 months ended - 0.24

I''m not sure if this report considering annualized value?

Sorry i didn't get what is mean by TTM.

BTW, this sort of tools that we needed. I wish you could improve this and share with us soon. This will be very much beneficial for us.Keep it up.
TTM means Trailing Twelve Months.
Will do the necessary update asap.
Regards

avatar

Post Tue Nov 26, 2013 2:53 am by Dileepa

Those who had problems,

There are some data connection problems.
Will sort that out asap and post here a new update.

Cheers..

smallville

Post Tue Nov 26, 2013 6:11 am by smallville

Dileepa wrote:>Kithsiri, Just click on "Fetch Financials" button.

>Jiggysaurus,
Yes, that is due to poor dividend yield, growth rate and ROE.
I use this to find absolute safe counters.
JKH rated below 40 does not mean it is a bad investment.
(But that tiny margins and returns are a concern to me)
Jiggy,

With JKH we always will have to make judgement calls. Automated tools and even sometimes ctock charts cannot be taken as guidence too..

Deleepa,

Your tremendous efforts in developing these kinda timely inventions need applause.. Thanks for the valueable tool. I found few issues with some counters, as Kalum pointed out KAHA was one and few others also missing data. At the time of writing I did not have time to analyse and tell u all this, but its good to have a look.

Also, counters like JKH - Can you modify it to add a % or a value for 'future prospects' so that we can give a certain amount of value that we think appropriate for its press releases. Like JKH casino project, how it will add revenue to them and the impact it can have for their hotels.
This is kind of a 'mind value' but I donno whether this is possible. Cool 

avatar

Post Tue Nov 26, 2013 5:58 pm by Dileepa

Dileepa wrote:Those who had problems,
There are some data connection problems.
Will sort that out asap and post here a new update.
Cheers..
Fixed the above issue.
Now this should work with any counter, hopefully with accurate data.
Download the new version here ↓
http://www.mediafire.com/download/nvv3l9au7w2ri3m/

1. If you can't download, Try Firefox or Chrome browser.
2. This is a macro enabled work book. Once you download check the extension.
   It should be ".xlsm"
3. Don't use "Open with" option, Download first and then double click to open.
4. You should enable macros from Trust Center settings for it to work.
Image hosted by servimg.com

5. This need data connectivity to work. Enable data connections from Trust Center
Image hosted by servimg.com

Let me know if receive any error messages or inaccurate data.

avatar

Post Tue Nov 26, 2013 6:11 pm by Dileepa

smallville wrote:

Your tremendous efforts in developing these kinda timely inventions need applause.. Thanks for the valueable tool. I found few issues with some counters, as Kalum pointed out KAHA was one and few others also missing data. At the time of writing I did not have time to analyse and tell u all this, but its good to have a look.

Also, counters like JKH - Can you modify it to add a % or a value for 'future prospects' so that we can give a certain amount of value that we think appropriate for its press releases. Like JKH casino project, how it will add revenue to them and the impact it can have for their hotels.
This is kind of a 'mind value' but I donno whether this is possible. Cool 
small,

Thanks for the feed back. I think data issue is almost fixed now.
Will think about the future prospects issue.
Currently I'm thinking about a statistical method analyses the entire market at once.

Cheers..

cseguide

Post Tue Nov 26, 2013 6:25 pm by cseguide

Dileepa wrote:
smallville wrote:

Your tremendous efforts in developing these kinda timely inventions need applause.. Thanks for the valueable tool. I found few issues with some counters, as Kalum pointed out KAHA was one and few others also missing data. At the time of writing I did not have time to analyse and tell u all this, but its good to have a look.

Also, counters like JKH - Can you modify it to add a % or a value for 'future prospects' so that we can give a certain amount of value that we think appropriate for its press releases. Like JKH casino project, how it will add revenue to them and the impact it can have for their hotels.
This is kind of a 'mind value' but I donno whether this is possible. Cool 
small,

Thanks for the feed back. I think data issue is almost fixed now.
Will think about the future prospects issue.
Currently I'm thinking about a statistical method analyses the entire market at once.

Cheers..
Thanks Dileepa and keep it up and best wishes for developing a statistical method analyses that you hope to do.

smallville

Post Tue Nov 26, 2013 8:41 pm by smallville

Dileepa wrote:

Currently I'm thinking about a statistical method analyses the entire market at once.

Cheers..
Fantastic news mate.. Keep it up Wink

avatar

Post Tue Nov 26, 2013 8:51 pm by kalum

Thanks Dileepa. I will download this now and come back to you with feedback. As small has mentioned this type of commitment need to be appreciate and it is very much valuable for us. I wish you happy trade. keep it up. Smile

sriranga

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

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

Backstage

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.

avatar

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!



avatar

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

Post  by Sponsored content

Back to top  Message [Page 1 of 3]

Go to page : 1, 2, 3  Next

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