In Progress

FTP File Download, Parse and Store to DB

The Chicago Mercantile exchange (CME) maintains an FTP site. One of the files available on the site provides a summary current trading day's prices for their futures products, e.g. Open, high, low, close, settlement.

ftp://[url removed, login to view]

We seek to develop a Windows console application that will periodically download this file, parse the trade information from it, and store that information into a single table of a SQL Server database. The project is to be developed using C#.

Project Specifics:

The URL of the ftp site is configurable. The time at which the application retrieves the file from the ftp site is configurable, as a list of time-of-the-day. The topic symbols to parse are configurable as a list of strings. Standard .NET [url removed, login to view] should be used for configuration.

The application runs continuously, being closed via ctrl-c or the closing of the host console window.

When the file is read from the FTP site it is saved into a specified directory location and given a name that reflects the download date and time. Trade price information is parsed from the file for the specified topics i.e. symbols. This information is compared to that which is stored in a table of a SQL 2012 database, and if updated information is available, it is written into that database. If the information is not yet contained in the database, a new reord is inserted. A standard .NET datatable is used for this interaction.

When an update is written, information regarding the update, including previous price and new prices, are logged. Logging is done by writing a string to a logging interface that is provided.

The application also logs when it file downloads the file and reports the file version as specified as a date given at the top of the file.

The following provides a sample of the file to parse. The definition of the table in which to store the information is also shown below.

File Snippet:

FINAL PRE-CLEARING PRICES AS OF 09/18/12 06:00 PM (CST)

MTH/ ---- DAILY --- PT ------- PRIOR DAY -------

STRIKE OPEN HIGH LOW LAST SETT CHGE [url removed, login to view] SETT VOL INT

C Corn Futures

DEC12 748'2 754'0 739'0 741'0 740'0 -8'0 174542 748'0 160250 666825

Sql Table:

FuturesProductSettlementID int

FuturesProductID int

SettlementDate datetime

[Open] nvarchar(16)

High nvarchar(16)

Low nvarchar(16)

Last nvarchar(16)

Settlement nvarchar(16)

PercentChange float

Volume int

OpenInterest int

ReportDateTime datetime

The project will be developed using a Win7 developer's machine that is set up at our office. The PC is installed with all the development tools that are needed for your work; including Visual Studio 2012 and SQL Server 2012. The database that will be needed to perform the work. You will connect to the PC using a VPN connection. You will need to install a VPN client on your home machine, which is a Java-based program. You will also need to run a Remote Desktop Connection client from your machine. This configuration will allow work to begin quickly, with minimal set up time.

Skills: C# Programming, SQL

See more: store ftp files datatable, ftp cme settlement prices, cme ftp server, read ftp file store, writing file java, writing file, writing symbols, writing machine prices, work home seek, work home java developer, work home chicago, work close home, vpn programming, visual studio net java, top chicago, tools needed programming, tools needed java programming, time trade, writing studio, symbols writing, summary java developer, strings standard, sql server price list, seek work home, seek download

About the Employer:
( 2 reviews ) Chicago, United States

Project ID: #2502539

Awarded to:

kalpesh2804

Hi, I have experience in Same kind of Project. Thanks

$75 USD in 10 days
(15 Reviews)
4.3

14 freelancers are bidding on average $158 for this job

saamorim

Hi there. Can develop this application to you. No problem in doing the remote job. From my profile and past jobs you'll see that I can this jobs easily. Many thanks, Saamorim

$150 USD in 2 days
(10 Reviews)
4.8
dobreiiita

Hello, I am expert and dedicated in C# Development.I am very much interested for your project. I can complete your project quickly and efficiently in time. Details will be discussed in the message.

$200 USD in 7 days
(31 Reviews)
4.8
sharpcodernet

Hi, .NET developer with 10+ years of experience is ready to help you. Please, check PMB for more details. Thanks.

$225 USD in 5 days
(18 Reviews)
4.7
rvector

I have a very good experience with files and FTP , kindly check my message.

$150 USD in 7 days
(14 Reviews)
4.5
aoefmpes

pl check your inbox

$210 USD in 7 days
(6 Reviews)
4.1
winnet21

Hi, I have experience with this project, Please check PM. Thanks

$150 USD in 7 days
(6 Reviews)
3.8
johnnycl

Hello, I am experienced in C# and after reading the project specifications I am confident I can complete it to your satisfaction. Thanks, John

$100 USD in 7 days
(4 Reviews)
3.5
sotrue

I hope will spare some of your valuable time to visit our sample websites . Please check your PMB & share your queries regarding your esteem project that you have posted on freelancer.com & let us know how soon we can More

$222 USD in 7 days
(1 Review)
2.8
tuvok7

Hi, I'm professional software developer and architect specialized in .net technology. For a couple of years I was also working as database designer and developer. I can take this order

$199 USD in 5 days
(1 Review)
2.9
nitintech

We can do this in C#

$125 USD in 8 days
(1 Review)
0.2
newstars2012

Hi, I had gone through the requirements. I am confident to do this as I had done similar kind of job in past. Please let me know. Regards, Alok Kumar

$200 USD in 4 days
(1 Review)
0.0
RajdipPatel

Experts in software development and web technologies. Hope have great business together.

$100 USD in 3 days
(0 Reviews)
0.0
freelanceforfun

Have experience in developing c# .net applications for past 7 years . Would ensure a smooth delivery of the product.Open to changes once done . Looking forward to work with you . Thanks !

$100 USD in 5 days
(0 Reviews)
0.0