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

[amibroker] Re: OT: Data (Was: Need to fix Database - recommendations wanted)



PureBytes Links

Trading Reference Links

I wouldn't bother with downloading that file and running the 
cleaner.  It ends up deleting several thousand stocks and the 
original file is so old you are never really confident you have all 
the symbols.  I am just getting re-setup again with Amibroker and 
forgot how much of a pain something as seemingly "simple" as getting 
data was the last time.  
Another thing is to use PowerScan to run queries on the DB and remove 
any stocks that don't have Ave Vol of 50,000 or whatever your volume 
cutoff is..  That takes the original database down to almost 2000, 
but obviously it's still missing every IPO like GOOG since 2002.. 







--- In amibroker@xxxxxxxxxxxxxxx, "dingo" <dingo@xxx> wrote:
>
> I agree.  Check your email.
>  
> d
> 
> 
>   _____  
> 
> From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] 
On Behalf
> Of jim_trades_stocks
> Sent: Tuesday, May 23, 2006 11:44 AM
> To: amibroker@xxxxxxxxxxxxxxx
> Subject: [amibroker] Re: OT: Data (Was: Need to fix Database -
> recommendations wanted)
> 
> 
> A cupla things I forgot:
> 
> Here is an old template on the AB Site:
> 
> http://www.amibroker.com/docs/ab305.html
> 
> You could use this to build the basic structure and then use the 
> DataPurify thingy under "Tools" in AB menu.
> 
> Then update it with newer tickers.   I'd experiment with the above 
in 
> a new database. If it looks like too much work you can easily 
delete 
> it.
> ..................................................
> 
> Dingo,
> 
> It would be real nice (and an AB selling feature) if Thomasz had 
the 
> Yahoo US Stock database updated. That file is about 4 years old. 
> 
> Or, if someone was looking to start a sideline business, to keep 
that 
> list updated twice per year and charge for it.
> 
> 
> 
> 
> 
> 
> 
> 
> 
> --- In amibroker@xxxxxxxxxxxxxxx, "dingo" <dingo@> wrote:
> >
> > A cupla things I forgot:
> >  
> > Here is an old template on the AB Site:
> >  
> > http://www.amibroker.com/docs/ab305.html
> >  
> > You could use this to build the basic structure and then use the 
> DataPurify
> > thingy under "Tools" in AB menu.
> >  
> > Then update it with newer tickers.   I'd experiment with the 
above 
> in a new
> > database. If it looks like too much work you can easily delete it.
> >  
> > d
> > 
> > 
> >   _____  
> > 
> > From: amibroker@xxxxxxxxxxxxxxx 
[mailto:amibroker@xxxxxxxxxxxxxxx] 
> On Behalf
> > Of dingo
> > Sent: Tuesday, May 23, 2006 10:45 AM
> > To: amibroker@xxxxxxxxxxxxxxx
> > Subject: RE: [amibroker] Re: OT: Data (Was: Need to fix Database -
> > recommendations wanted)
> > 
> > 
> > Its all avail on Yahoo. You will have to do some work on this, 
> duude.
> >  
> > http://biz.yahoo.com/p/s_conameu.html
> >  
> > http://biz.yahoo.com/p/sum_conameu.html
> >  
> > http://biz.yahoo.com/ic/ind_index.html
> >  
> >  
> > http://biz.yahoo.com/p/112conameu.html
> >  
> > etc.
> >  
> > You'll need to learn how to navigate this stuff.
> >  
> > Also check here for some lists already done (you may have to 
update 
> them)
> >  
> > http://finance.groups.yahoo.com/group/amibroker/files/
> > 
> >  
> > note that there is a later version of the script mentioned in the
> > newsletter:
> >  
> > "      Industries.js
> > <http://f1.grp.yahoofs.com/v1/YBVzRN2FznSWRD4TumPSVN-
> XwJaDMndJPP0AgIgoqroAnp
> > 
> 
0bw3lfMu8dgZWHOFI5VChsBKWLhBN6kVrYDC6KQ_X6aT4K9cOcS8A/Industries.js>  
> "
> >  
> > http://finance.groups.yahoo.com/group/amibroker-ts/files/
> >  
> > and also go here http://www.amibroker.com/library/list.php
> >  
> > and do a search on the word sector
> >  
> > d
> > 
> > 
> > 
> >   _____  
> > 
> > From: amibroker@xxxxxxxxxxxxxxx 
[mailto:amibroker@xxxxxxxxxxxxxxx] 
> On Behalf
> > Of jim_trades_stocks
> > Sent: Tuesday, May 23, 2006 10:31 AM
> > To: amibroker@xxxxxxxxxxxxxxx
> > Subject: [amibroker] Re: OT: Data (Was: Need to fix Database -
> > recommendations wanted)
> > 
> > 
> > Thanks Dingo, that explains how to do it. Now all I need is the 
> Yahoo 
> > ticker file with the sectors/industries. Do you know where I can 
> find 
> > such a file, as recent as possible?
> > 
> > Thanks
> > 
> > 
> > 
> > 
> > --- In amibroker@xxxxxxxxxxxxxxx, "dingo" <dingo@> wrote:
> > >
> > > Start here:
> > >  
> > > http://www.amibroker.com/newsletter/07-2000.html
> > >  
> > > and down at the bottom is a link:
> > >  
> > > http://www.amibroker.com/newsletter/04-2000.html
> > >  
> > > Scroll down to: "4 Tip of the week: : How to automate assigning 
> > stocks to
> > > sectors/industries ?"
> > >  
> > > d
> > >  
> > > 
> > > 
> > > 
> > >   _____  
> > > 
> > > From: amibroker@xxxxxxxxxxxxxxx 
> [mailto:amibroker@xxxxxxxxxxxxxxx] 
> > On Behalf
> > > Of jim_trades_stocks
> > > Sent: Tuesday, May 23, 2006 10:01 AM
> > > To: amibroker@xxxxxxxxxxxxxxx
> > > Subject: [amibroker] Re: OT: Data (Was: Need to fix Database -
> > > recommendations wanted)
> > > 
> > > 
> > > Thank you all for your comments.
> > > 
> > > I have been swing trading for about 25 years using EOD data, 
the 
> > past 
> > > 8 years or so, online. I have used paid EOD data in the past 
with 
> > > TC2000 and other programs before using Amibroker and my 
> > profitability 
> > > has not changed with free EOD from Yahoo into AB.
> > > 
> > > I see no reason to fork out $ 3-400 per year when Yahoo EOD 
works 
> > for 
> > > me.
> > > 
> > > If anyone can suggest how to easily classify my Yahoo tickers 
(or 
> > the 
> > > whole US stock market)into sectors/industries etc...I would be 
> > > grateful.
> > > 
> > > Thanks
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > --- In amibroker@xxxxxxxxxxxxxxx, "Nick Ali" <nick.ali@> wrote:
> > > >
> > > > I am not a fan of esignal either - DTN is worse. In 'brisk' 
> > markets 
> > > (not
> > > > fast)  there data lags IB considerably. I guess esignal are 
> > > concidered
> > > > 'cheap' (haha) compared to 'professional' feeds.
> > > > 
> > > > Cheers.
> > > > 
> > > > -----Original Message-----
> > > > From: amibroker@xxxxxxxxxxxxxxx 
> > [mailto:amibroker@xxxxxxxxxxxxxxx] 
> > > On Behalf
> > > > Of Yuki Taga
> > > > Sent: 23 May 2006 07:26
> > > > To: MailYahoo
> > > > Subject: [amibroker] OT: Data (Was: Need to fix Database - 
> > > recommendations
> > > > wanted)
> > > > 
> > > > Hi MailYahoo,
> > > > 
> > > > Tuesday, May 23, 2006, 1:23:07 PM, you wrote:
> > > > 
> > > > M> You get what you pay for when it comes to data
> > > > 
> > > > Not always.
> > > > 
> > > > I will be dumping eSignal in six weeks, after giving them a 
> full 
> > > year to get
> > > > Tokyo data correct.  Their last trick, this month, was 
> inserting 
> > > phantom
> > > > trade dates into the data -- days when the market was locked 
> and 
> > > closed.
> > > > This comes amid a consistent inability to get the opening 
> prices 
> > > correct, in
> > > > a market that has one and only one opening price.  My eSignal 
> > > database is
> > > > riddled with errors.
> > > > 
> > > > Their support claimed to have fixed the problem, but a force 
> > > backfill shows
> > > > otherwise.  Their support no longer even replies to e-mail.
> > > > 
> > > > I don't know what an "allowable fudge factor" would be for 
data 
> > > accuracy,
> > > > but I do know two things:  1) eSignal is *way* over what any 
> > > reasonable
> > > > person would consider "allowable", and 2) *much* cheaper data 
> > > sources seem
> > > > to have no problems approaching 100 percent correct.  One 
does 
> > *not*
> > > > necessarily get what one pays for.
> > > > 
> > > > Yuki
> > > > 
> > > > 
> > > > 
> > > > ------------------------ Yahoo! Groups Sponsor ---------------
--
> --
> > -
> > > ~-->
> > > > Everything you need is one click away.  Make Yahoo! your home 
> > page 
> > > now.
> > > > http://us.click.yahoo.com/AHchtC/4FxNAA/yQLSAA/GHeqlB/TM
> > > > --------------------------------------------------------------
--
> --
> > --
> > > ~-> 
> > > > 
> > > > 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
> > > > 
> > > > 
> > > > 
> > > >  
> > > > 
> > > > 
> > > > 
> > > > --
> > > > No virus found in this incoming message.
> > > > Checked by AVG Free Edition.
> > > > Version: 7.1.392 / Virus Database: 268.6.1/344 - Release 
Date: 
> > > 19/05/2006
> > > >
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 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
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > SPONSORED LINKS 
> > > Investment
> > > <http://groups.yahoo.com/gads?
> > t=ms&k=Investment+management+software&w1=Inves
> > > 
> > 
> 
tment+management+software&w2=Real+estate+investment+software&w3=Invest
> > ment+p
> > > 
> > 
> 
roperty+software&w4=Software+support&w5=Real+estate+investment+analysi
> > s+soft
> > > 
ware&w6=Investment+software&c=6&s=200&.sig=_XXUzbE9l5lGlZNcMu4KNQ>
> > > management software       Real
> > > <http://groups.yahoo.com/gads?
> > t=ms&k=Real+estate+investment+software&w1=Inve
> > > 
> > 
> 
stment+management+software&w2=Real+estate+investment+software&w3=Inves
> > tment+
> > > 
> > 
> 
property+software&w4=Software+support&w5=Real+estate+investment+analys
> > is+sof
> > > 
> tware&w6=Investment+software&c=6&s=200&.sig=5_sgDczz3ArKGMtJ9tFSJA> 
> > estate
> > > investment software       Investment
> > > <http://groups.yahoo.com/gads?
> > t=ms&k=Investment+property+software&w1=Investm
> > > 
> > 
> 
ent+management+software&w2=Real+estate+investment+software&w3=Investme
> > nt+pro
> > > 
> > 
> 
perty+software&w4=Software+support&w5=Real+estate+investment+analysis+
> > softwa
> > > 
re&w6=Investment+software&c=6&s=200&.sig=_N6zcwefgp4eg5n6oX5WZw> 
> > property
> > > software       
> > > Software
> > > <http://groups.yahoo.com/gads?
> > t=ms&k=Software+support&w1=Investment+manageme
> > > 
> > 
> 
nt+software&w2=Real+estate+investment+software&w3=Investment+property+
> > softwa
> > > 
> > 
> 
re&w4=Software+support&w5=Real+estate+investment+analysis+software&w6=
> > Invest
> > > ment+software&c=6&s=200&.sig=MJ2jP31F3n64RDZkDadU8w> 
> support       Real
> > > <http://groups.yahoo.com/gads?
> > t=ms&k=Real+estate+investment+analysis+softwar
> > > 
> > 
> 
e&w1=Investment+management+software&w2=Real+estate+investment+software
> > &w3=In
> > > 
> > 
> 
vestment+property+software&w4=Software+support&w5=Real+estate+investme
> > nt+ana
> > > 
> > 
> 
lysis+software&w6=Investment+software&c=6&s=200&.sig=GmF8PlAJASx0wrSaX
> > 5-Zlw>
> > > estate investment analysis software       Investment
> > > <http://groups.yahoo.com/gads?
> > t=ms&k=Investment+software&w1=Investment+manag
> > > 
> > 
> 
ement+software&w2=Real+estate+investment+software&w3=Investment+proper
> > ty+sof
> > > 
> > 
> 
tware&w4=Software+support&w5=Real+estate+investment+analysis+software&
> > w6=Inv
> > > estment+software&c=6&s=200&.sig=aMgGsKT4w29dMAYUzQUKzg> 
software 
> >       
> > > 
> > >   _____  
> > > 
> > > YAHOO! GROUPS LINKS 
> > > 
> > > 
> > >       
> > > *      Visit your group "amibroker
> > > <http://groups.yahoo.com/group/amibroker> " on the web.
> > >   
> > > 
> > > *      To unsubscribe from this group, send an email to:
> > >  amibroker-unsubscribe@xxxxxxxxxxxxxxx
> > > <mailto:amibroker-unsubscribe@xxxxxxxxxxxxxxx?
> subject=Unsubscribe> 
> > >   
> > > 
> > > *      Your use of Yahoo! Groups is subject to the Yahoo! Terms 
> of 
> > Service
> > > <http://docs.yahoo.com/info/terms/> . 
> > > 
> > > 
> > >   _____
> > >
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 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
> > 
> > 
> > 
> > 
> > 
> > 
> > SPONSORED LINKS 
> > Investment
> > <http://groups.yahoo.com/gads?
> t=ms&k=Investment+management+software&w1=Inves
> > 
> 
tment+management+software&w2=Real+estate+investment+software&w3=Invest
> ment+p
> > 
> 
roperty+software&w4=Software+support&w5=Real+estate+investment+analysi
> s+soft
> > ware&w6=Investment+software&c=6&s=200&.sig=_XXUzbE9l5lGlZNcMu4KNQ>
> > management software       Real
> > <http://groups.yahoo.com/gads?
> t=ms&k=Real+estate+investment+software&w1=Inve
> > 
> 
stment+management+software&w2=Real+estate+investment+software&w3=Inves
> tment+
> > 
> 
property+software&w4=Software+support&w5=Real+estate+investment+analys
> is+sof
> > 
tware&w6=Investment+software&c=6&s=200&.sig=5_sgDczz3ArKGMtJ9tFSJA> 
> estate
> > investment software       Investment
> > <http://groups.yahoo.com/gads?
> t=ms&k=Investment+property+software&w1=Investm
> > 
> 
ent+management+software&w2=Real+estate+investment+software&w3=Investme
> nt+pro
> > 
> 
perty+software&w4=Software+support&w5=Real+estate+investment+analysis+
> softwa
> > re&w6=Investment+software&c=6&s=200&.sig=_N6zcwefgp4eg5n6oX5WZw> 
> property
> > software       
> > Software
> > <http://groups.yahoo.com/gads?
> t=ms&k=Software+support&w1=Investment+manageme
> > 
> 
nt+software&w2=Real+estate+investment+software&w3=Investment+property+
> softwa
> > 
> 
re&w4=Software+support&w5=Real+estate+investment+analysis+software&w6=
> Invest
> > ment+software&c=6&s=200&.sig=MJ2jP31F3n64RDZkDadU8w> 
support       Real
> > <http://groups.yahoo.com/gads?
> t=ms&k=Real+estate+investment+analysis+softwar
> > 
> 
e&w1=Investment+management+software&w2=Real+estate+investment+software
> &w3=In
> > 
> 
vestment+property+software&w4=Software+support&w5=Real+estate+investme
> nt+ana
> > 
> 
lysis+software&w6=Investment+software&c=6&s=200&.sig=GmF8PlAJASx0wrSaX
> 5-Zlw>
> > estate investment analysis software       Investment
> > <http://groups.yahoo.com/gads?
> t=ms&k=Investment+software&w1=Investment+manag
> > 
> 
ement+software&w2=Real+estate+investment+software&w3=Investment+proper
> ty+sof
> > 
> 
tware&w4=Software+support&w5=Real+estate+investment+analysis+software&
> w6=Inv
> > estment+software&c=6&s=200&.sig=aMgGsKT4w29dMAYUzQUKzg> software 
>       
> > 
> >   _____  
> > 
> > YAHOO! GROUPS LINKS 
> > 
> > 
> >       
> > *      Visit your group "amibroker
> > <http://groups.yahoo.com/group/amibroker> " on the web.
> >   
> > 
> > *      To unsubscribe from this group, send an email to:
> >  amibroker-unsubscribe@xxxxxxxxxxxxxxx
> > <mailto:amibroker-unsubscribe@xxxxxxxxxxxxxxx?
subject=Unsubscribe> 
> >   
> > 
> > *      Your use of Yahoo! Groups is subject to the Yahoo! Terms 
of 
> Service
> > <http://docs.yahoo.com/info/terms/> . 
> > 
> > 
> >   _____
> >
> 
> 
> 
> 
> 
> 
> 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
> 
> 
> 
> 
> 
> 
> SPONSORED LINKS 
> Investment
> <http://groups.yahoo.com/gads?
t=ms&k=Investment+management+software&w1=Inves
> 
tment+management+software&w2=Real+estate+investment+software&w3=Invest
ment+p
> 
roperty+software&w4=Software+support&w5=Real+estate+investment+analysi
s+soft
> ware&w6=Investment+software&c=6&s=200&.sig=_XXUzbE9l5lGlZNcMu4KNQ>
> management software 	Real
> <http://groups.yahoo.com/gads?
t=ms&k=Real+estate+investment+software&w1=Inve
> 
stment+management+software&w2=Real+estate+investment+software&w3=Inves
tment+
> 
property+software&w4=Software+support&w5=Real+estate+investment+analys
is+sof
> tware&w6=Investment+software&c=6&s=200&.sig=5_sgDczz3ArKGMtJ9tFSJA> 
estate
> investment software 	Investment
> <http://groups.yahoo.com/gads?
t=ms&k=Investment+property+software&w1=Investm
> 
ent+management+software&w2=Real+estate+investment+software&w3=Investme
nt+pro
> 
perty+software&w4=Software+support&w5=Real+estate+investment+analysis+
softwa
> re&w6=Investment+software&c=6&s=200&.sig=_N6zcwefgp4eg5n6oX5WZw> 
property
> software 	
> Software
> <http://groups.yahoo.com/gads?
t=ms&k=Software+support&w1=Investment+manageme
> 
nt+software&w2=Real+estate+investment+software&w3=Investment+property+
softwa
> 
re&w4=Software+support&w5=Real+estate+investment+analysis+software&w6=
Invest
> ment+software&c=6&s=200&.sig=MJ2jP31F3n64RDZkDadU8w> support 	Real
> <http://groups.yahoo.com/gads?
t=ms&k=Real+estate+investment+analysis+softwar
> 
e&w1=Investment+management+software&w2=Real+estate+investment+software
&w3=In
> 
vestment+property+software&w4=Software+support&w5=Real+estate+investme
nt+ana
> 
lysis+software&w6=Investment+software&c=6&s=200&.sig=GmF8PlAJASx0wrSaX
5-Zlw>
> estate investment analysis software 	Investment
> <http://groups.yahoo.com/gads?
t=ms&k=Investment+software&w1=Investment+manag
> 
ement+software&w2=Real+estate+investment+software&w3=Investment+proper
ty+sof
> 
tware&w4=Software+support&w5=Real+estate+investment+analysis+software&
w6=Inv
> estment+software&c=6&s=200&.sig=aMgGsKT4w29dMAYUzQUKzg> software 
	
> 
>   _____  
> 
> YAHOO! GROUPS LINKS 
> 
> 
> 	
> *	 Visit your group "amibroker
> <http://groups.yahoo.com/group/amibroker> " on the web.
>   
> 
> *	 To unsubscribe from this group, send an email to:
>  amibroker-unsubscribe@xxxxxxxxxxxxxxx
> <mailto:amibroker-unsubscribe@xxxxxxxxxxxxxxx?subject=Unsubscribe> 
>   
> 
> *	 Your use of Yahoo! Groups is subject to the Yahoo! Terms of 
Service
> <http://docs.yahoo.com/info/terms/> . 
> 
> 
>   _____
>









------------------------ Yahoo! Groups Sponsor --------------------~--> 
Everything you need is one click away.  Make Yahoo! your home page now.
http://us.click.yahoo.com/AHchtC/4FxNAA/yQLSAA/GHeqlB/TM
--------------------------------------------------------------------~-> 

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/