Analyze some Data with mysql

$30-250 USD

Ολοκληρώθηκε

Αναρτήθηκε

περίπου 10 χρόνια πριν

$30-250 USD

Πληρωμή κατά την παράδοση

I need help with mysql code. I want to calculate the value of a forex portfolio in history. Not live. I have one file with the Date, Time and trades (start and close time) (portfolio) and 2 files with one minute forex prices. These files are imported into mysql. The code shall go to trade 1 (in the portfolio table) and when it is open go to the forex prices table and get the change the last minute (of Close) and then add (if BUY) or subtract (if SELL) that number into a sum column in the portfolio table each minute. The number of open trades each minute is also counted. When all trades are summed up into each minute the total sum shall be calculated. That is done by stacking each minute sum together with the sum from the last minute. Small test files is added here to clarify.

MySQL

Ταυτότητα εργασίας: 6065889

Σχετικά με την εργασία

8 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 10 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Διεύθυνση Email

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα

Πληρώσου για τη δουλειά σου

Περίγραψε την πρόταση σου

Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν

Βραβεύτηκε στον/στην:

@edmhs

Creating custom reports from CRM in mysql is one of my responsibility and special abilities in my main job. Experience with million of records from multiple sources (mysql, webservices, apis, xls etc) and from up to terabytes of data.

$75 USD σε 4 ημέρες

5,0

(2 αξιολογήσεις)

2,6

8 freelancers δίνουν μια μέση προσφορά $130 USD για αυτή τη δουλειά

@ezzarghili

Hello, I have a long experience with data analysis and MySQL so this job is perfect for me. I can do the job easily in one day. If you need the job done in a timely way this is the bid to select. Thank you

$111 USD σε 1 ημέρα

4,8

(12 αξιολογήσεις)

5,6

@acronymsolutions

Hi, I have gone through your requirements.I am a DBA at CMM5 Level company since August 2010.I am working on MySql,SQL Server,Oracle database, I can do your job confidently. I am very much Interested to do your work,Please revert me if you have any concern .I am ready to start now.

$105 USD σε 2 ημέρες

4,5

(15 αξιολογήσεις)

4,9

@joseluiselp

I can build that database for you, but you need to tell me how you want to update the info, also answer me a couple questions. Let me know if you are interested. Jose Luis Mendoza. Software Ing

$150 USD σε 5 ημέρες

5,0

(4 αξιολογήσεις)

3,9

@ramehani

Hi i have more than 7 years of sql script writing with complex queries, i can do this job in a quick and quality manner. ~Rameez.

$77 USD σε 1 ημέρα

4,5

(3 αξιολογήσεις)

1,8

@acejudger

Hi, sir. I'm interested in your job. I can do this perfectly. If you give me the chance to do this, I'll do my best and you will be satisfy. I hope to discuss more detail and forward/ Thanks

$266 USD σε 3 ημέρες