|
PureBytes Links
Trading Reference Links
|
Hi Greg,
I'm afraid this is beyond my ability : - ) TJ has made it very easy to
make minor changes by putting 4 or 5 variables at the top of the script that
you can set to True/False, # of days in lookback period, etc. You can open
the script in Notepad/Wordpad to see the variables or change them. That is
all I have done.
Re stocks that change name/ticker, I have only used AB with QP2 and TC2K
data, and if you use one of these it is very easy to deal with (can't speak
for Yahoo). Once a week, I just go to File > Database Settings > Configure
and click Retrieve. The plugin will scan the QP2 or TC2K database and
automatically update the AB database with any new issues, ( including
complete history under prior name, assuming the vendor has provided it).
This just takes a few seconds. It doesn't get rid of the old tickers
however, which are no longer being updated, so every couple of months I use
the cleanup script to get rid of any obsolete tickers.
Steve
----- Original Message -----
From: "Greg" <gphanson2@xxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Saturday, November 20, 2004 11:31 AM
Subject: [amibroker] Re: Cleanup database
>
>
> Good Day,
> I've been thinking about this for some time now and i guess this is
> the time to bring it up. Could someone add to the cleanup script the
> ability to have the script call the none traded stock to the screen
> as well. I would then have the internet profile running. Yahoo could
> then verify the dead stock status and if the stock has been given an
> new symbol. Many time i have gone over the deleted stock list and
> have found the stocks are still valid only that they have gained a
> new sysmbol.
>
> Greg
> --- In amibroker@xxxxxxxxxxxxxxx, "Steve Dugas" <sjdugas@xxxx> wrote:
>> Hi Jeff,
>>
>> I posted a version a while back that I modified. It finds issues
> that
>> haven't traded in 5 days and, instead of asking after each one, it
> just
>> collects them all and at the end, tells you haw many it found and
> asks if
>> you want to delete them. You can find it on the files section of
> the
>> Amibroker-AFL group in the folder "Steve Dugas".
>>
>> Steve
>>
>> ----- Original Message -----
>> From: "jgholson" <jgholson@xxxx>
>> To: <amibroker@xxxxxxxxxxxxxxx>
>> Sent: Saturday, November 20, 2004 5:45 AM
>> Subject: [amibroker] Re: Cleanup database
>>
>>
>> >
>> >
>> > Is there a way to modify the script to automatically delect old
>> > symbols with out user input?
>> >
>> > Thanks
>> > Jeff
>> >
>> > --- In amibroker@xxxxxxxxxxxxxxx, "Tomasz Janeczko"
> <amibroker@xxxx>
>> > wrote:
>> >> No it does NOT connect to internet at all. It just checks your
>> > local database
>> >> The script is described in the newsletter:
>> >>
>> >> http://www.amibroker.com/newsletter/05-2000.html
>> >>
>> >>
>> >> Best regards,
>> >> Tomasz Janeczko
>> >> amibroker.com
>> >> ----- Original Message -----
>> >> From: "Dimension" <dimension@xxxx>
>> >> To: <amibroker@xxxxxxxxxxxxxxx>
>> >> Sent: Saturday, November 20, 2004 6:57 AM
>> >> Subject: RE: [amibroker] Cleanup database
>> >>
>> >>
>> >> >
>> >> > Btw, do you know how cleanup works? For Yahoo EOD data, does it
>> > query yahoo
>> >> > to determine if the symbols exist?
>> >> >
>> >> > -----Original Message-----
>> >> > From: Dimension [mailto:dimension@x...]
>> >> > Sent: Friday, November 19, 2004 11:53 PM
>> >> > To: amibroker@xxxxxxxxxxxxxxx
>> >> > Subject: RE: [amibroker] Cleanup database
>> >> >
>> >> >
>> >> > Ah..thank you much
>> >> >
>> >> > -----Original Message-----
>> >> > From: Geo Singleman [mailto:geosing@x...]
>> >> > Sent: Friday, November 19, 2004 11:49 PM
>> >> > To: amibroker@xxxxxxxxxxxxxxx
>> >> > Subject: Re: [amibroker] Cleanup database
>> >> >
>> >> >
>> >> > These are the parameters in cleanup.js (in scripts folder)
> which
>> > control the
>> >> > behavior.
>> >> >
>> >> > /* detection threshold (in days) */
>> >> > var Threshold = 30; // one month for example
>> >> > /* by default do not delete */
>> >> > var DeleteByDefault = false;
>> >> > /* ask the user for the decision */
>> >> > var AskUser = true;
>> >> > /* a timeout to wait until default route (no deletion) is taken
>> > */
>> >> > var Timeout = 5;
>> >> >
>> >> > You will need to modify these to suit your usage.
>> >> > The above prompt you for deletion of ticker which less than 30
>> > days of
>> >> > quotations. If no response in 5 seconds, it carries on without
>> > deleting.
>> >> >
>> >> > Geo
>> >> >
>> >> >
>> >> > ----- Original Message -----
>> >> > From: "Dimension" <dimension@xxxx>
>> >> > To: <amibroker@xxxxxxxxxxxxxxx>
>> >> > Sent: Friday, November 19, 2004 09:30 PM
>> >> > Subject: [amibroker] Cleanup database
>> >> >
>> >> >
>> >> >>
>> >> >> Hi,
>> >> >> I am running "Cleanup Database". It is poping up a dialogues
>> > telling "X
>> >> > Has
>> >> >> not quotes, Do you wish to delete?" (where X = to a symbol).
>> > However,
>> >> > after
>> >> >> about 5 or so seconds, the dialogue disappears and another re-
>> > appears,
>> >> >> before I get a chance to respond. Why does this happen and
> how
>> > can I
>> >> >> prevent this from happening? Also, can someone describe how
>> > this thing
>> >> > does
>> >> >> it's thing? Does it query the Datasource to determine if a
>> > symbol is
>> >> > valid?
>> >> >>
>> >> >> Btw, enhancement suggestion: It would be good if this function
>> > summarizes
>> >> >> and presents all discrepancies and errors on one
>> > page/popup/dialogue and
>> >> >> offer the user the opportunity to reconcile data from that
> page.
>> >> >>
>> >> >> Thanks much
>> >> >>
>> >> >>
>> >> >> [Non-text portions of this message have been removed]
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >> Check AmiBroker web page at:
>> >> >> http://www.amibroker.com/
>> >> >>
>> >> >> Check group FAQ at:
>> >> > http://groups.yahoo.com/group/amibroker/files/groupfaq.html
>> >> >> Yahoo! Groups Links
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >> >
>> >> >
>> >> > Check AmiBroker web page at:
>> >> > http://www.amibroker.com/
>> >> >
>> >> > Check group FAQ at:
>> >> > http://groups.yahoo.com/group/amibroker/files/groupfaq.html
>> >> > Yahoo! Groups Links
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >> > Check AmiBroker web page at:
>> >> > http://www.amibroker.com/
>> >> >
>> >> > Check group FAQ at:
>> >> > http://groups.yahoo.com/group/amibroker/files/groupfaq.html
>> >> > Yahoo! Groups Links
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >> > Check AmiBroker web page at:
>> >> > http://www.amibroker.com/
>> >> >
>> >> > Check group FAQ at:
>> > http://groups.yahoo.com/group/amibroker/files/groupfaq.html
>> >> > Yahoo! Groups Links
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > Check AmiBroker web page at:
>> > http://www.amibroker.com/
>> >
>> > Check group FAQ at:
>> > http://groups.yahoo.com/group/amibroker/files/groupfaq.html
>> > Yahoo! Groups Links
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>
>
>
>
>
>
> Check AmiBroker web page at:
> http://www.amibroker.com/
>
> Check group FAQ at:
> http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/GHeqlB/TM
--------------------------------------------------------------------~->
Check AmiBroker web page at:
http://www.amibroker.com/
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.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/
|