Saturday, October 15, 2016

How To Import Intraday Data Into Amibroker

A step by step tutorial on How to Import Intraday Data into Amibroker. To be specific this post is in relation to import of intraday data into Amibroker which is available on this blog which you can find here. The process of import of Intraday End of Day Data IEOD into Amibroker remains more or less same but in this post I am giving the format files needed for the posted data and also the code required to be implemented in the import.types file.

First Download these two format files needed for the data available on this Blog. Some data is available in csv format , some other are available in txt format , thats why the two format files.

Link for the file named IEOD TXT 

Link for the file named IEOD CSV

Also note these two codes which are to be added in the IMPORT.TYPES file in the format folder. The images below will show in detail.

----------------------------------------------------------
IEOD TXT Format (*.txt)|*.txt|IEOD TXT.format

IEOD CSV Format(*.csv)|*.csv|IEOD CSV.format
-----------------------------------------------------------

So first we begin with the first step of setting up a new database in Amibroker:

How to Import Intraday Data Into Amibroker


To import the intraday data into amibroker we first need to create an intraday database in Amibroker with compatible settings for the intraday time frames.

How to Import Intraday Data Into Amibroker

Few settings for the Intraday Database which will be required to implement for smooth functioning of the charting platform.

How To Import IEOD Data In Amibroker

The data which is available for download at this blog is for Nifty related instruments. However if we can get Commodities data and want to integrate that into the same database then in Intraday settings we will have to make a few modifications in the timing of the exchanges. This will be shown in the below image

How To Import IEOD Data In Amibroker

Very important step which now comes is that you have to place the above given format files viz. IEOD TXT and IEOD CSV in the folder shown in the image given below.


How to Import Intraday Data Into Amibroker


Also notice the IMPORT.TYPES file already available in the Formats Folder. In this File you will have to add two lines of small code for both CSV and TXT formats.

IEOD TXT Format (*.txt)|*.txt|IEOD TXT.format
IEOD CSV Format(*.csv)|*.csv|IEOD CSV.format

How To Import IEOD Data Into Amibroker

After completing the above steps required for the process of data import now we will begin the process of the data import step by step. As the data formats have been placed already in the formats folder and changes made in the Import.Types file therefore we do not require to use the Import Wizard option. Rather we would use the Import ASCII option.

How To Import Intraday Data Into Amibroker



How To Import IEOD Data Into Amibroker


How To Import Intraday data Into Amibroker


How To Import IEOD Data In Amibroker


How To Import Intraday Data Into Amibroker

Select the files to be imported and click open. Amibroker will import the data swiftly.

This completes the whole process of the steps needed to Import Intraday Data Into Amibroker.

2 comments:

  1. hi sir can we combine ieod and eod database then what setting we do for that pls thanks

    ReplyDelete
    Replies
    1. There is a process to do so but I would suggest you to keep a backup of your data first then try these settings as even a small error can waste lot of time in correcting the data.

      In database settings there is an option to select combining of EOD & Intraday data.

      Refrain from doing so if you do not have backup of data.

      Happy Trading

      Delete

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.