The purpose of this document is to explain how to use AmiQuote and AmiBroker in order to obtain quotes from Yahoo finance and Quote. The main purpose of AmiQuote is to simplify and automate downloading daily and historical quotation data from free Yahoo!
Yahoo provides data in "Historical" and "Current" modes of AmiQuote. A ticker list is a simple text file which lists line by line the tickers you want to import. The AmiQuote ticker list file has. Additional ticker lists are available on the starter page at: You can use those pre-written ticker lists or you can customize them or write your own one.
In order to edit existing. All you have to do is to write tickers you want to import line by line single ticker in single line and save the file. Please make sure that you are saving the file with. 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 ticker symbol.
The suffixes in alphabetical order are you can click on link to get the symbol list for each exchange: AS - Amsterdam ,. BC - Barcelona ,. BE - Berlin ,. BO - Bombay ,. BM - Breman ,. BR - Brussels ,. BA - Buenos Aires ,. CL - Calcuta ,. CR - Caracas ,. V - CDNX ,. CO - Copenhagen ,. D - Dusseldorf ,. F - Frankfurt ,. H - Hamburg ,. HA - Hanover ,. HK - Hong Kong ,. I - Ireland ,. JK - Jakarta ,. KA - Karachi ,. KQ - Kosdaq ,. KS - KSE ,. KL - Kuala Lumpur ,.
L - London ,. LM - Lima ,. LS - Lisbon ,. MA - Madrid ,. MX - Mexico ,. MI - Milan ,. MU - Munich ,. NS - NSE ,. NZ - New Zeland ,. OL - Oslo ,. PA - Paris ,. SN - Santiago ,. SS - Shanghai ,. ST - Stockholm ,. SG - Stutgart ,. TW - Taiwan ,. TA - Tel Aviv ,. TO - Toronto ,. VA - Valencia ,. VI - Viena ,. Please note that also Yahoo and Quote. For list of indices provided by Yahoo please click here. For more details see this Knowledge Base article.
For list of symbols provided by MSN please click here. In order to download the data please launch AmiQuote. From the file dialog please choose one. TLS and click Open button. The you will see the main screen of AmiQuote filled with the list of tickers loaded, as show in picture below. The download process will begin.
AmiQuote will display progress messages and status information including number of completed downloads and number of files left. At anytime you can stop download process with "Stop" button red box. After finishing the download AmiQuote will automatically update the quotes in AmiBroker if only AmiBroker is running in parallel and "automatic import" box in AmiQuote is checked. Intraday interval bar data 1-min, 5-min, min, min and min are available for US securities only. Historical data for international exchanges are usually much shorter than for US markets.
Because intraday bar data are downloaded from Quote. For complete reference please check http: Intraday bar data are limited to bars regardless of bar interval. In other words you always get bars data, whenever these are 1-min, 5-min, min, min or min data - so by choosing bigger interval you get data from more days. This is the limitation imposed by Livecharts server. This step is no longer necessary if you are using "automatic import" feature of AmiQuote.
The explanations are provided only for users wanting to import selectively or re-import files downloaded in the past. First, please launch AmiBroker. You will see the following file dialog:. In this picture I marked the most important items for easy identification. Marked with red is type selector combo-box " Files of type ". In order to import AmiQuote files those with. AQE from the combo box red arrow shows those options. After choosing right type you will see only files of appropriate type in the file list blue arrow shows that.
Now you can select one or more files from the list. Multiple selection is possible by holding CTRL key depressed while selecting the items with a mouse you can also press SHIFT for choosing a range of files with a single click. Now when you are done choosing the files you want to import just click " Open " button.
The import process will start and you will see progress bar showing the AmiBroker is importing the data. After finishing the import AmiBroker will automatically refresh symbol list and you will see updated tickers and charts. If anything goes wrong with the import process AmiBroker writes a log file called "import. You can watch this log file if you want to find out what went wrong since import. You can create or edit.
TLS using Windows Notepad. When saving a file simply give. TLS extension to the file instead of the default. In case of any further questions, comments and suggestions please contact me at: There are following ready-to-use ticker lists available for download:More...