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.

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


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



Latest topics

» Maldives records over 100,000 tourist arrivals in first 35 days of the year
by target1 Today at 4:36 am

» Many positives for Next week
by madukp Today at 3:22 am

» EXPO EXPO EXPO
by Gowri123 Today at 12:35 am

» GLAS will be winner with Super Gain.
by Eranga87 Yesterday at 9:50 pm

» still I believe this
by 100Bill Yesterday at 9:21 pm

» Kind of behavior traders engage in when they are frustrated and want their money back from the market. Stock market for beginners
by Asoka Samarakone Yesterday at 9:13 pm

» SUNSHINE HOLDINGS PLC (SUN.N0000)
by ErangaDS Yesterday at 8:19 pm

» Investor sentiment - will there ever be a recovery?
by xhunter Yesterday at 7:49 pm

» Let's have a stop-loss strategy to maximize investment returns in stock market
by EquityChamp Yesterday at 7:19 pm

» Daily Foreign Transactions
by Pradeep90 Yesterday at 6:56 pm

» Norway -> biggest shareholder of NDB
by Bakkabwoi Yesterday at 6:42 pm

» DIPD/HAYC/HAYL
by samaritan Yesterday at 5:41 pm

» කොටස් මිල දී ගන්න මෙය හොඳම කාලයයි – රාජ්‍ය අමාත්‍ය කබ්රාල්
by samaritan Yesterday at 5:07 pm

» IS it right time to stick to warren buffett's most famous saying ???
by Mr. X Yesterday at 4:02 pm

» CSE - The World's best performer!
by Vishwanarth Yesterday at 2:42 pm

» Best Broker
by Wickyz Yesterday at 2:32 pm

» Game Changed! SUPER GREEN
by Karthick Yesterday at 12:24 pm

» Blue Diamond
by thavam_Eu Yesterday at 12:07 pm

» GALORE OF GOOD NEWS TO THE CSE
by Bakkabwoi Yesterday at 11:58 am

» TRUE VALUE OF LANKA ALUMINUM INDUSTRY (LALU)
by Trading Jockey Yesterday at 10:26 am

EXPERT CHRONICLE™

ECONOMIC CHRONICLE

GROSS DOMESTIC PRODUCT (GDP)


CHRONICLE™ YouTube

CHRONICLE™ NEWS PRODUCTS

FINANCIAL CHRONICLE™

Views & Reviews, Analysis, Evaluations, Discussions, Gossip and Hot Tips relating to Sri Lankan companies listed on the Colombo Stock Exchange (CSE)
Contribute




DAILY CHRONICLE™

Latest news and articles published in Newspapers, Websites, Blogs and other online news sites relating to business and investments in Sri Lanka
Contribute



ECONOMIC CHRONICLE™

This is a section that provide news, views, analysis, predications relating to Political and Socio-Economic factors and how such activities affect the Stock Market and other economic activity of the Country.

Contribute




EXPERT CHRONICLE™

This is an exclusive section for Expert Articles which will help member to share knowledge through comments and responses of the members. All members are allowed to reply and make comments to these articles.

Contribute


Submit Post


CHRONICLE™ YouTube

Youtube Videos and other visual presentations relating Stock market and other investment advise submitted by members or other contributors.

Contribute


Submit Post


කොළඔ කොටස් වෙළඳපොළේ වංශකථාව
කොළඔ කොටස් වෙළඳපොළේ ලැයිස්තුගත සමාගම් කොටස් ගැන තොරතුරු¸විශ්ලේෂණ¸සාකච්ඡා¸ කටකතා¸රසකතා යන සියල්ල අපේම සිංහලෙන් කතා කළ හැකි ‘කතා මණ්ඩපය’

Contribute

Twitter Feeds
POPULAR COMPANIES
A

ABANS ELECTRICALS PLC

ACCESS ENGINEERING PLC Hot

ACL CABLES PLC

ACL PLASTICS PLC

ACME PRINTING & PACKAGING PLC

AGSTAR PLC

AITKEN SPENCE HOTEL HOLDINGS PLC

AITKEN SPENCE PLC

ANILANA HOTELS AND PROPERTIES PLC

ARPICO INSURANCE PLC

ASIA ASSET FINANCE PLC

