How to convert NSE indices CSV files to MS format

[saritguha]

Dear Gurus,
Can you suggest me how to convert NSE Indices historical data in metastock format? Any freeware available?
This data file is a bit different.

Sarit

 

[ravindrabhavsar]

Dear Gurus,
Can you suggest me how to convert NSE Indices historical data in metastock format? Any freeware available?
This data file is a bit different.

Sarit

yes pl contact me i will make s/w for u for free pl send me a data

 

[saritguha]

Currently I am following a manual method for this conversion.

The same is as follows:
Step 1: GO to www.nseindia.com > indices> statistics > Historical Data of NSE Indices; put the index name and from-to date. (See Step1.bmp)

Step 2: Download the CSV file created ( see S&P CNX NIFTY1320062032006samplefile.csv)

Step3: Convert the data to Metastock compatible format in XLS
The sample data format is S&P CNX.XLS.

Step 4: Convert this XLS by MS downloader.

Problem is each day I have to manually update CSV files for each targeted index, convert the same to XLS file and update.

Can the download and convert ( upto XLS) of selective indices be automated based on from and to date?

Regards,

Sarit

 

[kssoin]

Hi Saritguha,

Where did you get the MS downloader.

Regards
Karanbir

 

[totalbankrupt]

Dear Gurus,
Can you suggest me how to convert NSE Indices historical data in metastock format? Any freeware available?
This data file is a bit different.

Sarit

Check out www.getbhavcopy.com (Free NSE BSE data downloader)

 

[dawode]

how exactly you can convert
csv to txt ??

 

[totalbankrupt]

how exactly you can convert
csv to txt ??

There is no difference actually. CSV is also a TXT file with comma separated values.

All CSV files are tecnically TXT files, but all TXT files are not CSV files.

 

[dawode]

ok total
i just want an easy , fast , no cost way to ...
convert yahoo data which is .scv to .txt so....
i can convert .txt to ms format " metastock format"
is there a way ??
if the answer is no
is there easy , fast , no cost way to have meta stock data for all us stocks ,
i mean a way really work .....?
i'm really Tired ...
thank you

 

[kssoin]

Hello Dawode,

I have my data in a xls file then i run a VB code (i can send it to you) on running this code it asks the file name in which to save(it will save this data into a xxx.txt file (xxx is the name you selected). then it asks you for separator you select "," , then it creates a txt file with the data.
this is my email[email protected]
Regards
Karanbir

 

[Feel-me-knee]

ok total
i just want an easy , fast , no cost way to ...
convert yahoo data which is .scv to .txt so.... .... i mean a way really work .....?

FCharts SE from spacejock.com.au has a built-in yahoo importer. Ity can also import live data as well.

In addition, you can scan the data in many ways.