Dear Friends,
I have small utility in Excel sheet.
(1) NSE_BHAV
(2) NSE_PR_DAILY
NSE_BHAV: It will convert directly
cm01NOV2010bhav.csv.zip into a *.txt file retaining columns Ticker, Date, Open, High, Low, Close, Volume for all equities.
NSE_PR_Daily: First download PR.zip from nseindia.com unrar it.find file
Pd011110.csv , NSE_PR_DAILY will convert it into *.txt file having columns Ticker, Date, Open, High, Low, Close, Volume for
Indexes and all Equities.
.........................
Dear aaplana your NSE_BHAV is not working. It display 'runtime error 91' while clicking Convert and selecting the downloaded bhavcopy from NSE.....