Tuesday, September 29, 2020

How To Export Intraday Amibroker Data: Amibroker AFL To Export Intraday Data

Many times we like to backup Amibroker database for use in times of contingency where due to some technical reason we might lose the database in Amibroker which we had saved in a long period of time. This becomes all the more important in case of real-time intraday data.

For this very reason there is an Amibroker AFL to export data from Amibroker. Intraday Amibroker data can be exported in chosen timeframes like one minute, three-minute, five-minute, 10 minute, 15 minute and so on. Some users need the database in .csv format and some others in .txt format. For this very reason I am uploading here the Amibroker export data AFL for both kinds of formats. You may like to use any one of them as per your preference.

To make things easier I'm posting screenshots of the process to export intraday data from Amibroker through the use of this Amibroker AFL. First you will have to place the Amibroker AFL in the Formulas folder of your Amibroker directory. Then you will have to create a folder where you would like to save the exported data. In case of this AFL the folder used is C://SaveData. If you like to choose some other folder then you will have to make changes in the export intraday data Amibroker AFL.

For understanding the process of intraday data export from  Amibroker please go through the images posted below. You can find the download link below the Images.

Amibroker AFL To Export Intraday Data







Amibroker AFL To Export Intraday Data






Amibroker AFL To Export Intraday Data






Amibroker AFL To Export Intraday Data






Amibroker AFL To Export Intraday Data







Export Intraday Data From Amibroker AFL V1.0
 
 
The new V2.0 is for Amibroker 6.30 as many users were asking for the same.
This version also includes Export of Open Interest in the Last Column.

11 comments:

  1. As i click on SCAN, I get thefollowing error: Error 61. The number of format specifier(s) (%) does not match the number of arguments passed.

    Kindly help

    ReplyDelete
    Replies
    1. Hi Amit,

      Which version of Amibroker are you using ?

      Delete
    2. The error is in line 23. If you change it to ds = StrFormat("%02.0f-%02.0f-%02.0f,",
      it should work fine

      Delete
    3. Hi ,

      Thanks for your input. I hope that Amit Saini get out of the trouble he is facing with your help.

      Delete
  2. I am also getting same error & using ami 6.30 version .
    Kindly help ...

    ReplyDelete
    Replies
    1. It seems that the error is happening due to higher version of Amibroker. I am currently not using 6.30 and so not able to really make out if this is the real reason. Till version 6.00 I am sure that this AFL works flawlessly.

      Delete
  3. Hello Trade Catcher,

    The script worked perfectly fine.
    However it is showing only Close Data.
    It is Not showing Open, High & Low data.
    Any idea why this would be happening ?

    Regards

    ReplyDelete
  4. Replies
    1. Hi Renu,

      Will look into the AFL if this could be done. Will update the afl if the open interest thing is done.

      Delete
  5. After i click scan, my file data is still EOD data, not Intradaydata

    ReplyDelete

Required US Government Disclaimer & CTFC Rule 4.41

Futures trading contains substantial risk and is not suitable for every investor. An investor could potentially lose all or more than the initial investment. Risk capital is money that can be lost without jeopardizing ones financial security or lifestyle. Only consider risk capital that should be used for trading and only those with sufficient risk capital should consider trading. Past performance is not necessarily indicative of future results. CTFC RULE 4.41 – HYPOTHETICAL OR SIMULATED PERFORMANCE RESULTS HAVE CERTAIN LIMITATIONS. UNLIKE AN ACTUAL PERFORMANCE RECORD, SIMULATED RESULTS DO NOT REPRESENT ACTUAL TRADING. ALSO, SINCE THE TRADES HAVE NOT BEEN EXECUTED, THE RESULTS MAY HAVE UNDER-OR-OVER COMPENSATED FOR THE IMPACT, IF ANY, OF CERTAIN MARKET FACTORS SUCH AS LIQUIDITY. SIMULATED TRADING PROGRAMS IN GENERAL ARE ALSO SUBJECT TO THE FACT THAT THEY ARE DESIGNED WITH THE BENEFIT OF HINDSIGHT. NO REPRESENTATION IS BEING MADE THAT ANY ACCOUNT WILL OR IS LIKELY TO ACHIEVE PROFIT OR LOSSES SIMILAR TO THOSE SHOWN. All trades, patterns, charts, systems, etc., discussed in this website or advertisement are for illustrative purposes only and not construed as specific advisory recommendations. All ideas and materials presented herein are for information and educational purposes only. No system or trading methodology has ever been developed that can guarantee profits or prevent losses. The testimonials and examples used herein are exceptional results which do not apply to average people and are not intended to represent or guarantee that anyone will achieve the same or similar results. Trades placed on the reliance of Trend Methods systems are taken at your own risk for your own account. This is not an offer to buy or sell futures interests.