Sri Lanka Equity Forum
Dear Reader,

Registration with the Sri Lanka Equity Forum 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
Sri Lanka Equity Forum

Discussion Forum for Stock Market Investors in Sri Lanka

සිංහල පරිවර්තනය
Contribute
Submit Post

Latest topics

» Santa Claus is coming to Colombo
by God Father Today at 10:58 am

» COLO and DOCK Moving to 100
by Jay-Jay Today at 10:55 am

» Fitch Revises Sri Lanka's Banking Sector Outlook to Stable from Negative
by ipo Today at 10:49 am

» EAST WEST PROPERTIES PLC (EAST.N0000)
by chandike73 Today at 10:09 am

» EASTERN MERCHANTS PLC (EMER.N0000)
by roshan1039 Today at 10:05 am

» Port City opens for investors
by Promoney Today at 9:24 am

» Time to sell
by grape101 Today at 8:13 am

» MILLENNIUM HOUSING DEVELOPERS PLC (MHDL.N0000)
by sanjulanka Today at 7:12 am

» LOLC FINANCE PLC (LOFC.N0000)
by King of vice Today at 7:06 am

» Why technological companies not
by Teller Today at 3:54 am

» CSE RULES (CSE වල දැනට තියන නීති ගැන)
by ColomboCSE Today at 1:32 am

» ASIA ASSET FINANCE PLC (AAF.N0000)
by Teller Today at 1:24 am

» Insurance Sector
by wisdom79 Yesterday at 7:29 pm

» Chairmen of three State Institutions
by roshan1039 Yesterday at 6:37 pm

» Shares to Buy
by kalyana1970 Yesterday at 5:20 pm

» kaufen Deutscher Führerschein ((WhatsApp...+4915210675228)) kaufen Schweizer Führerschein, kaufen Österreich Führerschein
by tonyserge Yesterday at 3:35 pm

» A Must listen Speech ..
by ColomboCSE Yesterday at 1:01 am

» BAIRAHA FARMS PLC (BFL.N0000)
by bhanu Sat Dec 07, 2019 8:35 pm

» World biggest IPO raises $25.6 Billion
by ipo Sat Dec 07, 2019 12:55 pm

» Daily Stock Market Update
by God Father Sat Dec 07, 2019 10:33 am

» Plantation Sector
by Quibit Sat Dec 07, 2019 10:29 am

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

Advertise

You are not connected. Please login or register

Sri Lanka Equity Forum » Stock Market Talk » Expert Chamber » Health Check For Your Holdings

Health Check For Your Holdings

Go to page : Previous  1, 2, 3  Next

Go down  Message [Page 2 of 3]

21Health Check For Your Holdings - Page 2 Empty Re: Health Check For Your Holdings on Tue Nov 26, 2013 5:58 pm

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
@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 ↓
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.

22Health Check For Your Holdings - Page 2 Empty Re: Health Check For Your Holdings on Tue Nov 26, 2013 6:11 pm

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
@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..

23Health Check For Your Holdings - Page 2 Empty Re: Health Check For Your Holdings on Tue Nov 26, 2013 6:25 pm

cseguide


Assistant Vice President - Equity Analytics
Assistant Vice President - Equity Analytics
@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.

24Health Check For Your Holdings - Page 2 Empty Re: Health Check For Your Holdings on Tue Nov 26, 2013 8:41 pm

smallville


Associate Director - Equity Analytics
Associate Director - Equity Analytics
@Dileepa wrote:

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

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

25Health Check For Your Holdings - Page 2 Empty Re: Health Check For Your Holdings on Tue Nov 26, 2013 8:51 pm

kalum


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
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

26Health Check For Your Holdings - Page 2 Empty Re: Health Check For Your Holdings on Tue Nov 26, 2013 8:54 pm

sriranga

sriranga
Co-Admin
Great.Thanks Dileepa, really valuable. Appreciate your commitment and effort.

http://sharemarket-srilanka.blogspot.co.uk/

27Health Check For Your Holdings - Page 2 Empty Re: Health Check For Your Holdings on Tue Nov 26, 2013 9:02 pm

