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.
Just use it then import it into Ami , while importing thru Import Wizard, in Import Wizard set Column 2 as "YMD" ( i.e. year month date) and rest you all know very well.
If any probs then let me know.
Regards
Aaplana
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.
Just use it then import it into Ami , while importing thru Import Wizard, in Import Wizard set Column 2 as "YMD" ( i.e. year month date) and rest you all know very well.
If any probs then let me know.
Regards
Aaplana