How to Use AmiQuote and AmiBroker to Download Stock Data
AmiQuote and AmiBroker are two programs that can help you download and analyze stock data from various sources. AmiQuote is a companion program to AmiBroker that simplifies and automates downloading daily and historical quotation data from free Yahoo! Finance, Quote.com, MSN, and other sites. AmiBroker is a technical analysis and charting software that allows you to perform backtesting, scanning, and alerts on stocks, futures, mutual funds, forex, and other instruments.
In this article, we will show you how to use AmiQuote and AmiBroker to download stock data from Yahoo! Finance and import it into AmiBroker for further analysis.
Step 1: Prepare a ticker list
A ticker list is a simple text file that lists the symbols of the stocks you want to import. The ticker list file has a .TLS extension and can be edited with any plain text editor such as Notepad. AmiQuote comes with pre-written ticker lists for components of main NYSE and NASDAQ indices and a number of European indices/markets. You can also download additional ticker lists from the starter page at: https://www.amibroker.com/starter/.
You can use those pre-written ticker lists or you can customize them or write your own one. All you have to do is to write the symbols you want to import line by line (single symbol in single line) and save the file. Please make sure that you are saving the file with .TLS extension. Otherwise AmiQuote will not load this file.
Please note that Yahoo uses suffixes for non-US stocks. So in order to get quotes for non-US symbol you would need to add appropriate suffix to the symbol. For example, .AS for Amsterdam, .AX for Australia, .L for London, etc. For a full list of suffixes, please refer to https://www.amibroker.com/guide/h_amiquote.html.
Step 2: Launch AmiQuote and load the ticker list
In order to download the data, please launch AmiQuote. Then please click on “Open” button in the toolbar (or choose File -> Open menu) and select one .TLS file (for example DIJA.TLS) and click Open button. Then you will see the main screen of AmiQuote filled with the list of symbols loaded from the file.
Step 3: Choose the data source and mode
Next, you need to choose the data source and mode from the drop-down menus at the top of AmiQuote window. The data source can be Yahoo! Finance (USA, major European exchanges and some other countries), Quote.com (USA only), MSN (USA and some European exchanges), Integratir (US stocks), or Forex (Finam free site). The mode can be Historical (daily data), Current (latest quote), or Intraday (minute data).
For this example, we will choose Yahoo! Finance as the data source and Historical as the mode. This will allow us to download daily historical data from Yahoo! Finance for the symbols in our ticker list.
Step 4: Set the date range and output folder
Next, you need to set the date range for which you want to download the data. You can do this by clicking on “Settings” button in the toolbar (or choose Tools -> Settings menu) and selecting the “Date range” tab. You can choose from predefined ranges such as All available data, Last 1 year, Last 6 months, etc., or you can enter your own custom range by typing in the start date and end date fields.
You also need to set the output folder where AmiQuote will save the downloaded data files. You can do this by clicking on “Settings” button in the toolbar (or choose Tools -> Settings menu) and selecting the “Output” tab. You can choose from predefined folders such as C:\Program Files\AmiBroker\ or C:\Program Files\Ami