How do view Option EOD Data in Excel

[smarttrade]

Dear All,
I am downloading Nse options Bhav copy Every day and saved all files in single Folder . I like to view particular strike price Data (Date,open,high,low,close) details in single excel page.

Example :-
Symbol - Strike price - optiontype - Trade Date - Open - High - Low - Close
Nifty 8000 put 08-May-15 95 95 57.85 68.95
Nifty 8000 put 07-May-15 111.9 142.5 94.3 14.35
Nifty 8000 put 06-May-15 37.25 115.2 37.25 106.8
Nifty 8000 put 05-May-15 32.1 49 30.3 35.75
Nifty 8000 put 04-May-15 55.05 60.45 32.2 35.9
Nifty 8000 put 30-Apr-15 64 81.45 53.1 65.15

Sample NSE Option EOD Bhav Copy File.
=========================

I want this Type :
===========

How to do this? Kindly Help.

 

[THETRADER]

Leave the bhavcopy aside.
Download Historical Contract-wise Price Volume Data. This will be under
Products -> Equity Derivatives -> Historical Data ....

That's it.

 

[optionwriter]

Leave the bhavcopy aside.
Download Historical Contract-wise Price Volume Data. This will be under
Products -> Equity Derivatives -> Historical Data ....

That's it.

useless information ?!!

 

[test123]

THETRADER is right

http://www.nseindia.com/products/content/derivatives/equities/historical_fo.htm

go there and download csv file it gives option to save....
Or just use copy paste option and paste in excel then keep only columns and open in amibroker

How to do this? Kindly Help.

just select columns u don;t need and delete entire columns ... u need to learn basic steap in excel