DFN Data Sniffer

Dileepa · 41 Re: DFN Data Sniffer Sun Nov 25, 2012 4:59 pm

Dileepa

Senior Manager - Equity Analytics

Posts : 346
Join date : 2011-03-21

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.

Dileepa · 42 Re: DFN Data Sniffer Sun Nov 25, 2012 6:43 pm

Dileepa

Senior Manager - Equity Analytics

Posts : 346
Join date : 2011-03-21

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.

kav4 · 43 Re: DFN Data Sniffer Sun Nov 25, 2012 7:31 pm

kav4

Senior Manager - Equity Analytics

Posts : 369
Join date : 2011-06-17

F7 says SIGGEN_ERR:6

Dileepa · 44 Re: DFN Data Sniffer Sun Nov 25, 2012 8:14 pm

Dileepa

Senior Manager - Equity Analytics

Posts : 346
Join date : 2011-03-21

kav4 wrote:F7 says SIGGEN_ERR:6

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.

kav4 · 45 Re: DFN Data Sniffer Sun Nov 25, 2012 8:35 pm

kav4

Senior Manager - Equity Analytics

Posts : 369
Join date : 2011-06-17

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

Error codes

F7 SIGGEN_ERR:10
H6 383
H7 ~ H11 Blank

smallville · 46 Re: DFN Data Sniffer Mon Nov 26, 2012 8:39 am

smallville

Associate Director - Equity Analytics

Posts : 4119
Equity Stars : 10087
Reputation : 530
Join date : 2011-02-03
Location : Back on Earth

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

Dileepa · 47 Re: DFN Data Sniffer Mon Nov 26, 2012 8:51 pm

Dileepa

Senior Manager - Equity Analytics

Posts : 346
Equity Stars : 6231
Reputation : 44
Join date : 2011-03-21
Location : Tokyo

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.

Dileepa · 48 Re: DFN Data Sniffer Thu Nov 29, 2012 6:47 pm

Dileepa

Senior Manager - Equity Analytics

Posts : 346
Equity Stars : 6231
Reputation : 44
Join date : 2011-03-21
Location : Tokyo

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

kav4 · 49 Re: DFN Data Sniffer Thu Nov 29, 2012 7:25 pm

kav4

Senior Manager - Equity Analytics

Posts : 369
Equity Stars : 5220
Reputation : 36
Join date : 2011-06-17

I get
Run time error '13'
Type mismatch

Dileepa · 50 Re: DFN Data Sniffer Thu Nov 29, 2012 7:32 pm

Dileepa

Senior Manager - Equity Analytics

Posts : 346
Equity Stars : 6231
Reputation : 44
Join date : 2011-03-21
Location : Tokyo

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.

kav4 · 51 Re: DFN Data Sniffer Thu Nov 29, 2012 9:35 pm

kav4

Senior Manager - Equity Analytics

Posts : 369
Equity Stars : 5220
Reputation : 36
Join date : 2011-06-17

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

smallville · 52 Re: DFN Data Sniffer Fri Nov 30, 2012 10:14 am

smallville

Associate Director - Equity Analytics

Posts : 4119
Equity Stars : 10087
Reputation : 530
Join date : 2011-02-03
Location : Back on Earth

Dileepa,

How abt the date format setting? YYMMDD format..

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

Dileepa · 53 Re: DFN Data Sniffer Fri Nov 30, 2012 11:28 am

Dileepa

Senior Manager - Equity Analytics

Posts : 346
Equity Stars : 6231
Reputation : 44
Join date : 2011-03-21
Location : Tokyo

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?

Dileepa · 54 Re: DFN Data Sniffer Fri Nov 30, 2012 1:52 pm

Dileepa

Senior Manager - Equity Analytics

Posts : 346
Equity Stars : 6231
Reputation : 44
Join date : 2011-03-21
Location : Tokyo

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

smallville · 55 Re: DFN Data Sniffer Fri Nov 30, 2012 6:36 pm

smallville

Associate Director - Equity Analytics

Posts : 4119
Equity Stars : 10087
Reputation : 530
Join date : 2011-02-03
Location : Back on Earth

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.

Dileepa · 56 Re: DFN Data Sniffer Fri Nov 30, 2012 6:51 pm

Dileepa

Senior Manager - Equity Analytics

Posts : 346
Equity Stars : 6231
Reputation : 44
Join date : 2011-03-21
Location : Tokyo

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

