Friday, November 16, 2012

Import of IEOD/EOD data to Amibroker using Import Wizard



Import of data 

Data in text formats can be easily imported into amibroker using either the 'Import Wizard' or or 'Import ASCII" method.

Using Import Wizard
Click on File > Import Wizard




 In the 'Select file to import' dialogue box, click on 'Pick files'.






Select the text format file to be imported, click on 'Open'.





The 'Select files to import' dialogue box will now show the path to file selected by you for importing. Click on ‘Next’.




This brings us to 'Define fields' dialogue box. Here the fields of the data file are shown in the 'Data file sample:'. The example of the NIFTY_F1 intra-day data for 01NOV2012 shown here has following fields separated by comma:
Ticket, Date in YMD format, Time in HMS format, Open, High, Low, Close & Volumes. Please select the headings in the same sequence under Column1, 2 etc., e.g., select Ticker from the drop down list for Column 1, select YMD in column 2 and so on.


We have only 7 columns here, but the file to be imported has 8 fields, so put a check mark in 'More columns'. This will give you the option of 5 more columns, use the one you require and select ‘Skip’ from the dropbox for the rest. Now click on 'Next'

In 'Additional settings' dialogue box which follows, you can save the format of text file you just imported by putting a check against 'Add current settings to ASCII importer definitions' and giving a name against Format file name. This will speed up the process of importing files with similar format in future. Click on 'Finish'. The data has now been imported, click on the charts and verify.



Using Import ASCII
This is a fast method provided that you have given a name to the file format you used in the above method and are importing the same type of file again.



Click on File > Import ASCII



This will bring out the open file dialogue box. The 'Files of type' box here will include the name under which you saved the file format in the above method. Select any file of that type and click on 'Open'. This will import the data into Amibroker.

Link : http://www.tradewithme.me/data-archives-for-technical-analysts.html

       
Nifty Spot 1st January 2008 onwards
Nifty Futures 1st Januray 2008 onwards
Banknifty Spot 1st March 2010 onwards
Banknfity Futures 17th July 2009 onwards
IndiaVIX 27th October 2010 onwards

Format for index data - Ticker, YYYYMMDD, Time, Open, High, Low, Close
Format for future data - Ticker, YYYYMMDD, Time, Open, High, Low, Close, Volume



Link : https://docs.google.com/folder/d/0B8e3dtbFwQWUZ1I5dklCMmE5M2M/edit

NIFTY-I and  BANKNIFTY-I
Link : https://docs.google.com/file/d/0B0yN1ko0ua9Ha1dUaDExVm84SkU/edit


NSE DATA









No comments:

Post a Comment

Powered By Blogger And Premium Template By Lord HTML