Analyze some Data with mysql

Completed Posted Jun 13, 2014 Paid on delivery
Completed Paid on delivery

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

Project ID: #6065889

About the project

8 proposals Remote project Active Jun 13, 2014

Awarded to:

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 t More

$75 USD in 4 days
(2 Reviews)
2.6

8 freelancers are bidding on average $130 for this job

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 in 1 day
(12 Reviews)
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,Pl More

$105 USD in 2 days
(15 Reviews)
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 in 5 days
(4 Reviews)
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 in 1 day
(3 Reviews)
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 in 3 days
(0 Reviews)
0.0
dspatidar11

I have good knowledge of JAVA and Web Services. I have hands on experience in this programming languages.

$166 USD in 3 days
(0 Reviews)
0.0
vanpham

A proposal has not yet been provided

$88 USD in 3 days
(0 Reviews)
0.0