{"id":1424,"date":"2008-03-27T22:03:03","date_gmt":"2008-03-27T22:03:03","guid":{"rendered":"http:\/\/www.amibroker.org\/userkb\/2007\/11\/10\/us-stocks-database\/"},"modified":"2008-03-28T02:09:45","modified_gmt":"2008-03-28T02:09:45","slug":"us-stocks-database","status":"publish","type":"post","link":"http:\/\/www.amibroker.org\/editable_userkb\/2008\/03\/27\/us-stocks-database\/","title":{"rendered":"US-Stocks Database (v2)"},"content":{"rendered":"

Jim, who is a long term AmiBroker<\/em> user, regularly provides an updated template that automatically sets up a database of all US stocks available from Yahoo!Finance<\/em>.<\/p>\n

The stocks are initially categorized by Market<\/em> and then as Stocks, Indexes<\/em> or Funds<\/em> at the Group<\/em> level. They are also organized into Sectors<\/em>, using the Hemscott <\/em>classification system.<\/p>\n

A link to the latest message from Jim is available at AmiBrokerYahooGroup message # 119057 – "AmiBroker\/Yahoo Database File":  http:\/\/finance.groups.yahoo.com\/group\/amibroker\/message\/119057<\/a><\/p>\n

Or link directly to the site to obtain the download:<\/p>\n

http:\/\/www.icc-az.com<\/a><\/p>\n

Go to Links >> AmiBroker at that site (instructions are available at the download page).<\/p>\n

After the database is setup, use AmiQuote to download data from the Yahoo Historical<\/em> server (allow approximately 1\/2 – 1 hour download time, using a mid speed broadband connection, per year of history).<\/p>\n

The length of back history available varies with each symbol (the author has downloaded up to 10 years history using this template).<\/p>\n

Typically the ticker list, as setup, will contain a couple of hundred redundant symbols (symbols that return an error message when attempting to download historical data for them). Most of the redundant symbols are .OB (over the counter stock) and are not relevant to the majority of traders. Users can elect to delete them from the database or go to the Yahoo site, or other sites, to find the cause of the ‘download error’ e.g. the stock may have been de-listed or undergone a name change .<\/p>\n

Instructions on how to find and delete the redundant (NoQuotes) symbols can be found in the UKB post >> Setup A Custom Database – Nasdaq<\/a><\/p>\n

Information, or discussion, on the pros and cons of using Yahoo<\/em> data is included in articles in the Yahoo<\/em> sub-category at the Users’ Knowledge Base:<\/em><\/p>\n

http:\/\/www.amibroker.org\/userkb\/?cat=99<\/a><\/p>\n

Further information, about using the US-Stocks database, can be obtained by searching the AmiBrokerYahooGroup<\/em> message board (use an Advanced Search<\/em> and enter Subject contains "US-Stocks"<\/em> OR "AmiBroker\/Yahoo Database<\/em>" as the search criteria . <\/p>\n

 <\/p>\n

Version 2 – Feb 02\/2008 – by Brian_z – written using Windows Live Writer – updated links to current message and new download site<\/sub><\/p>\n","protected":false},"excerpt":{"rendered":"

Jim, who is a long term AmiBroker user, regularly provides an updated template that automatically sets up a database of all US stocks available from Yahoo!Finance. The stocks are initially categorized by Market and then as Stocks, Indexes or Funds at the Group level. They are also organized into Sectors, using the Hemscott classification system. […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[89],"tags":[],"_links":{"self":[{"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/posts\/1424"}],"collection":[{"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/comments?post=1424"}],"version-history":[{"count":0,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/posts\/1424\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/media?parent=1424"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/categories?post=1424"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/tags?post=1424"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}