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

[amibroker] Re: JimSwindle> US STOCKS DATABASE UPDATE



PureBytes Links

Trading Reference Links

Dingo,

As an alternative to "creating" a database could the program be
designed to also provide two text file outputs: 1 showing new symbols
and the other "missing" symbols (which would require it to know of
it's last download or scan)?

MM

--- In amibroker@xxxxxxxxxxxxxxx, "dingo" <dingo@xxx> wrote:
>
> I haven't investigated any thing other than Yahoo.  If there is a
weg site
> that lists the tickers, etc without having a subscription, etc. then
I could
> prolly scrape it.
> 
> As designed the program scrapes the data and presents it to you in a
grid
> organized by sector/industry or index or etf then you can select
those that
> you want to delete and THEN it will create the database.
> 
> d 
> 
> > -----Original Message-----
> > From: amibroker@xxxxxxxxxxxxxxx 
> > [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of marketmonk777
> > Sent: Tuesday, June 03, 2008 8:35 PM
> > To: amibroker@xxxxxxxxxxxxxxx
> > Subject: [amibroker] Re: JimSwindle> US STOCKS DATABASE UPDATE
> > 
> > I would be interested in this program.  But all I am looking for is a
> > program that creates a list of symbols.  What would be nice is for it
> > to "compare" a current download to a previous download and have a
> > report generated showing what was added and what is missing.
> > 
> > That way I can decide which stocks to add to my own database.
> > 
> > The benefit to me is that I don't have to strip out symbols from the
> > pink sheets or OTC BB. 
> > 
> > Amiquote does a great job of downloading the data and don't see a need
> > to replace that functionality.
> > 
> > As for the price .. that would depend on the functionality that you
> > decide to put into it.  Will it work with just Yahoo? 
> > 
> > Regards,
> > MM
> > 
> > --- In amibroker@xxxxxxxxxxxxxxx, "dingo" <dingo@> wrote:
> > >
> > > There is not a separate list of added / deleted stocks - Yahoo just
> > updates
> > > their site on the fly. You would need to build a new list 
> > and compare it
> > > with those in the database. There is a trail of Yahoo pages that
> > contains
> > > what they consider to be the stocks avail in the US - grouped by
> > sector /
> > > industry.  These pages have to be scraped to get the tickers and
> > names. Then
> > > a problem arises when you go to down load quotes for the entire list
> > that
> > > you've built by scraping - Yahoo doesn't have quotes for 
> > all of them and
> > > some have even had their tickers changed but the pages haven't been
> > updated
> > > yet.  Plus, you also get pink sheet stocks and other "stuff".  The
> > indexes,
> > > etfs, mutual funds, etc are all on their own pages and 
> > would have to be
> > > scraped also.
> > >  
> > > I've done some of this in a program I wrote several years 
> > ago - it even
> > > updates the quotes and can be scheduled via the scheduler.  It will
> > retireve
> > > historical, current and fundamental data.  What it doesn't do at
> > present is
> > > detect those stocks that have no quotes or that have ceased trading
> > - those
> > > that give an error msg when you try to use Amiquote.  It 
> > also does NOT
> > > update the database - it just builds them and updates the quotes. I
> > stopped
> > > working on it because I thought TJ was going to address this and
> > decided not
> > > put any more of my time into it.
> > >  
> > > I can be talked into finishing it but I won't do it for free - I
> > done quite
> > > a few free programs for AB and won't do that any more.
> > >  
> > > Soooo - what's a price that people are willing to pay and and how
> > many would
> > > be interested.  If theres not that much interest then I 
> > won't bother.
> > >  
> > > d
> > > 
> > > 
> > >   _____  
> > > 
> > > From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx]
> > On Behalf
> > > Of cstrader
> > > Sent: Tuesday, June 03, 2008 6:20 PM
> > > To: amibroker@xxxxxxxxxxxxxxx
> > > Subject: Re: [amibroker] JimSwindle> US STOCKS DATABASE UPDATE
> > > 
> > > 
> > > Hi Ronald,
> > >  
> > > You say:
> > >  
> > > ... DOWNLOAD ALL OF THE SYMBOLS THAT "YAHOO" has ADDED  in 
> > their "YAHOO"
> > > database of STOCK SYMBOLS AND PRICES, VOL ,etc.   
> > >  
> > > DO YOU KNOW WHERE THAT "ADDED" LIST IS LOCATED?
> > >  
> > > If YAHOO discontinues carrying  a symbol, then their NEW 
> > CURRENT list of
> > > symbols will...NOT...
> > >  
> > > DO YOU KNOW WHERE THAT "NEW CURRENT" LIST IS LOCATED?  AND WHAT IS
> > THE "NEW
> > > CURRENT" LIST.
> > >  
> > > I'M CURIOUS IF IT'S POSSIBLE TO DOWNLOAD THE ENTIRE LIST OF 
> > YAHOO STOCKS
> > > SOMEHOW.
> > >  
> > > Thanks
> > >  
> > > 
> > > ----- Original Message ----- 
> > > From: Ronald Davis <mailto:xokie7@>  
> > > To: amibroker@xxxxxxxxxxxxxxx 
> > > Sent: Tuesday, June 03, 2008 5:27 PM
> > > Subject: Re: [amibroker] JimSwindle> US STOCKS DATABASE UPDATE
> > > 
> > > Cs, he HAS been doing it for free.  
> > >  
> > > AB does NOT KNOW which symbols are current.   
> > >  
> > > That is why there exists a need DOWNLOAD ALL OF THE SYMBOLS THAT
> > "YAHOO" has
> > > ADDED  in their "YAHOO" database of STOCK SYMBOLS AND PRICES, VOL
> > ,etc.   
> > >  
> > > If YAHOO discontinues carrying  a symbol, then their NEW 
> > CURRENT list of
> > > symbols will , NOT have it anymore, and it will have been purged
> > from your
> > > AB database of SYMBOLS in the AB US STOCKS FOLDER.   Ron D
> > > 
> > > ----- Original Message ----- 
> > > From: cstrader <mailto:cstrader232@>  
> > > To: amibroker@xxxxxxxxxxxxxxx 
> > > Sent: Tuesday, June 03, 2008 4:03 PM
> > > Subject: Re: [amibroker] JimSwindle> US STOCKS DATABASE UPDATE
> > > 
> > > Aha, I thought Jim was doing this for free.  But in any case, how
> > does AB
> > > determine which stocks are current and should be on the 
> > list?  Yahoo has
> > > almost 40,000 tickers; who determines which ones go into the US
> > STOCK SYMBOL
> > > list?
> > > 
> > > 
> > > Thanks
> > >   
> > > 
> > > ----- Original Message ----- 
> > > From: Ronald  <mailto:xokie7@> Davis 
> > > To: amibroker@xxxxxxxxxxxxxxx 
> > > Sent: Tuesday, June 03, 2008 4:17 PM
> > > Subject: Re: [amibroker] JimSwindle> US STOCKS DATABASE UPDATE
> > > 
> > > This origional post was an inquiry asking when Jim Swindle 
> > would place a
> > > LATER than >JAN/4/2008 UPDATED LIST OF US STOCK SYMBOLS on 
> > his UPDATE
> > > website. 
> > >  
> > > Jim was paid to create this updating UPDATING software, so 
> > he is not at
> > > liberty to simply give it away to Amibroker users.
> > >  
> > > Yes, I would love to help JIM, but I can't think of 
> > anything I can do to
> > > assist writing code FOR a NEW version of this updating software.  
> > > I do recall that Dingo and Jim discussed the possibility of a Joint
> > effort
> > > once, BUT I DON'T THINK IT WENT ANYWHERE.
> > >  
> > >  
> > > HERE IS MORE INFORMATION>>Jim Swindle's  US STOCKS DATABASE UPDATE
> > SITE  is
> > > simply an updated  list of the 
> > > most recent SYMBOLS  in the US STOCKS FOLDER within Amibroker.
> > > When you run a download from this site, it installs the MORE RECENT
> > list of
> > > the symbols over the OLDER  list of symbols.   
> > > This process of UPDATING  the symbols must be followed by a 
> > HISTORICAL
> > > download of all of the TICKER data for as far back as you want to
> > have in
> > > your database. 
> > >  
> > >
> > ==============================================================
> > ==============
> > > ===========
> > >  
> > > 
> > > ----- Original Message ----- 
> > > From: cstrader <mailto:cstrader232@>  
> > > To: amibroker@xxxxxxxxxxxxxxx 
> > > Sent: Tuesday, June 03, 2008 1:46 PM
> > > Subject: Re: [amibroker] JimSwindle> US STOCKS DATABASE UPDATE
> > > 
> > > Perhaps we should try to help Jim out a bit.  What features would we
> > want to
> > > see in such a stocks database?
> > >  
> > > Thanks
> > >  
> > >  
> > > 
> > > ----- Original Message ----- 
> > > From: Ronald  <mailto:xokie7@> Davis 
> > > To: amibroker@xxxxxxxxxxxxxxx 
> > > Sent: Tuesday, June 03, 2008 9:21 AM
> > > Subject: [amibroker] JimSwindle> US STOCKS DATABASE UPDATE
> > > 
> > > Has anyone heard from Jim regarding when a later update will be
> > available?
> > >  
> > > This link to Jim Swindle's US STOCKS DATABASE  site shows that it
> > was last
> > > udated on Jan 4, 2008.
> > >  
> > > I also recall that Jim was planning to create a method so that each
> > of us
> > > could run a LATEST TICKER symbol update an any time. 
> > >  
> > > We all are grateful  to Jim for having done this.   Ron D
> > >  
> > >  
> > >  
> > >  
> > >  
> > >  
> > >  
> > >  
> > >  
> > > 
> > <http://www.icc-az.com/icc-az/default.html?http%3A//www.icc-az
> > .com/icc-az/>
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > >  
> > > 
> > > No virus found in this incoming message.
> > > Checked by AVG.
> > > Version: 8.0.100 / Virus Database: 269.24.6/1480 - Release Date:
> > 6/3/2008
> > > 7:00 AM
> > >
> > 
> > 
> > 
> > ------------------------------------
> > 
> > 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 NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
> > http://www.amibroker.com/devlog/
> > 
> > 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. 
> > Version: 8.0.100 / Virus Database: 269.24.6/1480 - Release 
> > Date: 6/3/2008 7:00 AM
> >
>



------------------------------------

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 NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

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/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> 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/