Find Jobs
Hire Freelancers

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,
ID Proyek: 3494315

Tentang proyek

20 proposal
Proyek remot
Aktif 13 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
20 freelancers are bidding on average $228 USD for this job
Avatar Pengguna
See private message.
$59,50 USD dalam 14 hari
5,0 (136 ulasan)
6,4
6,4
Avatar Pengguna
See private message.
$276,25 USD dalam 14 hari
5,0 (155 ulasan)
6,2
6,2
Avatar Pengguna
See private message.
$42,50 USD dalam 14 hari
5,0 (234 ulasan)
6,4
6,4
Avatar Pengguna
See private message.
$212,50 USD dalam 14 hari
5,0 (53 ulasan)
5,8
5,8
Avatar Pengguna
See private message.
$484,50 USD dalam 14 hari
4,9 (26 ulasan)
5,4
5,4
Avatar Pengguna
See private message.
$153 USD dalam 14 hari
5,0 (42 ulasan)
5,2
5,2
Avatar Pengguna
See private message.
$136 USD dalam 14 hari
4,9 (50 ulasan)
5,5
5,5
Avatar Pengguna
See private message.
$78,20 USD dalam 14 hari
5,0 (55 ulasan)
5,0
5,0
Avatar Pengguna
See private message.
$170 USD dalam 14 hari
5,0 (4 ulasan)
4,2
4,2
Avatar Pengguna
See private message.
$127,50 USD dalam 14 hari
5,0 (20 ulasan)
4,4
4,4
Avatar Pengguna
See private message.
$170 USD dalam 14 hari
4,4 (5 ulasan)
2,1
2,1
Avatar Pengguna
See private message.
$348,50 USD dalam 14 hari
5,0 (3 ulasan)
1,9
1,9
Avatar Pengguna
See private message.
$151,30 USD dalam 14 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
See private message.
$425 USD dalam 14 hari
0,0 (2 ulasan)
0,0
0,0
Avatar Pengguna
See private message.
$510 USD dalam 14 hari
0,0 (7 ulasan)
0,0
0,0
Avatar Pengguna
See private message.
$50,15 USD dalam 14 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
See private message.
$552,50 USD dalam 14 hari
0,0 (1 ulasan)
0,0
0,0
Avatar Pengguna
See private message.
$127,50 USD dalam 14 hari
0,0 (1 ulasan)
0,0
0,0
Avatar Pengguna
See private message.
$68 USD dalam 14 hari
0,0 (1 ulasan)
0,0
0,0
Avatar Pengguna
See private message.
$424,15 USD dalam 14 hari
5,0 (3 ulasan)
0,0
0,0

Tentang klien

Bendera UNITED STATES
Bend, United States
4,9
127
Memverifikasi Metode pembayaran
Anggota sejak Jun 20, 2005

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.