Download Nifty Future Historical Data And NSE BSE Bhavcopy For Amibroker

Download NSE Bhavcopy
Zerodha Account Opening Process With Aadhar Card
2017's Top 5 Stock Brokers In India For The Stock Market Newbie

In this post I will show you how to download Nifty future historical data (bhavcopy) as well as NSE BSE bhavcopy and import the data to Amibroker. We will use a small utility called GetBhavCopy by Hemen Kapadia to download the data. First download GetBhavCopy from end of this post.

Once you download the zip file save it to your computer and unzip the file. You will be able to see Getbhavcopy.exe file. I suggest you to create 3 folders: NSE, NFO and BSE in the same folder where actually we will download the bhavcopy.
GetBhavCopy Folder
Run GetBhavCopy.exe file. Click on OPTIONS. This will open the options for the software, this is a one time setup where you need to specify which data you will download and also the data download folders. On the GENERAL tab check IGNORE WEEKEND and click NEXT.
General Tab GetBhavCopy
Next tab EQUITY NSE is for NSE cash bhavcopy. Select your NSE bhavcopy download folder as shown below and click NEXT.
NSE Bhavcopy
Next tab EQUITY NSE is for BSE bhavcopy. Select your BSE data download folder as shown below and click NEXT. I do nkt download BSE data so I have not checked DOWNLOAD BSE DATA box.
BSE Bhavcopy
Next tab FUTURES NSE is for Nifty future historical data and other futures of NSE. Select your futures bhavcopy download folder as shown below and click SAVE.
Nifty Future Historical
Do your one time data setup is done. Now in GetBhavCopy window select the start date and end date of bhavcopy to be downloaded and click DOWNLOAD. This will start data download and once done message will come that DATA DOWNLOAD COMPLETE.
Now to import the data into Amibroker create a new database for NSE as shown below.
Amibroker NSE Database
Once the database is created click on IMPORT WIZARD.
Amibroker Import Wizard

Next window select PICK FILES and pick your bhavcopy files. I have selected NSE bhavcpy files but if you want to import BSE bhavcopy files select appropriate files. Click NEXT.
Amibroker Import Wizard Pick Files
In next screen select fields as TICKER, YMD, OPEN, HIGH, LOW, CLOSE, VOLUME and click MORE COLUMNS and add OPENINT (open interest). Open interest is important for futures such as Nifty future historical charts. Click NEXT.
Amibroker Import Wizard Define Fields
Now your bhavcopy will be imported into Amibroker and you can see end of day charts in your Amibroker.
Amibroker Nifty Future Chart
Remember, this data is not bonus OR split adjusted. So you need to give some extra time to make your data more perfect by adjusting bonus and split.

Download link of GetBhavCopy below:

If you want to use free web based real time and end of day charts, read: Get Web Based FREE Real Time Charts In Zerodha Kite.

Zerodha Account Opening Process With Aadhar Card
2017's Top 5 Stock Brokers In India For The Stock Market Newbie

Author Bio

Indrajit Mukherjee

Indrajit is a professional blogger and trading system developer. Amibroker expert, Wordpress expert, SEO expert and stock market analyst.Trading since 2002, he has started the journey of on 2008. He follows Indian and world stock markets closely.

Leave a Reply