Creating Continuous Contract in MySQL

$30-250 USD

Скасований

Опублікований

over 8 years ago

$30-250 USD

Оплачується при отриманні

I'm trying to make some Futures Continuous Contract for personal use. I have created some php code which scraping some websites for end of day (EOD) data. This data is stored in my MySQL database. The code is set to run each day at a specific time by cron job. My problem is now to use this data and assemble this into continuous contract. I’m open for reconstruction of they way data is stored if it will make it more efficient. Right now I store data in one table which contains EOD data for all open futures contracts. I then want the row with the highest value in column x in this table to be returned to another table. Them should only be one value at each date, and it shouldn’t be able to jump over a contract or jump back to the previous contract if the value at those in a mystery way turn higher again. I hope you can understand my problem/job.

MySQL

PHP

Software Architecture

ID проекту: 8861561

Про проект

9 пропозицій(-ї)

Дистанційний проект

Активність 9 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни

Отримайте гроші за свою роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

9 фрілансерів(-и) готові виконати цю роботу у середньому за $173 USD

@Shattenjagger

Hi there. I'd read yours description carefully, but better to get a live example of yours problem :) Are we talking about stored MySQL procedure that process the data in one table? Anyway, contact me and let's to the business!

$200 USD за 1 день

5,0

(68 відгуки(-ів))

6,8

@elbruninh

Hi, i'm interested, could you give me more details please? could you send me the database and the php scraper? i can help you regards

$100 USD за 1 день

5,0

(75 відгуки(-ів))

6,3

@mshahzeb43

A proposal has not yet been provided

$155 USD за 3 дні(-в)

5,0

(83 відгуки(-ів))

5,6

@spencerb

I've organized a lot of DB schemas over 20 years to work well with the application they support. I'm a programmer, but a well-styled database is essential. I can probably easily figure out a way to organize your tables and change your PHP a little so your data is more usable.

$130 USD за 4 дні(-в)

5,0

(49 відгуки(-ів))

5,8

@viswesh

I have 10 years of experience in dealing various databases , performance issue related issues, database design and writing complex queries.

$155 USD за 3 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@itereshchenkov

A proposal has not yet been provided

$222 USD за 3 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@jawnkristy

A proposal has not yet been provided

$155 USD за 3 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@r3xd3mo

Greetings, I am a proficient developer of MySql created a full data warehouse for walmart pvt limited in MySql. so i know a lot about the table structures and how and when to move and place data effectivly without any anomolies seeing the statement, there are two approaches that comes into my mind that can be a cause and the solution. 1. the method of which you are sending the data, should be evaluated. 2. table structure should be evaluated. if you can give me the access, i can check and do that for you in matter of hours Looking forward to work with you Regards, Abdul Haseeb

$111 USD за 1 день