Collect Data, Put In Database & Perform Simple Calculation
$30-5000 USD
Dibatalkan
Dibuat lebih dari 12 tahun yang lalu
$30-5000 USD
Dibayar ketika dikirim
PROJECT:
Collect data, put into table and perform calculation. See details below.
## Deliverables
PROJECT:
Collect data, put into table and perform calculation. See details below.
GET DATA:
Make script that collects the data below and puts the data into the database table (see example shown)
- Symbol
- Bid
- Timestamp (From data source call)
- (Time data saved to table)
PRIMARY DATA SOURCE:
Gain Capital (See attached information)
CALL TIMES:
Data calls to be made 5 seconds before each half-hour: HH:59:55 and HH:29:55
BACKUP DATA SOURCE:
When data from primary source is unavailable, script should immediately use backup source (and send me an email about the primary failure):
[login to view URL]
FREQUENCY:
Data collected every 30 minutes HH:59:55 and HH:29:55 - 24 hours a day, 5 days a week.
Beginning Time: 5pm ET Sunday
Ending Time: 5pm ET Friday
CONFIRMATION:
If data is not received from primary or backup sources then send warning email to me.
HISTORICAL DATA:
Database table should delete data older than 96 hours (4 days).
PERFORM CALCULATION:
Immediately after the data is added to the table, calculate the average price using the data in the table. Make a new table where 3 different values (X, Y, Z) are added by me. These 3 will be used to calculate the average Bid value for each time period X, Y and Z. (System should refer to this before performing the calculation each time so the current values are used).
CALCULATION EXAMPLE:
If X=2, Y=4 and Z=6, and the data in the table (that collects the data) is:
SymbolID, TimeStamp, TimeAdded, Bid
EURUSD,02/03/2010 16:59:55,1
EURUSD,02/03/2010 17:29:55,2
EURUSD,02/03/2010 17:59:55,3
EURUSD,02/03/2010 18:29:55,4
EURUSD,02/03/2010 18:59:55,5
EURUSD,02/03/2010 19:29:55,6
Calculated values and write values to the table:
AverageX = (1+2)/2 = 1.5
AverageY = (1+2+3+4)/4 = 2.5
AverageZ = (1+2+3+4+5+6)/6 = 3.5
This calculation function should run immediately after each time the new data is added to database. The calculation script should refer to the current X, Y, Z values in the table to be sure it uses the current values each time it calculates.
NOTE:
It is important that all processes complete REALLY FAST because I will pull data from the table exactly at HH:00:00 and HH:30:00.
MAKE DUPLICATE SYSTEM:
After above system is tested, then make an exact copy of the system above except reverse primary and backup sources, so [login to view URL] is primary source and gain capital source is backup.
SERVER:
Linux
Please reply with the language of choice and time to complete. Experienced developers only. I look forward to hearing from you.
Thanks,