kav4 · 57 Re: DFN Data Sniffer Fri Nov 30, 2012 11:37 pm

kav4

Senior Manager - Equity Analytics

Posts : 369
Equity Stars : 5220
Reputation : 36
Join date : 2011-06-17

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

Dileepa · 58 Re: DFN Data Sniffer Sat Dec 01, 2012 4:33 am

Dileepa

Senior Manager - Equity Analytics

Posts : 346
Equity Stars : 6231
Reputation : 44
Join date : 2011-03-21
Location : Tokyo

kav4 wrote:
OK this time it works.
Predict Next Signal still gives error. Is it intentional?
Thanks

Pew

finally!
Yes, prediction is not there yet.

Dileepa · 59 Re: DFN Data Sniffer Sun Feb 03, 2013 8:26 am

Dileepa

Senior Manager - Equity Analytics

Posts : 346
Equity Stars : 6231
Reputation : 44
Join date : 2011-03-21
Location : Tokyo

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

Dileepa · 60 Re: DFN Data Sniffer Sun Mar 17, 2013 10:19 am

Dileepa

Senior Manager - Equity Analytics

Posts : 346
Equity Stars : 6231
Reputation : 44
Join date : 2011-03-21
Location : Tokyo

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

smallville · 61 Re: DFN Data Sniffer Sun Mar 17, 2013 10:29 am

smallville

Associate Director - Equity Analytics

Posts : 4119
Equity Stars : 10087
Reputation : 530
Join date : 2011-02-03
Location : Back on Earth

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

Dileepa · 62 Re: DFN Data Sniffer Sun Apr 07, 2013 5:48 pm

Dileepa

Senior Manager - Equity Analytics

Posts : 346
Equity Stars : 6231
Reputation : 44
Join date : 2011-03-21
Location : Tokyo

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

Name*:
Phone number:
Email address*:
Comments*:
* - required fields	Learn

Name*:
Phone number:
Email address*:
Comments*:
* - required fields	Learn

Latest topics

DFN Data Sniffer

41 Re: DFN Data Sniffer Sun Nov 25, 2012 4:59 pm

Dileepa

42 Re: DFN Data Sniffer Sun Nov 25, 2012 6:43 pm

Dileepa

43 Re: DFN Data Sniffer Sun Nov 25, 2012 7:31 pm

kav4

44 Re: DFN Data Sniffer Sun Nov 25, 2012 8:14 pm

Dileepa

45 Re: DFN Data Sniffer Sun Nov 25, 2012 8:35 pm

kav4

46 Re: DFN Data Sniffer Mon Nov 26, 2012 8:39 am

smallville

47 Re: DFN Data Sniffer Mon Nov 26, 2012 8:51 pm

Dileepa

48 Re: DFN Data Sniffer Thu Nov 29, 2012 6:47 pm

Dileepa

49 Re: DFN Data Sniffer Thu Nov 29, 2012 7:25 pm

kav4

50 Re: DFN Data Sniffer Thu Nov 29, 2012 7:32 pm

Dileepa

51 Re: DFN Data Sniffer Thu Nov 29, 2012 9:35 pm

kav4

52 Re: DFN Data Sniffer Fri Nov 30, 2012 10:14 am

smallville

53 Re: DFN Data Sniffer Fri Nov 30, 2012 11:28 am

Dileepa

54 Re: DFN Data Sniffer Fri Nov 30, 2012 1:52 pm

Dileepa

55 Re: DFN Data Sniffer Fri Nov 30, 2012 6:36 pm

smallville

56 Re: DFN Data Sniffer Fri Nov 30, 2012 6:51 pm

Dileepa

57 Re: DFN Data Sniffer Fri Nov 30, 2012 11:37 pm

kav4

58 Re: DFN Data Sniffer Sat Dec 01, 2012 4:33 am

Dileepa

59 Re: DFN Data Sniffer Sun Feb 03, 2013 8:26 am

Dileepa

60 Re: DFN Data Sniffer Sun Mar 17, 2013 10:19 am

Dileepa

61 Re: DFN Data Sniffer Sun Mar 17, 2013 10:29 am

smallville

62 Re: DFN Data Sniffer Sun Apr 07, 2013 5:48 pm

Dileepa

63 Re: DFN Data Sniffer

Sponsored content

New topics