Using code: 1. Unzip many csv files 2. Re-format some data with using simple logic 3. Append results to MS Access Table

1 If string "Cash" (any case) occurs in the filename skip file 2 If string "Front" (any case) occurs in the filename OR INSIDE THE FILE skip file 3 Files contain these cols Date Delivery Open High Low Close Volume Open Interest Total Volume Total Open Interest Perform following steps then append data to table tblFuturesEODData in the attached MS Access mdb file 4 Reformat the data in the Col 1 (Date) from yyyymmdd to mm/dd/yyyy and map it to [url removed, login to view] ex: 20000103 = 01/03/2000 5 Parse data in column 2 (Delivery) from yyyymm to yyyy and map it to [url removed, login to view] ex: 200001 = 2000 6 Parse the data in column 2 (Delivery) from yyyymm to mm and map to [url removed, login to view] ex: 200001 = 01 7 Search header lines of each file above the csv data for the line that contains string "Historical Data". ex: Eurodollars (3 month) Historical Data Index 8 For the line containing string "Historical Data" set variable X = entire line excluding the string "Historical Data" ex: Eurodollars (3 month) Historical Data Index = Eurodollars (3 month) Index 9 Map variable X to [url removed, login to view] 10 Map Col 3 of the csv file to [url removed, login to view] 11 Map Col 4 of the csv file to [url removed, login to view] 12 Map Col 5 of the csv file to [url removed, login to view] 13 Map Col 6 of the csv file to [url removed, login to view] 14 Map Col 7 of the csv file to [url removed, login to view] 15 Map Col 8 of the csv file to [url removed, login to view] 16 Map Col 9 of the csv file to [url removed, login to view] 17 Map Col 10 of the csv file to [url removed, login to view] 18 Set [url removed, login to view] = "Normans "& filename ex: filename = [url removed, login to view] [url removed, login to view] = Normans [url removed, login to view] 19 Set [url removed, login to view] = systime hh:mm:ss 20 Set [url removed, login to view] = sysdate mm/dd/yyyy 21 Create log of text data that was not appended The file was compressed using winace

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):

a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

XP MS Access

Ingegneria Microsoft Access MySQL PHP Architettura Software Testare Software

Rif. progetto: #3069792

Info sul progetto