Analyze some Data with mysql

$30-250 USD

Completed

Posted

almost 10 years ago

$30-250 USD

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 10 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

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 terabytes of data.

$75 USD in 4 days

5.0

(2 reviews)

2.6

8 freelancers are bidding on average $130 USD 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

4.8

(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,Please revert me if you have any concern .I am ready to start now.

$105 USD in 2 days

4.5

(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

5.0

(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

4.5

(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