AMIBROKER IEOD Database (01 Sep 08 to 15 Dec 09)

findvikas

Well-Known Member
#1
This will probably make your life easy for all fellas looking for FREE IEOD data.
I have collected this IEOD data (1min Interval) since 1st September 2008 till date (15 Dec 09) and imported all the CSV into AMIBROKER

This entire database is built on the data taken directly from InvestBulls.

Usage
1) Download the file below and extract it to some folder
2) Open Database from AMIBROKER and select the folder

I have adjusted most of the scrips for Bonus/Splits (that I could remember) but if you find some scrip which is not adjusted then please adjust it accordingly.

Next steps..

Ok, since you have an Intraday EOD database with 1min interval which is good but what about updation of this database?

Preferred way

Use this utility that I created for the sole purpose. I created this tiny utility to automate the process of downloading all the IEOD data files from Invest Bulls's servers and extract them as well to the folder you specify.





I am yet to code the automatic import feature for the AmiBroker which I am not expecting to complete until next month as I may not get time after today :)



I am very much expecting bugs as this was all done in just 2hours... please report them to me.


Manual Process
If the above automated method does not work for you, then go and do manually this way.

Every evening around 6-7pm go to this link (remove spaces)
h t t p : / / w w w . investbulls.com/e107_files/downloads/IntraDay/YYYYMMDD.zip

YYYY = Year (ie. 2009)
MM = Month (ie. 01-12)
DD = Date (ie. 01-31)
Format File for updating database
1) Copy this code

From today (25 March 2010) InvestBulls changed the format of their files...

here is the new format...

Code:
# Format definition file generated automatically
# by AmiBroker's ASCII Import Wizard
$FORMAT Date_YMD, Time, Open, High, Low, Close, Volume
$SKIPLINES 0
$SEPARATOR ,
$CONT 1
$GROUP 255
$AUTOADD 1
$DEBUG 1

OLD FORMAT... before 25 March
Code:
# Format definition file generated automatically
# by AmiBroker's ASCII Import Wizard
$FORMAT Ticker, Date_YMD, Time, Open, High, Low, Close, Volume, Skip, Skip, Skip, Skip
$SKIPLINES 0
$SEPARATOR ,
$CONT 1
$GROUP 0
$AUTOADD 1
$DEBUG 1
2) Save it to the following file (change the path to reflect your AMI installation)
C:\Program Files\AmiBroker\Formats\NSE_IEOD.format

After you create a NSE_IEOD.format file under C:\Program Files\AmiBroker\Formats

Then open a file import.types (using notepad) under the directory C:\Program Files\AmiBroker\Formats and add the below line

NSE_IEOD format (*.txt)|*.txt|NSE_IEOD.format


Updating the database
1) Download the zip file and extract to some location
2) Start AmiBroker and go to File->Import Ascii
3) Choose "NSE_IEOD" as file format (see above for this format file)
4) Browse to that folder where you extracted it all, and select all files.
5) Hit OK and you are done for that day.
6) Repeat it daily in the evening and you should be good.




Download Files:

AmiBroker Database
Rapidshare: http://rapidshare.com/files/321349586/IEOD_01_Sep_08_to_15_Dec_09.rar
MegaUpload: http://www.megaupload.com/?d=FYDWVNGR


Automatic Download of Data from Invest Bulls
Rapidshare: http://rapidshare.com/files/352862073/IB_IEOD_Downloader.zip
Megaupload: http://www.megaupload.com/?d=7W5SB1QA
 
Last edited:

Raju

Well-Known Member
#3
Hey Vikas,
You read my mind buddy.Before asking what I need u have already posted ..
Great , Thanks,

Raju
 
#4
Hello findvikas and all IEOD data users from Investbulls,

I have a correction to the format file code given by findvikas. The following is the correct one. It is not OpenInt, but Open.


PHP:
# Format definition file generated automatically
# by AmiBroker's ASCII Import Wizard
$FORMAT Ticker, Date_YMD, Time, Open, High, Low, Close, Volume
$SKIPLINES 0
$SEPARATOR ,
$CONT 1
$GROUP 0
$AUTOADD 1
$DEBUG 1
Thanks
 

rohangawale

Well-Known Member
#6
Hi Vikas,
I have downloaded Amibroker Ver 5.2
and the 1min data given by you.
but i have never used amibroker before so dont know anything abt it.
can you pls tell me where the code given by you should be pasted and how to load the 1min data??
i tried something but was not successful in doing it,
can u pls explain.

Thanks in advance
 

findvikas

Well-Known Member
#7
Hi Vikas,
I have downloaded Amibroker Ver 5.2
and the 1min data given by you.
but i have never used amibroker before so dont know anything abt it.
can you pls tell me where the code given by you should be pasted and how to load the 1min data??
i tried something but was not successful in doing it,
can u pls explain.

Thanks in advance
1) Open notepad and paste the content of the format in there
2) Save the file to following file (make sure to double quote the file name)
"C:\Program Files\AmiBroker\Formats\NSE_IEOD.format"

Also make sure that you have amibroker installed in the C:\Program Files\AmiBroker folder, it might be in C:\Program Files (x86)\AmiBroker\ folder if you are running 64 bit version of Windows

3) Next thing is to open the AmiBroker, File->Open Database and select the folder where you downloaded & extracted the database

4) It should load the database and show you the content
5) Go to Tools->Preferences->Data and click on "Current" to make sure that current loaded database is loaded automatically the next time you restart AmiBroker

6) Now to import the files.. follow as I said above.


Hope that makes it clear?
 

rohangawale

Well-Known Member
#8
Thanks a lot Vikas for the instant reply.
will try the above procedure and let you know the result.

appreciate your willingness for prompt reply so before extracting data only thanked you.
 

rohangawale

Well-Known Member
#9
Hi Vikas
Can you pls tell one more thing,
ver 5.2 which im using, in that we can see intraday chart also if we have rt data??
as in metastock ver 9 which im using im not able to see tf less than daily
 

rohangawale

Well-Known Member
#10
1) Open notepad and paste the content of the format in there
2) Save the file to following file (make sure to double quote the file name)
"C:\Program Files\AmiBroker\Formats\NSE_IEOD.format"

Also make sure that you have amibroker installed in the C:\Program Files\AmiBroker folder, it might be in C:\Program Files (x86)\AmiBroker\ folder if you are running 64 bit version of Windows

3) Next thing is to open the AmiBroker, File->Open Database and select the folder where you downloaded & extracted the database

4) It should load the database and show you the content
5) Go to Tools->Preferences->Data and click on "Current" to make sure that current loaded database is loaded automatically the next time you restart AmiBroker

6) Now to import the files.. follow as I said above.


Hope that makes it clear?
After doing all the things till step 5, it shows automatically 1st chart.
but when i close amibroker and runs it again, it hangs up and nothings moves unless i close it. then its continous hanging whenever i open amibroker.