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#.
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.
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
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.
14 freelancers are bidding on average $158 for this job
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
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.
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
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 !