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



Poll

Can there be another Covid-19 wave in Sri Lanka?

Health Check For Your Holdings - Page 2 Vote_lcap68%Health Check For Your Holdings - Page 2 Vote_rcap 68% [ 178 ]
Health Check For Your Holdings - Page 2 Vote_lcap18%Health Check For Your Holdings - Page 2 Vote_rcap 18% [ 47 ]
Health Check For Your Holdings - Page 2 Vote_lcap13%Health Check For Your Holdings - Page 2 Vote_rcap 13% [ 35 ]

Total Votes : 260

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


CONATCT US


Send your suggestions and comments

* - required fields

Read FINANCIAL CHRONICLE™ Disclaimer



Latest topics

» RENUKA AGRI FOODS PLC (RAL.N0000)
by soileconomy Today at 2:56 am

» CLC placed on a Slingshot . . . !!!
by cseguide Yesterday at 11:30 pm

» SUNSHINE HOLDINGS PLC (SUN.N0000)
by LHW Yesterday at 10:35 pm

» WATAWALA PLANTATION PLC (WATA.N0000)
by Niwa Yesterday at 10:22 pm

» ELPL-WATA-UDPL
by Niwa Yesterday at 10:14 pm

» Dusit Thani Sri Lanka project halted?
by js71 Yesterday at 8:48 pm

» BOGALA GRAPHITE LANKA PLC
by cheetah Yesterday at 8:19 pm

» WATA good times are ahead
by cseguide Yesterday at 8:16 pm

» EXPOLANKA HOLDINGS PLC (EXPO.N0000)
by jaya Yesterday at 6:50 pm

» EXPO/BILL/LOLC
by SAGA Yesterday at 6:35 pm

» The fate of NIFL .. CLC .. LOFC under LOCH
by Shivanthini Yesterday at 3:57 pm

» CLC - Bull & Bear LOCKED HORNS - can blast at any time.
by Shivanthini Yesterday at 3:55 pm

» CFLB hidden gem
by skyfall Yesterday at 2:13 pm

» LLUB Dividend
by rajithasahan Yesterday at 1:49 pm

» GLAS will be winner with Super Gain.
by invest thinker Yesterday at 11:36 am

» Next Bull - ELPL/Elpitiya Plantation
by Tissa Yesterday at 6:31 am

» PEOPLE'S INSURANCE PLC (PINS.N0000)
by Ekanayake90 Sun Oct 24, 2021 9:52 pm

» What happen to Dhammika Perera
by Basu Sun Oct 24, 2021 8:48 pm

» AEL becomes the major producer & supplier of asphalt concrete in Sri Lanka
by samaritan Sun Oct 24, 2021 3:44 pm

» KOTAGALA PLANTATION PLC (KOTA.N0000)
by Tissa Sun Oct 24, 2021 11:38 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 : 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: redditgoogle

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.

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

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.

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

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!

Post  by Sponsored content

Back to top  Message [Page 2 of 3]

Go to page : 1, 2, 3  Next

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