Merge Indices & Bhavcopy text files into One text file

36 sec read

Use the link given below to access the Excel VBA that will merge different EOD Indices files to the main Bhavcopy file. This is a temporary arrangement till the GetBhavCopy gets in order.

Download Merge Indices & Bhavcopy Excel Macro

This follows the naming convention of the indices as per the GetBhavCopy format (i.e. S&P CNX NIFTY will be found as NSENIFTY and so on). Instructions are marked inside the file itself. Still if you face any problem or have any suggestion, do post your problems here.

1)Create the following folders “C:Data DownloaderNSE EOD” and “C:Data DownloaderMerge NSE EOD Files”
2)Open Data Downloader
3)Set the EOD “Select Data Path” to “C:Data DownloaderNSE EOD”
4)Run “Data Downloader” to generate both “Bhavcopy” and “Indices” text files
5)Run the Macro in Blue Arrow

Getbhavcopy format – 03 Nov 2010 NSE EOD Data

Rajandran, thanks a lot for giving me this space to share it. You are doing a great job!

Rajib Lochan Sarkar
[email protected]

Febinars Platform Now Open to Angel Broking Users

We are proud to provide our Febinars Platform access to Angel Broking users. Febinars is an online learning platform for professional traders. It's the...
Rajandran R
42 sec read

How to Get Futures and Options Data and Commodities…

We know that google spreadsheets support an inbuilt function google finance to fetch real-time stock quotes for Equities markets. However, do you know how...
Rajandran R
7 min read

Worldwide Surge in Trading Accounts During this Pandemic

Flood of new retail traders flocking into the stock market and most of the brokerage firms across the world reporting surge in trading accounts....
Rajandran R
44 sec read

Leave a Reply

Get Notifications, Alerts on Market Updates, Trading Tools, Automation & More