Convert Tick database to minute OHLC database

I am going to buy years of tick data for back testing. I know I can easily change tick chart to minute chart by setting time interval to minute instead of tick. I am talking about database, for reducing storage and fast loading. Is there a Amibroker magic function could do it for me? Thanks for giving me a direction.

Make an AB Tick "base" DB, then you can export it to ASCII in any interval you want. Then create a minute DB and import the ASCII data.

1 Like
  1. go to Analysis
  2. select desired periodicity in the settings,
  3. run code described in KB http://www.amibroker.com/kb/2006/03/04/how-to-export-quotations-from-amibroker-to-csv-file/

You get your files in desired periodicity now.

1 Like