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
[wp_ad_camp_5]

 
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
[email protected]

How Geopolitical Tensions Impact Stock Markets: A Closer Look

Geopolitical tensions have always had a significant influence on the global economy, particularly on stock markets. Investors, both individual and institutional, closely monitor these...
Rajandran R
2 min read

What Traders/Investors need to know about Hypodermic Needle Theory

The Hypodermic Needle Theory, also known as the Magic Bullet Theory, is a communication theory that suggests that media messages are injected directly into...
Rajandran R
2 min read

How to Get Futures and Options Data and Commodities…

In this blog, we will explore how to use Algomojo to get futures and options data and commodities data into Google Spreadsheet, step by...
Rajandran R
4 min read

Leave a Reply

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