DFN Data Sniffer

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

kav4

Senior Manager - Equity Analytics

Posts : 369
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
Join date : 2011-02-03

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
Join date : 2011-03-21

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
Join date : 2011-03-21

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
Join date : 2011-02-03

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 : 6260
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 : 5249
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 : 6260
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 : 6260
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 : 6260
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 : 10116
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 : 6260
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