Here is an empty data base of US stocks Download US Stocks.zip You just need to download the data (e.g. Amiquote). The symbols are sorted by industries and sectors. It's an empty data base someone made one year ago. So it's not up to date since there are also OTC stocks included so if a firm doesn't exist anymore no (current) data will be available. But of course there are also major firms included that have been existing for years and decades.
What to do with the zip file?
Unzip it and put broker.industries, broker.sectors and us_stocks.tls to ... Program Files\Amibroker
Put the import.types and the tls.format file to ... Program Files\Amibroker\Formats folder
Create a new folder called USStocks or anything similar and put it to i.e. ....Program Files\Amibroker or wherever you want it to be. Then start Amibroker and create a new data base (File>New>DataBase). 'Browse' to the USStocks folder you have created before, open it and press save. (Un-)check 'Load data base at startup'. Then press 'Create'.
Now choose data source (most probably 'local data base' as it gets updated via Amiquote). Base time interval EOD but you can choose any other interval.
Now go to File>Import ASCII, click on it, choose file type US_Stocks (*.tls) and browse to the us_stock.tls file located in ....Program Files\Amibroker. Then click open. The stock symbols will be getting imported. But the data base will be still empty so the last thing to do is to start Amiquote ( Tools>Auto update quotes (Amiquote only) ). Choose download range there and start downloading. Of course you can explore other settings of Amiquote before downloading.
Last edited by Amiuser; March 13th, 2012 at 06:23 AM.
The following 2 users say Thank You to Amiuser for this post:
If you for example just need stocks of S&P 500 then here there is the .tls file for that Download S&P 500.tls
Put it to the Amiquote folder, then start Amibroker and Amiquote and in Amiquote choose that tls file (File>Open).
Favorite Futures: Stock, Options and now Futures (ES)
Posts: 514 since Dec 2010
Thanks: 227 given,
Good stuff Amiuser. Thanks for the helpful how-to. I like how it utilizes industries and sectors. I usually get current NYSE, NASDAQ and AMEX listings from the web, I believe on NASDAQ's website, downloadable...
TonyB - FYI you can also find some additional useful .TLS files here;
<had to remove url as I do not have 5 posts, but simply google "how to use amiquote" and select the third link, bottom of the page are extra *.TLS files, you have probably seen them already, but just in case.../>
I, like you, am looking into AmiBroker as a solution for my needs. I will be longer term trading/investing, so only need a platform that deals with EOD data (preferably the free stuff!) that is also cost effective. So far this would appear to be the best option, along with ProTA, but I do not have a Mac.
It would be nice if they had up to date *.TLS files for FTSE100, FTSE350, Europe, etc. considering they charge a fee for AmiQuote, but it would appear they do not. It wouldn't take too much effort to keep them up to date, assuming you put in the effort to create them in the first place, but it is still effort I would rather not have to make..
Having said that - I have been in contact with customer support with no word on additional sources of .TLS files, having asked, but I do not suppose there are a selection on their forums perhaps? Amiuser, perhaps you might be able to shed some light on this?
I am a programmer by trade, albeit very early into my career, so AmiBroker certainly appeals in that sense, I just don't want to go spending hard earned cash until I am happy it is the right decision.
They don't charge a monthly fee for Amiquote. It's a one time price for that ticker downloader. By additional providing and keeping all thousands of world wide tickers up-to-date T.J. would have a lot less time being available to improve his software. I wouldn't like that. Even more so since I'm not into stocks that much. The standard data base provides index and stocks examples of the US market so it's up to the user to add additional ones. But here are some worldwide ticker lists that you can use Download tickers worldwide.rar There is a read me file included. So yeah read it.
Last edited by Amiuser; April 6th, 2012 at 07:25 AM.
The following user says Thank You to Amiuser for this post:
One general note in regards to broker.sectors and broker.industries files of the Amibroker installation folder. Those two files are needed only for creating a data base. After creating of a DB those two files of the .rar archive or any other custom made ones are not needed anymore so the two backed up standard files that are part of the standard installation of Amibroker can be "re-installed".
Ask Market Monk of the yahoo group of AB. He keeps a data base up to date and is providing it to other users. I think he is charging a small donation of around $20. But I don't remember what kind of stocks are included. I think he is an American. So I guess his DB mainly consists of US stocks but ask him.
Another note you can download symbol lists from finviz and simply import them into AB, also can download lists from official US market websites. There was a thread about on the yahoo list recently. I will look at it.