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

RE: [amibroker] JimSwindle> US STOCKS DATABASE UPDATE



PureBytes Links

Trading Reference Links

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

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




Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___