Backstage

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

28Health Check For Your Holdings - Page 2 Empty Re: Health Check For Your Holdings on Wed Nov 27, 2013 11:19 am

kalum


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
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!



29Health Check For Your Holdings - Page 2 Empty Re: Health Check For Your Holdings on Wed Nov 27, 2013 11:29 am

kalum


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
@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

30Health Check For Your Holdings - Page 2 Empty Re: Health Check For Your Holdings on Wed Nov 27, 2013 12:32 pm

K.Haputantri

K.Haputantri
Co-Admin
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

31Health Check For Your Holdings - Page 2 Empty Re: Health Check For Your Holdings on Wed Nov 27, 2013 2:46 pm

chap


Senior Equity Analytic
Senior Equity Analytic
Health Check For Your Holdings - Page 2 Microsoft_Excel_Health_Check_3_0_0_2013_11_27_1

32Health Check For Your Holdings - Page 2 Empty Re: Health Check For Your Holdings on Wed Nov 27, 2013 5:59 pm

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
@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 ↓
mediafire.com download/nvv3l9au7w2ri3m/

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

33Health Check For Your Holdings - Page 2 Empty Re: Health Check For Your Holdings on Wed Nov 27, 2013 6:31 pm

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
@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...

34Health Check For Your Holdings - Page 2 Empty Re: Health Check For Your Holdings on Wed Nov 27, 2013 9:48 pm

nihal123

nihal123
Manager - Equity Analytics
Manager - Equity Analytics
Thanks Dileepa.
It is very  useful.
bounce  bounce  bounce

35Health Check For Your Holdings - Page 2 Empty Re: Health Check For Your Holdings on Wed Nov 27, 2013 11:04 pm

chap


Senior Equity Analytic
Senior Equity Analytic
@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 ↓
mediafire.com download/nvv3l9au7w2ri3m/

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

36Health Check For Your Holdings - Page 2 Empty Re: Health Check For Your Holdings on Thu Nov 28, 2013 8:32 am

gamakak


Stock Analytic
Stock Analytic
thank you

37Health Check For Your Holdings - Page 2 Empty Re: Health Check For Your Holdings on Thu Nov 28, 2013 4:04 pm

Mahawawtta


Manager - Equity Analytics
Manager - Equity Analytics
still i cant use this remarkable:cry:  system.

38Health Check For Your Holdings - Page 2 Empty Re: Health Check For Your Holdings on Fri Nov 29, 2013 8:24 am

nihal123

nihal123
Manager - Equity Analytics
Manager - Equity Analytics
Dileepa
In the counter cell has CIC N. where is CIC X ?
Question 

39Health Check For Your Holdings - Page 2 Empty Re: Health Check For Your Holdings on Sun Dec 01, 2013 1:34 pm

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
>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

40Health Check For Your Holdings - Page 2 Empty Re: Health Check For Your Holdings on Sun Dec 01, 2013 2:14 pm

nihal123

nihal123
Manager - Equity Analytics
Manager - Equity Analytics
Thanks Dileepa.
Very Happy 

41Health Check For Your Holdings - Page 2 Empty Re: Health Check For Your Holdings on Sun Dec 01, 2013 2:42 pm

seek


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
Thanx Dileepa. Waiting for ur Screener as well.

42Health Check For Your Holdings - Page 2 Empty Re: Health Check For Your Holdings on Mon Dec 02, 2013 8:33 pm

nihal123

nihal123
Manager - Equity Analytics
Manager - Equity Analytics
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%

43Health Check For Your Holdings - Page 2 Empty Re: Health Check For Your Holdings on Mon Dec 30, 2013 8:02 am

PROPRITER

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

44Health Check For Your Holdings - Page 2 Empty Re: Health Check For Your Holdings on Mon Dec 30, 2013 8:23 am

smallville

smallville
Associate Director - Equity Analytics
Associate Director - Equity Analytics
@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..

45Health Check For Your Holdings - Page 2 Empty Re: Health Check For Your Holdings on Mon Dec 30, 2013 2:32 pm

K.Haputantri

K.Haputantri
Co-Admin
@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.

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