How to export chart historical data from Amibroker

In order to export historical bars as they appear in chart, one has to write an AFL program which can become unmanageable in future, so here at randomticks we are providing a DLL plugin, using which you can export csv files for each AmiBroker symbols in seconds.

Steps

  1. Download the dll plugin fromĀ https://drive.google.com/file/d/122BLgMwi6M3XfSRszEoz6lyQtdVAu6eg/view?usp=sharing
  2. Copy DLL file inside amibrokers “plugins” directory.
  3. Now start AmiBroker and open any symbol you want to export.
  4. Right click -> edit the AFL, only once you need to do this.
  5. Inside AFL file add a call to the following function
  6. RTT_Export();

This will generate a csv files inside AmiBroker install directory (root path just above plugins folder), now, more csv files can be exported by just clicking next symbol.

NOTE: this uses caching, once a export file is created it does not regenerate them on each AFL run, so if you want to force overwrite of csv file call the function like below

RTT_Export(1);

Problems with Tick chart and their benefits

To many of us in our algorithm design phase, use of tick data frame might appeal magically as opposed to traditional minute charts, we might feel what if it can give better accuracy in signals !

While a tick data may certainly be helpful in machine learning (ANN algorithms) for the fact that candles they generate are smoother and gradual hence the training of neural network can be made easy, but they are also crippled by multiple challenges inherent to tick data.

Tick data

Tick candles are highly sensitive to liquidity – take for example two options (strikes) of same instrument applied with 200 tick grouping chart, so you will signals at different time for those two strikes, whereas the spot movement could be advancing with its own pace.

Candlestick patterns – candlesticks patterns generated by ticks are not reliable and not may not come at the places when you expect them. this is mainly because tick traders working on market may be using any arbitrary number of tick grouping (like 20, 100, 200). so there is lack of agreement, whereas in minute chart options are limited.

In the light of above context, I did not see much use case of using tick data, other than for the traders doing scalping in ultra short time in forex market.