AmiBroker Database Files
Updated: 7 Feb 2009

Stocks.zip 1.5mb

Stocks_XLS.zip 1.0mb

Broker.zip 3kb


 AmiBroker is a superb analysis tool for stocks. However, the new stocks that come out on a frequent basis take some time to find and update. To this end the symbols from the Yahoo web site are being provided here as an AB database. 

To install just the database: 
  • Ensure AmiBroker is closed.
  • Unzip the file into the directory you wish to use. For example, D:\US-Stocks 
  • Open AmiBroker and go to Tools, Preferences, then choose the Data tab. Use the Pick button and select the new database.
  • Complete!
SOURCE CODE
The Stocks_XLS spreadsheet has the VBA source included in it to extract the data needed from the Yahoo financial website. It was developed on XP with Excel 2003.

For those that know VBA, run the modExtract.RunExtractor to pull the data in from the website. This uses a simple (and crude) Internet Explorer pull to open the webpage and pull in the data. It then loops through each of the Sectors, then drills down into the Industries, and lastly goes out and pulls each Company information down. Since this using plain VBA for all extraction, it is very slow. Expect 12 hours to do an extract...

Next run the modAB.AB_Start to take the data from the spreadsheet and copy it into the AmiBroker database. This takes about a minute or less.

The source is provided as is. You may modify it anyway you want and redistribute it as you see fit. There is no guarantee that it will work or of any errors in the code. Additionally, we are not related in way with AmiBroker software and cannot answer questions about it.

LOW VOLUME
For those who would like to remove the low volume or small price stocks, this is the Auto Analysis code to place in your Formula Editor to find them.
  • AddColumn(Volume, "Volume", 1.0) ;
    • Email: 'jr.ab' at 'icc-az.com'. Please put Amibroker in the subject line to bypass the spam filters.

    No research, information or content contained shall be construed as advice and is offered for information purposes only. We shall not be responsible and disclaim any liability for any loss, liability, damage (whether direct or consequential) or expense of any nature whatsoever which may be suffered by the user or any third party as a result of or which may be attributable, directly or indirectly, to the use of or reliance on any information or service provided. All files/information is provided 'as is' with no warranty or guarantee as to its reliability or accuracy.