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: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of cstrader Sent: Tuesday, June 03, 2008 6:20 PM To: [email protected] 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:[EMAIL PROTECTED]> To: [email protected] 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:[EMAIL PROTECTED]> To: [email protected] 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:[EMAIL PROTECTED]> Davis To: [email protected] 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:[EMAIL PROTECTED]> To: [email protected] 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:[EMAIL PROTECTED]> Davis To: [email protected] 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
