Help getting web data into excel...

H

H2O

OK, I've given up...

This should be really simple:

LIFFE updates the settlement prices every day on their website, and I would like to get them into an EXCEL sheet.

http://www.liffe.com/data/dfut070104.txt
(example for todays file)

If I use the web query, the formatting is all messed up...
I only need the SETTLEMENT price for all contract months of Euribor to start (I can figure the rest out myself)

I think the easiest way is to read the entire form in a sheet , and than read the data that I need into another sheet, however, it would be easier if the data would be in separate columns, and that is what I cannot get done...

Any help?
 
Save the file somewhere on your disk as a txt file.
Open up Excel.
Open the file you just saved as a Files of Type: Text Files.
Text Import Wizard will appear.
Choose to open as a Fixed width file.
Press next and finish. That’s all.
 
This will give me the same results as the web query.
I need to read some data from it, and all the data is parsed into one column (For some reason this file is hard to read)
 
You must log in or register to reply here.
Back
Top