I have done what you are suggesting, and Amibroker is capable is retrieving information from mysql (or any sql via odbc).
My experience, however, is that retrieving high-resolution data from mysql (price and volume) into Amibroker is much slower than running it from Amibroker "natively." I cannot say exactly how slow as I haven't taken the time to study it, and I realize that mysql re-keying and indexing can change these speeds (I'm no expert on that topic), but anecdotally I can tell you its like 1/10th as slow. I attempted once to read a couple months of data of the NASDAQ-100 at the 5-second bar level and the Amibroker just froze as it tried to refresh the screen. I had to task-manager kill Broker.exe to get to the next step. To answer your question directly, though, you just use the odbc plugins (there are two of them - one to allow you to retrieve price and volume as you are asking and the other to allow more ad hoc retrieval of non price / volume data). I am successfully using mysql to retrieve non price/volume data and integrating it into price/volume data that is stored in amibroker's database. ----- Original Message ----- From: sohamdas To: [email protected] Sent: Wednesday, April 28, 2010 11:55 PM Subject: [amibroker] Migrating Database to MySQL Hi Tomasz, others I have a database complete with 5 years of intraday data,1min timeframe, in 1500symbols +. I would like to migrate this database to a generic MySQL database,so that I can stay platform independent. For reasons obvious, I wont be able to export each and every symbol and import it to SQL. a. I am seeking a easy way to achieve the same. b. How can we interface AMI with an external database. Help appreciated.
