Getbhavcopy: Free NSE and BSE data downloader

Hi friends,

I am trying to use Amibroker for chart analysis- EOD with NSE data from Getbhavcopy.

I have created database named NSE in local drive at

C:\Program Files\AmiBroker\Bhavcopy\NSE.

Next,

I am trying to import NSE EOD data after following all the instructions provided in the getbhavcopy documentation including creation of  GetBhavCopy.format.

Although I have added code in the last line of  import.types as below

GetBhavCopy format (*.txt)|*.txt|GetBhavCopy.format

Error is

"Logging started for 'C:\Getbhavcopy\NSE\2008-12-15-NSE-EQ.txt' file, using format definition file 'Formats\default.format'

Error in line 3IINFOTECH,20081215,36,41,35.1,39.3,1146353,0

Invalid date format/value."

Can someone help me with the exact procedure in case I am missing any point.

I am not an Amibroker expert but I think you are missing the following step in the very last part of the documentation while importing the data.

• Select 'File of Type' as Getbhavcopy Format (*.txt)
  

Hi Hemen,

Thanks for your feedback. It helped me to some extent. However still after following all the necessary steps no chart was displayed.

Then I had a workaround...

In addition to instructions provided by Abhay

"Create a new text file called 'GetBhavCopy.format' in\Amibroker\Formats directory using notepad. Paste the following codeinto it and save the file."

Instead I copied a existing *.format file in folder AmiBroker\Formats. Say I copied file aqb.format and renamed it to GetBhavCopy.format.

Now next I replaced the entire code provided by Abhay in this file and saved.

After that all other instructions remaining same, I was able to successfully import data files for NSE and the charts were been displayed.

I hope this will help to other forum members if they are stuck with same problem.

Hi Prashant and Hemen,

After following all the instructions given by you guys, even the changes Hemen mentioned herein, i could not open any charts as such, it says

NOT ENOUGH DATA AVAILABLE

TO PLOT ANY CHART AT LEAST 3 DATA BARS ARE NEEDED,BUT THERE ARE ONLY 1 BARS in '20MICRONS"

Please help me with the same.

That could be because you have just imported data for 1 days in Amibroker. Try to download the histoical data (search forums for ASCII data), and import it into Amibroker.

You should be good then.

Prashant at May 8, 2009 at 2:19 PM

Hi friends,

I am trying to use Amibroker for chart analysis- EOD with NSE data from Getbhavcopy.

I have created database named NSE in local drive at

C:\Program Files\AmiBroker\Bhavcopy\NSE.

Next,

I am trying to import NSE EOD data after following all the instructions provided in the getbhavcopy documentation including creation of  GetBhavCopy.format.

Although I have added code in the last line of  import.types as below

GetBhavCopy format (*.txt)|*.txt|GetBhavCopy.format

Error is

"Logging started for 'C:\Getbhavcopy\NSE\2008-12-15-NSE-EQ.txt' file, using format definition file 'Formats\default.format'

Error in line 3IINFOTECH,20081215,36,41,35.1,39.3,1146353,0

Invalid date format/value."

Can someone help me with the exact procedure in case I am missing any point.

You need to select the file type as not default. but GetBhvCopy type.

This will solve your problem.

Please read the error message properly.

Hi all,

I have been using GBC quite for some time and it works without any problems, including importing into Amibroker.

I give below the format file I use which is in line with options chosen by me within GBC.

Users may read footnotes and change the lines given below as per my the options chosen by them within GBC. The modified text may be saved with filename mygbc.format and be placed into the Formats folder of Amibroker.

For 'Enable output header' option, please ensure to select the same option (checked or unchecked) in all the 3 modules of NSE stocks, NSE Futures and BSE stocks, otherwise you may have to use different format files for each.

(In a subsequent revision, Hemen may please look into the possibility of shifting 'Enable output header' option to global level at the first options tab, so that users may choose only one option for all the three files.)

===============================================

# Format definition file generated automatically

# by AmiBroker's ASCII Import Wizard

$FORMAT Ticker, Date_YMD, Open, High, Low, Close, Volume, OpenInt

$SKIPLINES 0

$SEPARATOR ,

$DEBUG 1

$AUTOADD 1

$CONT 1

===================================================

1&2) The first two lines may be left as they are.

3) In the third line we specify that the data is in the specified order, which is in line with the GBC data order. Whether OpenInterest option is checked or not, this line may be left untouched. Fortunately even if OpenInt is NOT there, AB does not report an error and the import is error free.

4) This line needs no change if 'Enable output header' is option is NOT checked.

If 'Enable output header' is option is checked, replace the line with:

$SKIPLINES 1

(Please ensure that chosen option is same in all the THREE modules. Otherwise, you need separate format files for different options.)

5) This line specifies that the field separator is a comma, and matches with GBC data. Needs no change.

6) By this line, after import of each file into AB, opens a dialogue box showing the number of import errors with an option to view them. Leave this line as it is and make it a practise to view the import errors after import of each file.

7) By the AUTOADD option newly added symbols are automatically added into the database. If any user wants to use some fixed list of stocks and does not care about the rest, then only the line may be changed to:

$AUTOADD 1

This is a continuous quotation flag and may not be changed.

The import process is just as given by Hemen at:

http://www.getbhavcopy.com/importingtoamibroker.htm

I hope this write-up will help users to experience GBC & AB to the fullest extent.

This is my way of thanking hemen for making available the great software GBC.

Regards.

murthymsr