Database - Real Time Stock/Futures Data
$100-500 USD
Paid on delivery
I currently receive real time data via an Excel DDE link to my data vendors server.
This real time data is calculated and queried by XL, which simultaneously charts the summaries.
I wish to commission the programming of a new system which will utilize the data vendors Java-to-socket Sample API (*open source, sample and code available*) and send all incoming data to a database in real time, preferably **CACHÉ** by InterSystems ([[url removed, login to view]][1]).
The structural organization of the DB should be able to facilitate all calculations necessary for charting, whereby resulting real time queries/summaries can simultaneously be charted in Flash, or by JFreeCharts, for example.
In short, this project should result in the delivery of these 3 items:
**1. Data Link Interface** - utilizing provided Java-to-socket sample API and source code to receive and send data incoming data to database. This API can be "built upon" in order to not have to start from scratch.
**2. Database** - preferably Caché, to log, query, and summarize all incoming data, allowing for simultaneous charting of real time results, other DB's also acceptable.
**3. Charting Interface -** Flash or JFreeChart to chart database summaries and query results in real time.
## Deliverables
In addition to the standard items below, I want to go on record and state that I have NO PROGRAMMING EXPERIENCE whatsoever, and that the delivered Interface & database server/application are going to have to be in a user friendly format with a guide (either verbal or written) to installation and connection.
I don't expect any installation wizard's or the like - but I don't consider the job done until it is all functioning on MY computer. So some extent of post-production consultation regarding the initial implementation should be expected.
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
**Database for Windows XP Pro:** Caché by InterSystems. MySQL, MSSQL, MSDS2000, etc. also acceptable, but not preferred.
**Data Interface**: Java-to-socket API. Have a fully functioning sample with all necessary sample code/documentation, and full documentation on connectivity with the data vendors server. Can be built upon, so as to not have to "start from scratch".
**Charting Interface:** Although I am VERY interested in thoughts and ideas on a 3D solution WITH z-axis, it would seem as if Flash or JFreeCharts is currently the way to go. As this is a "Mission Critical" application it is the real time functionality that is, ultimately, of greatest importance. All 2D charts will, however, HAVE to be **Stacked Horizontal Column/Line combination charts**.
Project ID: #3930244