The script takes as input a CSV [url removed, login to view], which represents a financial time series for a futures contract. It outputs the same file to a new directory "OutputDirectory", but appended with a new field which represents the delivery month:
1) The first line is a a header, which will look something like this:
This needs to be changed to
Date,Time,Open,High,Low,Close,Volume, Delivery Month (YYYYMM)
2) We need to first work out the delivery month. This can be discovered from the file name. The file name will look something like @VXF10_5.csv. The crucial part is the final letter and number "F10".
The F represents the month - see [url removed, login to view]
The 10 represents the year.
Thus for @VXF10_5.csv. our delivery month should be 201001
For @[url removed, login to view] our delivery month should be 201406
Each line of the file represents the data: e.g:
We simply need to append each line with the correct delivery month!
Hi, This is my first project. Please give me a chance to prove my self. I am not bothered of money here. Thanks. Hope I will get this project. I will make it available to you with in no time.
21 freelancers are bidding on average $24 for this job
nice quickie to work on... :) Might really not matter here, but generally it would be a good thing to mention on what OS platform you intend to run the script. Thank you.
Hello, I am an experienced Perl Developer (5 years). I can deliver the script to you within a day. Completed some good Perl Projects recently with good feedback from employer. Thanks Raj
Hi, expert web/data scraper here with over 17 years experience in programming and RDBMS - please see my reviews. I'm using Perl for this kind of jobs. I'm able to extract data fast.