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

[amibroker] Re: JimSwindle> US STOCKS DATABASE UPDATE



PureBytes Links

Trading Reference Links

I believe most of you are missing the point.  The symbols are easy to
get for all the exchanges and ETF's.  The problem Jim has solved is to
put the Symbols & Name in the proper Sector & Industry groups.(look at
his EXCEL spreadsheet) based on "http://biz.yahoo.com/p/s_pr1d.html";.
 Jim has provided an invaluable service by providing this for us
"gratis" and has put a lot of time an effort into the project.  I'm
sure Jim will respond, he is out of the country for extended periods,
hopefully soon. 

Dick H. 

--- In amibroker@xxxxxxxxxxxxxxx, "cstrader" <cstrader232@xxx> wrote:
>
> Yeah, I can find the ETF and AMEX list.  But I haven't yet found a
list of NAZ or NYSE stocks.
> 
> 
>   ----- Original Message ----- 
>   From: wavemechanic 
>   To: amibroker@xxxxxxxxxxxxxxx 
>   Sent: Wednesday, June 04, 2008 7:03 AM
>   Subject: Re: [amibroker] Re: JimSwindle> US STOCKS DATABASE UPDATE
> 
> 
>   I agree and ETFs are easy.  A number of websites, including those
with RSS feeds, publish new listings (e.g., Seeking Alpha) as they are
applied for and listed.  Stocks are probably similarly available from
websites, exchanges, brokers, etc. but I don't follow them.  Google away.
> 
>   Bill
>     ----- Original Message ----- 
>     From: cstrader 
>     To: amibroker@xxxxxxxxxxxxxxx 
>     Sent: Tuesday, June 03, 2008 11:32 PM
>     Subject: Re: [amibroker] Re: JimSwindle> US STOCKS DATABASE UPDATE
> 
> 
>     Well, I'm not sure why anyone needs to pay for stuff that's
available free. 
>     For instance, CSI is a great vendor, but then Yahoo gets the
data from CSI 
>     and publishes it for free.  What's really needed is the list of
tickers, 
>     however, and perhaps that can only be done efficiently by paying
for it.
> 
>     For me, it's not so bad that there's a ticker that no longer
exists -- I 
>     just check to see what the last download date was -- if it's in
the past 
>     then I assume it's dead.
> 
>     However, keeping up with new issues is more difficult.  I don't
understand 
>     how to scrape the Yahoo site for a list of, say all of the
current ETFs, or 
>     all of the stocks currently trading on the AMEX.  Can anyone
help me with 
>     that?
> 
>     I was using Swindle's list, but now that seems to be gone... so
I need to 
>     hunt for a new list.
> 
>     Thanks
> 
> 
>     ----- Original Message ----- 
>     From: "dingo" <dingo@xxx>
>     To: <amibroker@xxxxxxxxxxxxxxx>
>     Sent: Tuesday, June 03, 2008 10:23 PM
>     Subject: RE: [amibroker] Re: JimSwindle> US STOCKS DATABASE UPDATE
> 
> 
>     >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
>     >
>     >
>     >
> 
> 
>     ------------------------------------
> 
>     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/1481 - Release Date:
6/3/2008 7:31 PM
>



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

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/