Use the link given 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.
Here is a initiative from me to automate the NSE EOD data in ASCII format using simple VBA Scipts in MS Excel. The following MS Excel VBA macro copies the Getbhavcopy zip file corresponding to 02Nov2010 from NSE India portal into your local drive(c:\eoddata) and then extracts the Zip file and shows you the content in the csv file.
Here is a simple Web Query Based Excel Spreadsheet, Which converts your MS Excel into Dynamic Nifty Heat Map with an auto update of every 1 minute from the source Buzzing Stocks Conditional Formatting is then applied to the resulting Web Query to Detect positive and negative stocks for the day and are highligted […]