Re: Tick Data in Excel

[Efrain R Portales <efrain12@xxxxxxxxxxxx>]

Hi Neal,
Thanks a lot for your response.
These are the first rows of the CME's html file:

•Swiss Franc Futures
------------------------------------------------------


97 Sep


       Date      Time       Price
97-09  07/31/97  07:20:12   0066590 
97-09  07/31/97  07:20:27   0066580 
97-09  07/31/97  07:20:32   0066590 
.
.
.
.
( the last row repeats itself down to the end of file)


This is what I need in Excel 7 :


 Time       Price
 07:20:12   0066590 
 07:20:27   0066580 
 07:20:32   0066590  
.
.
.


Thanks again for your help.

Efrain R Portales
efrain12@xxxxxxxxxxxx