Hi,
Found myself a solution for the same.
Go to hxxp://www.nationalspotexchange.com/Sitepages/MarketMaster.htm?pg=13
- Select "DateWise"
- Select Asset Name : All
- Select Commodity Symbol : All e-series (see attached image)
- Click "GO"
- From the report screen, "Export To Excel option" to download the bhavcopy in csv format.
Now preparing the downloaded csv for Amibroker import using getbhavcopy downloader data format(hxxp://www.getbhavcopy.com/importingtoamibroker.htm)
Format
Ticker,Date_YMD,Open,High,Low,Close,Volume,OpenInt
1. Open the csv in excel
2. Delete column "Asset Name"
3. Cut and paste "Product Name" column as the first column.
4. Highlight the date column, right click and select "Format cells", select "Custom" as category, under "Type" write "yyyymmdd" and click OK.
5. Replace all "GRAMS" and "KGS" in Trade Volume column with blank (highlight column, use find and replace, replace column keep blank)
6. Cut and paste "Turnover (Rs. In Cr)" as the last column.
7. Replace all values in the above column with 0.
8. Delete all headings
9. File > Save as > File name:desired filename.txt > Save as type : CSV (Comma delimited).
10. Import using Amibroker "import ASCII" option.
Also find the link for NSEL e-series bhavcopy formatted for Amibroker import (from 17-03-2010 to 18-05-2012)
hxxp://www.4shared.com/office/rq-5nQ8n/BhavCopyHistoricalData_17-03-2.html