Database - Real Time Stock/Futures Data

Completed Posted Oct 13, 2005 Paid on delivery
Completed 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**.

Database Administration Engineering Java JavaScript Microsoft Access MySQL PHP Software Architecture Software Testing SQL

Project ID: #3930244

About the project

13 proposals Remote project Active Nov 3, 2005

Awarded to:

vw1612799vw

See private message.

$1200 USD in 39 days
(25 Reviews)
4.8

13 freelancers are bidding on average $442 for this job

educatiaonline

See private message.

$382.5 USD in 39 days
(39 Reviews)
5.6
mariuspvw

See private message.

$119 USD in 39 days
(20 Reviews)
4.5
softwareprabhu

See private message.

$510 USD in 39 days
(15 Reviews)
4.5
mariusmunteanu

See private message.

$510 USD in 39 days
(6 Reviews)
4.0
donofdons

See private message.

$1275 USD in 39 days
(15 Reviews)
3.4
amhelptech

See private message.

$85 USD in 39 days
(15 Reviews)
2.8
sladjacirovic

See private message.

$212.5 USD in 39 days
(7 Reviews)
2.4
gerr2305

See private message.

$170 USD in 39 days
(1 Review)
2.3
cgmsoftwaregmbh

See private message.

$212.5 USD in 39 days
(0 Reviews)
0.0
vw1683877vw

See private message.

$136 USD in 39 days
(0 Reviews)
0.0
tforcevw

See private message.

$680 USD in 39 days
(0 Reviews)
0.0
knowledgepo

See private message.

$255 USD in 39 days
(0 Reviews)
0.0