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

プロジェクト ID: 6065889

プロジェクトについて

8個の提案

リモートプロジェクト

アクティブ 10年前

お金を稼ぎたいですか？

メールアドレス

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人のフリーランサーが、平均$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日以内