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 -----
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@xxxxxxxxxxx> 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@xxx> 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
<*> 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/
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
__,_._,___
|