[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[amibroker] Re: Cleanup database



PureBytes Links

Trading Reference Links


Hi Steve,
I'm aware of modifying script. I adjusted it some time ago to slowww 
it down. Your other info is greatly appreciated!! Thank you. 

Greg
--- In amibroker@xxxxxxxxxxxxxxx, "Steve Dugas" <sjdugas@xxxx> wrote:
> 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@xxxx>
> 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 --------------------~--> 
$9.95 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/J8kdrA/y20IAA/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/