Import forex data

Looking for someone to write a script to:

- download historic GBP/USD forex data from here: [url removed, login to view]

- turn it all into the same format - for example, a line from week 1 2008 looks like this (the fields are ID, currency pair, date/time, buy, sell, not quite sure)

368414365,GBP/USD,2007-12-30 17:22:15,1.995400,1.995900,D

but by the time you're at week 4, it's in unicode..

- send me one (huge) CSV file of the cleaned-up data, and the code used to generate it.

The way I'd approach it would be:

- write something to download and extract data from all the ZIP files

- think of a regex that we'd like everything to conform to:

/^[0-9]+,GBP/USD,[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}:[0-9]{2}:[0-9]{2},[0-9.]+,[0-9.]+,.*$/ might do, although I just wrote that; it's untested; it might be wrong..

- write something to go through each file, stopping when it finds a line which doesn't match

- add something to it to do whatever's needed to that line to make it match

- repeat until all the data's transformed so that it matches

and you're done.

Here's someone complaining about the problems with this data:

[url removed, login to view];task=view&id=2355

Don't worry about gaps or overlaps - I just need it all bashing into a consistent format.


Skills: Perl, PHP, Python

See more: import forex data php, regex matches example, regex matches, regex in c, regex example, regex c, problems with match, perl script to zip files, pair line, match problems, format ratedata gaincapital historic, ratedatagaincapitalcom file format, data forex csv, forex data csv, forex csv review file, import forex data money, import gbpusd csv files, forex data import, ratedata gaincapital data format, ratedatagaincapitalcom csv, extract forex data, import forex data, ratedatagaincapitalcom format, regex &, Regex

About the Employer:
( 9 reviews ) London, United Kingdom

Project ID: #240518

9 freelancers are bidding on average $164 for this job


Can help... check my reviews... costs more...

$250 USD in 5 days
(27 Reviews)

We can do it, we have expertise and experience on csv formating for common pattern. Such as, click-bank, networkaddons, trafficvance etc. has been formatted in one common format, either csv or db. Escrow needed. Thanks More

$200 USD in 3 days
(82 Reviews)

I can do it. have huge experience in data extraction also advance in regular expression (regex). ready for your work.

$200 USD in 3 days
(42 Reviews)

Hi! Hope you'll consider me for the project. I'm a PHP/MySQL developer with over 7 years experience and I'm also in charge of a team of over 20 web-designers and developers with diverse skills, so you can be sure I More

$150 USD in 2 days
(4 Reviews)

Hi, please check PMB.

$250 USD in 7 days
(1 Review)

Please, check PM.

$150 USD in 9 days
(4 Reviews)

Hi, Check PM

$100 USD in 5 days
(1 Review)

Hello, data scraping/extracting processing and analysis is my favorite work. I have my own java based code base for scraping that just need to be fine tuned for your data and requirements and work is done. regards, pa More

$100 USD in 2 days
(1 Review)

hello, we CAN start now?

$80 USD in 2 days
(0 Reviews)