|
PureBytes Links
Trading Reference Links
|
Tomasz - Thanks for all your work. This is amazing almost like instant
messaging.
Best personal regards
JOE
----- Original Message -----
From: "Tomasz Janeczko" <amibroker@xxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Tuesday, August 02, 2005 8:26 AM
Subject: Re: [amibroker] New Quotes Plus (QP2.DLL) plugin version 1.5.0
> Hello,
>
> Answering your questions:
>
>> How does the Database purify tool fit in this context? Should I run the
>> tool on my Amibroker database?
> Yes you can run it. Using new plugin (1.5.1) you should not get ANY empty
> symbol
> (provided you created new database and used new "retrieve" function)
>
>> The analyze piece of the purify tool yields quite few candidates with no
>> quotes
>> but I didn't let it run to completion(8 minutes)
> Yes with older plugin this is the case.
>
> In addition to that data purify can detect other data problems such as
> invalid OHLC relationship, possible unadjusted splits, missing quotes (not
> really
> data errors are some symbols may be not trading on given day for some
> reason).
>
>> I know there's a jScript in the files also that will strip out the
>> tickers
>> with no quotes. What about the use of the script?
> It would work but would take a lot of time to run this script over large
> database.
> It is quicker to use new plugin's retrieve.
>
>> Is there a more current version of the script then is in the archive
>> files?
> I don't think so.
>
>> Any unintended consequences of running that script?
> With default settings - no.
>
> Best regards,
> Tomasz Janeczko
> amibroker.com
> ----- Original Message -----
> From: "Joe Landry" <jelandry@xxxxxxxxxxxxx>
> To: <amibroker@xxxxxxxxxxxxxxx>
> Sent: Tuesday, August 02, 2005 3:21 PM
> Subject: Re: [amibroker] New Quotes Plus (QP2.DLL) plugin version 1.5.0
>
>
>> I've always thought there was quite a bit of 'extra' stuff in QPs
>> database
>> and this highlights it.
>>
>> Although this one time effort will mean more work for the QP staff the
>> return will be a better product overall
>> and a companion DB for Amibroker.
>>
>> I've separated mutual funds from stocks and only download an active set
>> of
>> mutual funds, typically around
>> 6000, so my total database is not nearly as large as was mentioned in an
>> earlier post. QP gives you
>> that option if you make up a list of the funds you want downloaded.
>>
>> Maybe support questions but while the QP2 plug in is in our
>> foreground.......would TJ or some comment on this please.
>>
>> How does the Database purify tool fit in this context? Should I run the
>> tool on my Amibroker database? The
>> analyze piece of the purify tool yields quite few candidates with no
>> quotes
>> but I didn't let it run to completion(8 minutes)
>> I know there's a jScript in the files also that will strip out the
>> tickers
>> with no quotes. What about the use of the script?
>> Is there a more current version of the script then is in the archive
>> files?
>> Any unintended consequences of running that script?
>>
>> Best regards
>> JOE
>>
>>
>> ----- Original Message -----
>> From: "Tomasz Janeczko" <amibroker@xxxxxx>
>> To: <amibroker@xxxxxxxxxxxxxxx>
>> Sent: Tuesday, August 02, 2005 7:55 AM
>> Subject: Re: [amibroker] New Quotes Plus (QP2.DLL) plugin version 1.5.0
>>
>>
>>> Hello,
>>>
>>> My all day extensive tests have shown that there is NO RELIABLE WAY
>>> to use QP2 master stock records to find out if given symbol is
>>> 'correct'.
>>>
>>> According to QP2 staff all symbols having issue_status field equal to
>>> '0'
>>> should be correct ones. Gary wrote:
>>> "0 = actively trading
>>> Usually anything with a 0 is good.
>>> Sometimes we get master records for symbols that we do not get data for.
>>> I try to get rid of these about once a week. "
>>>
>>> Unfortunatelly this is not the case. I have counted more than 6000
>>> data records in master table with issue_type equal to 0 (supposed to be
>>> "actively trading")
>>> having NO QUOTES at all.
>>>
>>> Since master table in QP2 proved to be so unreliable, I have no other
>>> way
>>> than to add checking of quotation table for each symbol during symbol
>>> retrieval process
>>> to next version of the plugin.
>>>
>>> This will make retrieval slower but will guarantee that symbols without
>>> quotes won't be retrieved.
>>>
>>> Best regards,
>>> Tomasz Janeczko
>>> amibroker.com
>>> ----- Original Message -----
>>> From: "Bob Jagow" <bjagow@xxxxxxxxxxxxx>
>>> To: <amibroker@xxxxxxxxxxxxxxx>
>>> Sent: Tuesday, August 02, 2005 8:26 AM
>>> Subject: RE: [amibroker] New Quotes Plus (QP2.DLL) plugin version 1.5.0
>>>
>>>
>>>> Tomasz,
>>>> This is a problem that I've commented on several times.
>>>> Try to open your 4 symbols in QP3 and you'll 'see 2 things:
>>>> -you'll always get 'Could not find symbol' popup
>>>> -If you access them via 'Search for Name', the culprits invariably lack
>>>> Sector and Industry assignment.
>>>>
>>>> Because of the inclusion of, for example,
>>>> ABGZ15
>>>> .
>>>> .
>>>> .
>>>> ABGZ81, the # of symbols retrieved totaled 17,365.
>>>>
>>>> I noticed another error which I'd never seen with the previous DLL;
>>>> selecting BF B from all gave 'Not enough data available' But F3 found
>>>> it
>>>> by
>>>> adding the correct # of spaces.
>>>> .
>>>> Regards,
>>>> Bob
>>>>
>>>>
>>>> -----Original Message-----
>>>> From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx]On
>>>> Behalf
>>>> Of Tomasz Janeczko
>>>> Sent: Monday, August 01, 2005 9:24 PM
>>>> To: amibroker@xxxxxxxxxxxxxxx
>>>> Subject: Re: [amibroker] New Quotes Plus (QP2.DLL) plugin version 1.5.0
>>>>
>>>> Hello,
>>>>
>>>> New plugin uses issue_status field of QP2 master records to determine
>>>> whenever
>>>> given symbol is actively traded or not. Problem is that for some
>>>> symbols
>>>> the value of this field is apparently incorrect. Some of problematic
>>>> symbols
>>>> are:
>>>> CATC
>>>> CAUL
>>>> CBAC
>>>> CBAG
>>>>
>>>> I have notified QP2 staff about this problem.
>>>> As soon as I get any reply I will rectify this.
>>>>
>>>> Best regards,
>>>> Tomasz Janeczko
>>>> amibroker.com
>>>> ----- Original Message -----
>>>> From: "Tomasz Janeczko" <amibroker@xxxxxx>
>>>> To: <amibroker@xxxxxxxxxxxxxxx>
>>>> Sent: Monday, August 01, 2005 7:44 PM
>>>> Subject: [amibroker] New Quotes Plus (QP2.DLL) plugin version 1.5.0
>>>>
>>>>
>>>>> Hello,
>>>>>
>>>>> A new version of Quotes Plus plugin (v1.5.0) has been just released.
>>>>> It is available for download from:
>>>>> http://www.amibroker.com/bin/QP2.dll (20KB)
>>>>>
>>>>> After downloading you should copy it to "Plugins" subfolder of
>>>>> AmiBroker
>>>> directory.
>>>>> Make sure that only one copy of QP2.dll is present in that directory,
>>>>> otherwise it won't work (just in case as Windows tends to create "Copy
>>>> of..." files)
>>>>>
>>>>> CHANGES COMPARED TO 1.4.3
>>>>>
>>>>> + Added "Retrieve actively traded symbols only" to the "Configure"
>>>>> dialog
>>>>>
>>>>> when checked (by default) then retrieve gets only issues with
>>>> issue_status = '0' (actively traded). All other issues are
>>>>> skipped.
>>>>> when unchecked all symbols in QP2 database are retrieved (even
>>>> invalid/test ones)
>>>>>
>>>>>
>>>>> + GetExtraData now supports two new historical fundamental data fields
>>>> "Sales" and "EPS"
>>>>>
>>>>> Sales and EPS historical figures are provided by QP2 on quarterly
>>>> basis.
>>>>> Since QP2 reports dates for this data only in YYYYMM format
>>>>> (without
>>>> day),
>>>>> to ensure no future is referenced, AmiBroker returns data for given
>>>> fiscal quarter starting from the first
>>>>> day of NEXT month occurring after Sales/EPS date provided by QP2.
>>>>>
>>>>> Example:
>>>>> Plot(GetExtraData("Sales"), "Sales", colorRed );
>>>>> Plot(GetExtraData("EPS"), "EPS", colorGreen );
>>>>>
>>>>> + "Retrieve" generates more detailed groupings now:
>>>>>
>>>>> index, common stocks, preferred stocks, ADR, warrant or right,
>>>>> mutual
>>>>> or
>>>> investment trust fund,
>>>>> convertible preferred, ETF, Unit - (UIT), certificate, Unit
>>>>>
>>>>>
>>>>> + Undefined industry now appears under Undefined sector instead of
>>>> "Internet"
>>>>>
>>>>>
>>>>> Best regards,
>>>>> Tomasz Janeczko
>>>>> amibroker.com
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> Please note that this group is for discussion between users only.
>>>>>
>>>>> To get support from AmiBroker please send an e-mail directly to
>>>>> SUPPORT {at} amibroker.com
>>>>>
>>>>> For other support material please check also:
>>>>> http://www.amibroker.com/support.html
>>>>>
>>>>>
>>>>> Yahoo! Groups Links
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>>
>>>> Please note that this group is for discussion between users only.
>>>>
>>>> To get support from AmiBroker please send an e-mail directly to
>>>> SUPPORT {at} amibroker.com
>>>>
>>>> For other support material please check also:
>>>> http://www.amibroker.com/support.html
>>>>
>>>>
>>>> Yahoo! Groups Links
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> Please note that this group is for discussion between users only.
>>>>
>>>> To get support from AmiBroker please send an e-mail directly to
>>>> SUPPORT {at} amibroker.com
>>>>
>>>> For other support material please check also:
>>>> http://www.amibroker.com/support.html
>>>>
>>>>
>>>> Yahoo! Groups Links
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>> Please note that this group is for discussion between users only.
>>>
>>> To get support from AmiBroker please send an e-mail directly to
>>> SUPPORT {at} amibroker.com
>>>
>>> For other support material please check also:
>>> http://www.amibroker.com/support.html
>>>
>>>
>>> Yahoo! Groups Links
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>> Please note that this group is for discussion between users only.
>>
>> To get support from AmiBroker please send an e-mail directly to
>> SUPPORT {at} amibroker.com
>>
>> For other support material please check also:
>> http://www.amibroker.com/support.html
>>
>>
>> Yahoo! Groups Links
>>
>>
>>
>>
>>
>>
>>
>
>
>
>
> Please note that this group is for discussion between users only.
>
> To get support from AmiBroker please send an e-mail directly to
> SUPPORT {at} amibroker.com
>
> For other support material please check also:
> http://www.amibroker.com/support.html
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
<font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hvg0j0l/M=362131.6882500.7825259.1493532/D=groups/S=1705632198:TM/Y=YAHOO/EXP=1122997109/A=2889190/R=0/SIG=10r90krvo/*http://www.thebeehive.org
">Put more honey in your pocket. (money matters made easy) Welcome to the Sweet Life - brought to you by One Economy</a>.</font>
--------------------------------------------------------------------~->
Please note that this group is for discussion between users only.
To get support from AmiBroker please send an e-mail directly to
SUPPORT {at} amibroker.com
For other support material please check also:
http://www.amibroker.com/support.html
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/amibroker/
<*> To unsubscribe from this group, send an email to:
amibroker-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|