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

» GLAS will be winner with Super Gain.
by Eranga87 Today at 10:58 am

» What will happen tomorrow?
by madukp Today at 10:05 am

» The market is not out to “get” you but is just flowing along, and your position just happens to be carried along with it.
by Asoka Samarakone Yesterday at 9:57 pm

» Daily Foreign Transactions
by Pradeep90 Yesterday at 8:01 pm

» DIPD/HAYC/HAYL
by stocknoob Yesterday at 6:55 pm

» Growing Fear
by Mr. X Yesterday at 4:55 pm

» ???? අප්‍රේල් 16 ???? මේ දින 3 කෙටි සතියත් කොළපාටින් අවසන් වුනා
by Wickyz Yesterday at 12:54 pm

» විජේදාසගේ... voice cut ප්‍රතිඵල
by Mr. X Yesterday at 12:40 pm

» LDEV LDEV LDEV
by Eranga87 Yesterday at 10:27 am

» No trader can flee from making a mistake. It’s just that you need to be careful about not repeating your mistakes.
by Mithooshan Yesterday at 7:42 am

» SWISSTEK (CEYLON) PLC (PARQ.N0000)
by Chithi Mon Apr 19, 2021 7:45 pm

» ROYAL CERAMICS PLC (RCL.N0000)
by Jana Mon Apr 19, 2021 6:14 pm

» US dollar trading lower, euro near new high
by target1 Mon Apr 19, 2021 1:38 pm

» LANKA ALUMINIUM INDUSTRIES PLC (LALU.N0000)
by Equity Win Mon Apr 19, 2021 1:23 pm

» LANKEM DEVELOPMENTS PLC (LDEV.N0000)
by Thushara Ayya Mon Apr 19, 2021 11:59 am

» RAIGAM WAYAMBA SALTERNS PLC (RWSL.N0000)
by Eranga87 Sun Apr 18, 2021 4:12 pm

» CIC HOLDINGS PLC (CIC.N0000)
by abey Sat Apr 17, 2021 9:07 pm

» First capital holdings CFVF.N0000
by invest thinker Sat Apr 17, 2021 4:46 pm

» Lanka Walltile PLC Investment Case
by judecroos Sat Apr 17, 2021 8:55 am

» Which is the best at current market condition ? ( At least 30% within 30 Days)
by judecroos Sat Apr 17, 2021 8:39 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™ » FINANCIAL CHRONICLE™ » DFN Data Sniffer

DFN Data Sniffer

Go to page : Previous  1, 2, 3

Go down  Message [Page 3 of 3]

41DFN Data Sniffer - Page 3 Empty Re: DFN Data Sniffer Sun Nov 25, 2012 4:59 pm

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
@kav4 wrote:Different message this time.

DFN Data Sniffer - Page 3 Untitl11

Nothing in F7
kav4, thank for the feed back.
Give me some time, need to check the error handling process.

42DFN Data Sniffer - Page 3 Empty Re: DFN Data Sniffer Sun Nov 25, 2012 6:43 pm

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
@Dileepa wrote:
@kav4 wrote:Different message this time.
Nothing in F7
kav4, thank for the feed back.
Give me some time, need to check the error handling process.
Download this and give it a try.
http://www.mediafire.com/view/?opbeu4dwnyt60yz
There will be an error code in F7.
Let me know the code so that I can pin point where the error is.

43DFN Data Sniffer - Page 3 Empty Re: DFN Data Sniffer Sun Nov 25, 2012 7:31 pm

kav4


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
F7 says SIGGEN_ERR:6

44DFN Data Sniffer - Page 3 Empty Re: DFN Data Sniffer Sun Nov 25, 2012 8:14 pm

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
@kav4 wrote:F7 says SIGGEN_ERR:6
scratch Sorry I could not figure out what's wrong with that part of the code.
What is the version of excel you are using? I checked with Excel 2007 & VB 6.5.
May be some functions I'm using are not supported study
Give this a try,
http://www.mediafire.com/view/?o5dri0e9x2bxu8l
You will have a error code on F7 & some figures on H6~H11. Let me know those.


45DFN Data Sniffer - Page 3 Empty Re: DFN Data Sniffer Sun Nov 25, 2012 8:35 pm

kav4


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
What I have is Office (Excel) 2010
DFN Data Sniffer - Page 3 Untitl12

Error codes

F7 SIGGEN_ERR:10
H6 383
H7 ~ H11 Blank

46DFN Data Sniffer - Page 3 Empty Re: DFN Data Sniffer Mon Nov 26, 2012 8:39 am

smallville

