Results 1 to 3 of 3
Hi Experts,
I have .gz files which has data inside it like this:
Trade No. Symbol Instrument TradeDate ExpDate OptionType StrikePrice Time Price Qty
106263 NIFTY OPTIDX 1-Apr-2005 20050428 CE ...
- 09-11-2009 #1Just Joined!
- Join Date
- Sep 2009
- Posts
- 2
Not able to open .gz file
Hi Experts,
I have .gz files which has data inside it like this:
Trade No. Symbol Instrument TradeDate ExpDate OptionType StrikePrice Time Price Qty
106263 NIFTY OPTIDX 1-Apr-2005 20050428 CE 1940 12:36:06 108 1000
97100 NIFTY OPTIDX 1-Apr-2005 20050428 CE 1940 12:19:06 107 1000
64968 NIFTY OPTIDX 1-Apr-2005 20050428 PE 1930 11:10:35 14.95 400
74877 NIFTY OPTIDX 1-Apr-2005 20050428 PE 1930 11:30:24 13.45 800
There are more than 2 lakh such rows in a single .gz file, in each row fields delimited by "|" character.
I have to process the data contained in more than 2000 such .gz files. For each PE entry I have to find CE entry with matching TradeDate, ExpDate,StrikePrice, and Time difference of less than 30 seconds. In the output file I need such matching PE and CE in a single row.
Again,i use netbook Linpus Linux Lite is the OS, in that a program called Xarchiver easily decompresses the file.
Any hint how to open this file...
Regards,
Rafikul
- 09-11-2009 #2forum.guy
- Join Date
- May 2004
- Location
- arch linux
- Posts
- 17,779
Welcome to the forums!
Check out gzip and gunzip for file compression and extraction:
The gzip home pageCode:gunzip your_file.gz
oz
→ new users: read this first
→ no private messages requesting computer support - post them on the forums!
- 09-13-2009 #3Just Joined!
- Join Date
- Sep 2009
- Posts
- 2
Hi OZAR,
Thanks for the reply.
I already decompress the .gz file.But i am not able to see its content.After extraction i got the below information:-
Trade No. Symbol Instrument TradeDate ExpDate OptionType StrikePrice Time Price Qty
106263 NIFTY OPTIDX 1-Apr-2005 20050428 CE 1940 12:36:06 108 1000
97100 NIFTY OPTIDX 1-Apr-2005 20050428 CE 1940 12:19:06 107 1000
64968 NIFTY OPTIDX 1-Apr-2005 20050428 PE 1930 11:10:35 14.95 400
74877 NIFTY OPTIDX 1-Apr-2005 20050428 PE 1930 11:30:24 13.45 800
Kindly give me some hint so that i am able to process the data.
Regards,
Rafikul


Reply With Quote
