|
PureBytes Links
Trading Reference Links
|
PS - In order to avoid wasting time scanning/eyeballing obsolete tickers, I
often add something like this to my code:
LastMktDay = 1041119; // at the top, easy to change
your code here...
Filter = price, volume,whatever AND Datenum() == LastMktDay;
Steve
----- Original Message -----
From: "Steve Dugas" <sjdugas@xxxxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Saturday, November 20, 2004 12:51 PM
Subject: Re: [amibroker] Re: Cleanup database
>
> 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
>>
>>
>>
>>
>>
>>
>>
>>
>
>
>
>
>
> 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/
|