smallville
Associate Director - Equity Analytics
Associate Director - Equity Analytics
I'm getting the same above error... Dileepa can u also do an excel in the date format I asked if I'm not troubling you.. All the new ones have another date format..

47DFN Data Sniffer - Page 3 Empty Re: DFN Data Sniffer Mon Nov 26, 2012 8:51 pm

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
@smallville wrote:I'm getting the same above error... Dileepa can u also do an excel in the date format I asked if I'm not troubling you.. All the new ones have another date format..
Sorry I could not figure out the error yet. Following is the corresponding code.
It's a simple value assigning.

[792] Worksheets("Main").Cells(6, 8)value = DataRange 'for debug
[793]
[794] StartYear = Left(Cells(2, 1).Value, 4)
[795] EndYear = Left(Cells((DataRange - 1), 1).Value, 4)
[796] StartPrice = Cells(2, 2).Value
[797] EndPrice = Cells((DataRange - 1), 2).Value
[798]
[799] Worksheets("Main").Cells(7, 8)value = StartYear 'for debug
[800] Worksheets("Main").Cells(8, 8)value = EndYear 'for debug
[801] Worksheets("Main").Cells(9, 8)value = StartPrice 'for debug
[802] Worksheets("Main").Cells(10, 8)value = EndPrice 'for debug
Line number 792 gives you "386", that means data is there.
Need a weekend to have a look at this.
In the mean time, give this a try.
http://www.mediafire.com/view/?ht743p3k560e64e
It was programed to delete the sheet in the event of an error.
I deleted that part, so you should see some unfinished work in new sheet.
If data is not fetched properly,
there is a possibility of assigning string value to a integer study

Regarding the formatting issue, I will solve it next time.


48DFN Data Sniffer - Page 3 Empty Re: DFN Data Sniffer Thu Nov 29, 2012 6:47 pm

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
Still no luck with the problem Sad
I disabled all error handling. Please give this a try.
http://www.mediafire.com/view/?ux19kiaoiy8gtto
Just download & click only the "Generate Signal" button.
If every thing goes ok, you should see the result as follows.
DFN Data Sniffer - Page 3 Report10

49DFN Data Sniffer - Page 3 Empty Re: DFN Data Sniffer Thu Nov 29, 2012 7:25 pm

kav4


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
I get
Run time error '13'
Type mismatch

50DFN Data Sniffer - Page 3 Empty Re: DFN Data Sniffer Thu Nov 29, 2012 7:32 pm

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
@kav4 wrote:I get
Run time error '13'
Type mismatch
You may be having several versions of DFN installed.
To check, type "PathDB" in F7 & click on "Fetch Data".
Let me know the values of B13.
Also if you have anything on "AAIC_SigGen" sheet send me a screen shot.

51DFN Data Sniffer - Page 3 Empty Re: DFN Data Sniffer Thu Nov 29, 2012 9:35 pm

kav4


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
Yes I have 2 instances of DFN installed on my PC. That's for Asia Securities & Capital trust

B13 vilue is DirectFN TWS Asia/DirectFN TWS CAPT/


DFN Data Sniffer - Page 3 Sig10

52DFN Data Sniffer - Page 3 Empty Re: DFN Data Sniffer Fri Nov 30, 2012 10:14 am

smallville

smallville
Associate Director - Equity Analytics
Associate Director - Equity Analytics
Dileepa,

How abt the date format setting? YYMMDD format..

i.e. '121130' for '30-11-2012'

53DFN Data Sniffer - Page 3 Empty Re: DFN Data Sniffer Fri Nov 30, 2012 11:28 am

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
@kav4 wrote:Yes I have 2 instances of DFN installed on my PC. That's for Asia Securities & Capital trust

B13 vilue is DirectFN TWS Asia/DirectFN TWS CAPT/
Hope you still have H6~H11 values as follows,

H6 383
H7 ~ H11 Blank
If yes, please check the values in row 383 of AAIC_SigGen sheet for any abnormalities.
Actually H6 should show 1657 which is the total number of records.
May be there are some discontinuation of data feed.
For DirectFN TWS Asia, there should be no problem. I think the problem is with CAPT?

54DFN Data Sniffer - Page 3 Empty Re: DFN Data Sniffer Fri Nov 30, 2012 1:52 pm

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
@smallville wrote:Dileepa,

How abt the date format setting? YYMMDD format..

i.e. '121130' for '30-11-2012'
small,

That debug code to fetch every thing at once still works.
I think that data format is in your preferred style.
For 1 counter only, I thought of keeping this format as it is more readable.
Anyway it can be easily changed if you want form excel settings.

Regarding the specific period thing, still working on it.
Have some performance issues to solve.

Cheers..

