|
PureBytes Links
Trading Reference Links
|
You're the man Tomasz,
We really do appreciate you addressing our whimpers for providing
these fields as quickly as you have. For now, I don't mind running a
more time intensive screen for stocks as it certainly beats romping
around countless websites to try to get the same stuff.
Russ
--- In amibroker@xxxxxxxxxxxxxxx, "Joe Landry" <jelandry@xxxx> wrote:
> Tomasz - Thanks for all your work. This is amazing almost like instant
> messaging.
>
> Best personal regards
> JOE
> ----- Original Message -----
> From: "Tomasz Janeczko" <amibroker@xxxx>
> 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@xxxx>
> > 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@xxxx>
> >> 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@xxxx>
> >>> 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@xxxx>
> >>>> 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=12hab8tpn/M=362343.6886682.7839641.1493532/D=groups/S=1705632198:TM/Y=YAHOO/EXP=1123010350/A=2894354/R=0/SIG=11qvf79s7/*http://http://www.globalgiving.com/cb/cidi/c_darfur.html";>Help Sudanese refugees rebuild their lives through GlobalGiving</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/
|