Analyze some Data with mysql
$30-250 USD
Bezahlt bei Lieferung
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.
Projekt-ID: #6065889
Über das Projekt
8 Freelancer bieten im Durchschnitt $130 für diesen Job
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
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,Pl Mehr
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
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.
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
I have good knowledge of JAVA and Web Services. I have hands on experience in this programming languages.