55DFN Data Sniffer - Page 3 Empty Re: DFN Data Sniffer Fri Nov 30, 2012 6:36 pm

smallville

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

How abt the date format setting? YYMMDD format..

i.e. '121130' for '30-11-2012'
small,

That debug code to fetch every thing at once still works.
I think that data format is in your preferred style.
For 1 counter only, I thought of keeping this format as it is more readable.
Anyway it can be easily changed if you want form excel settings.

Regarding the specific period thing, still working on it.
Have some performance issues to solve.

Cheers..


Thanks.. I need the ASI in that format.. Appreciate if u can let me know a formula to convert to the format I require.

56DFN Data Sniffer - Page 3 Empty Re: DFN Data Sniffer Fri Nov 30, 2012 6:51 pm

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
@smallville wrote:
Thanks.. I need the ASI in that format.. Appreciate if u can let me know a formula to convert to the format I require.
Made the adjustment. Give this a try.
http://www.mediafire.com/view/?v3el3a6na815olo

57DFN Data Sniffer - Page 3 Empty Re: DFN Data Sniffer Fri Nov 30, 2012 11:37 pm

kav4


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
@Dileepa wrote:
@smallville wrote:
Thanks.. I need the ASI in that format.. Appreciate if u can let me know a formula to convert to the format I require.
Made the adjustment. Give this a try.
http://www.mediafire.com/view/?v3el3a6na815olo

OK this time it works.

Predict Next Signal still gives error. Is it intentional?

Thanks

58DFN Data Sniffer - Page 3 Empty Re: DFN Data Sniffer Sat Dec 01, 2012 4:33 am

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
@kav4 wrote:
OK this time it works.
Predict Next Signal still gives error. Is it intentional?
Thanks
Pew cheers finally!
Yes, prediction is not there yet.

59DFN Data Sniffer - Page 3 Empty Re: DFN Data Sniffer Sun Feb 03, 2013 8:26 am

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
@smallville wrote:
Also is there a way that we can get data for all counters on a particular date into one sheet. Currently all are fetched to multiple sheet ne... So I dont have to rely only on CSV data each day. But vols mush be correct too. Wink

thanks 4 ur support.
small.
Solved the above issue. Give this a try.
http://www.mediafire.com/view/?ylnsvab63f6resn

60DFN Data Sniffer - Page 3 Empty Re: DFN Data Sniffer Sun Mar 17, 2013 10:19 am

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
@smallville wrote:
@kav4 wrote:Thanks for your effort & work.

How to get the data for .x0000 shares? (Ex. - SEMB.X0000)

Further more; need data on warrants as well. couldn't find REEF.W19 for an instance..
Added Warrants, Rights & X0000 support.
------------------------------------------------
④How to Fetch Warrants & Rights Data?
⇒Although they are not in the drop down list, you can manually enter the code
 Eg: AAIC.R0000/CLPL.W0012 is not in the drop down list,
but you can enter it manually in C5 and fetch data as usual.
------------------------------------------------
Download the updated version here↓
http://www.mediafire.com/view/?4aiacxsws2v9723

61DFN Data Sniffer - Page 3 Empty Re: DFN Data Sniffer Sun Mar 17, 2013 10:29 am

smallville

smallville
Associate Director - Equity Analytics
Associate Director - Equity Analytics
@Dileepa wrote:
@smallville wrote:
@kav4 wrote:Thanks for your effort & work.

How to get the data for .x0000 shares? (Ex. - SEMB.X0000)

Further more; need data on warrants as well. couldn't find REEF.W19 for an instance..
Added Warrants, Rights & X0000 support.
------------------------------------------------
④How to Fetch Warrants & Rights Data?
⇒Although they are not in the drop down list, you can manually enter the code
 Eg: AAIC.R0000/CLPL.W0012 is not in the drop down list,
but you can enter it manually in C5 and fetch data as usual.
------------------------------------------------
Download the updated version here↓
http://www.mediafire.com/view/?4aiacxsws2v9723


Gratitude... Its working. Thanks Smile

62DFN Data Sniffer - Page 3 Empty Re: DFN Data Sniffer Sun Apr 07, 2013 5:48 pm

Dileepa


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
There was a bug when fetching data by "Date" function.
Please download the fixed version here.
http://www.mediafire.com/view/?dgaa01v6dnt3dte
#Thanks for pointing out -> small

Also there is a problem with ASI volume data.
ASI volume feed stopped after Feb.2012.
#Red circle on attached image.
I believe there is a problem with CSE data feed(not DFN)
Does anybody have an idea about this?
I use AsiaSec by the way.
DFN Data Sniffer - Page 3 Asi_vo10

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