ASIA CAPITAL PLC

B

BAIRAHA FARMS PLC

BALANGODA PLANTATIONS PLC

BIMPUTH FINANCE PLC

BLUE DIAMONDS JEWELLERY WORLDWIDE PLC

B P P L HOLDINGS PLC

BROWNS BEACH HOTELS PLC

BROWNS INVESTMENTS PLC

C

CARGO BOAT DEVELOPMENT COMPANY PLC

CENTRAL INDUSTRIES PLC

CEYLON COLD STORES PLC

CEYLON GRAIN ELEVATORS PLC Hot

CEYLON TEA BROKERS PLC

CEYLON TOBACCO COMPANY PLC

CHEVRON LUBRICANTS LANKA PLC

COLOMBO FORT LAND & BUILDING PLC

COMMERCIAL BANK OF CEYLON PLC

CITRUS LEISURE PLC Hot

COMMERCIAL CREDIT AND FINANCE PLC

D

DANKOTUWA PORCELAIN PLC

DFCC BANK PLC

DIALOG AXIATA PLC

DIALOG FINANCE PLC

DIPPED PRODUCTS PLC

DISTILLERIES COMPANY OF SRI LANKA PLC

DUNAMIS CAPITAL PLC

E

EAST WEST PROPERTIES PLC Hot

EASTERN MERCHANTS PLC

EXPOLANKA HOLDINGS PLC

E-CHANNELLING PLC

F

FIRST CAPITAL HOLDINGS PLC

G

GALADARI HOTELS (LANKA) PLC

GUARDIAN CAPITAL PARTNERS PLC

H

HATTON NATIONAL BANK PLC

HAYLEYS PLC

HAYLEYS FABRIC PLC

HAYLEYS FIBRE PLC Hot

HEMAS HOLDINGS PLC

HIKKADUWA BEACH RESORT PLC

HNB ASSURANCE PLC

HVA FOODS PLC

J

JANASHAKTHI INSURANCE COMPANY PLC

JOHN KEELLS HOLDINGS PLC Hot

JOHN KEELLS HOTELS PLC

L

LANKA ASHOK LEYLAND PLC

LANKA IOC PLC

LANKEM CEYLON PLC

LANKEM DEVELOPMENTS PLC

LAUGFS GAS PLC

LAUGFS POWER LIMITED

LOLC FINANCE PLC

LOLC HOLDINGS PLC

LUCKY LANKA MILK PROCESSING COMPANY PLC

M

MELSTACORP PLC

N

NATIONAL DEVELOPMENT BANK PLC

NATION LANKA FINANCE PLC

NESTLE LANKA PLC

O

ORIENT FINANCE PLC

OVERSEAS REALTY (CEYLON) PLC

P

PANASIAN POWER PLC

PEOPLE'S LEASING & FINANCE PLC

PIRAMAL GLASS CEYLON PLC

PRIME FINANCE PLC

R

RAIGAM WAYAMBA SALTERNS PLC

RENUKA AGRI FOODS PLC

RENUKA CAPITAL PLC

RENUKA HOLDINGS PLC

RICHARD PIERIS AND COMPANY PLC

RICHARD PIERIS EXPORTS PLC Hot

ROYAL CERAMICS PLC

S

SAMPATH BANK PLC

SEYLAN BANK PLC

SIERRA CABLES PLC

SINGHE HOSPITALS PLC Hot

SMB LEASING PLC

SOFTLOGIC HOLDINGS PLC

SOFTLOGIC LIFE INSURANCE PLC

SRI LANKA TELECOM PLC

SWISSTEK (CEYLON) PLC Hot

T

TEEJAY LANKA PLC

TESS AGRO PLC

THREE ACRE FARMS PLC

TOKYO CEMENT COMPANY (LANKA) PLC Hot

U

UNION BANK OF COLOMBO PLC

V

VALLIBEL FINANCE PLC

VALLIBEL ONE PLC Hot

VALLIBEL POWER ERATHNA PLC

W

WASKADUWA BEACH RESORT PLC


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 Sun Dec 01, 2013 2:42 pm by seek

Thanx Dileepa. Waiting for ur Screener as well.

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%

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

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

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

Post  by Sponsored content

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