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.

Instructions
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!

Regards,
Rajib Lochan Sarkar
lochan79@gmail.com

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

Things you need to know about Vedanta Delisting

On 12th May 2020, Vedanta India came up with a delisting offer priced at ₹87.5 per equity share. Ahead of the announcement, the company’s...
Rajandran R
1 min read

Know Your Implied Volatility

Implied volatility (IV) is a very important measure if you are trading options. It helps traders to understand the overall market expectation. ...
Rajandran R
1 min read

Leave a Reply

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