SQL code to allocate trade awards between traders

Finalizat Postat la acum 5 ani S-au achitat serviciile după ce au fost prestate

$30-250 USD

S-au achitat serviciile după ce au fost prestate

Finalizat S-au achitat serviciile după ce au fost prestate

I work for an electricity trading company. We make lots of trades each hour of each day. Multiple traders submit bids and offers into the database. The central electricity organization then awards these bids and offers in aggregate. So using the pricing with our bids and offers, we need a way to allocate these aggregated awards to the trades that cleared.

Complicating matters is that sometimes the awards do not always match what would make sense based on our bids and offers pricing. So we need a way to allocate these non-standard awards.

We have a PostgreSQL database. The attached files give the table structures and a document with further background and the non-standard scenario examples.

There are also some excel files with actual data.

Programare baze de date PostgreSQL SQL

ID Proiect: #18344413

Detalii despre proiect

9 propuneri Proiect la distanță Activ acum 5 ani

Vrei să câştigi ceva bani?

Avantajele licitațiilor de pe Freelancer.com

Setează-ți bugetul și intervalul de timp
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte

Acordat lui:

Fotografia de profil a utilizatorului kashivw
kashivw

Hello, Thank you for describing the task in great detail as well as providing table structures, data and logic. I am a veteran (25+ years) database developer with real industry experience in Oracle (v6 thru v12c) Mai multe

%selectedBids___i_sum_sub_7%%project_currencyDetails_sign_sub_8% USD în 7 zile
(11 Recenzii)
4.7

9 freelanceri plasează o ofertă medie de 209$ pentru proiect

Fotografia de profil a utilizatorului schoudhary1553
schoudhary1553

Hello, Hope you are doing well. I can help with you in your project SQL code to allocate trade awards between traders. I can assure you the quality job. I have good experience in Database Programming, PostgreS Mai multe

$250 USD în 3 zile
(10 recenzii)
5.4
Fotografia de profil a utilizatorului topithub
topithub

SQL code to allocate trade awards between traders I am an expert web programmer with 7+ years’ experience in latest web development technologies. please send me message to discuss more

$155 USD în 3 zile
(13 recenzii)
5.2
Fotografia de profil a utilizatorului dhruvgupta1992
dhruvgupta1992

Hi, Greeting for the day. I can deliver you this project with the best premium design of your choice in the mention time. Let's Discuss. I am expert in doing in database tasks, as I have experience of 4 years in M Mai multe

$30 USD în 7 zile
(7 recenzii)
3.8
Fotografia de profil a utilizatorului Darwin21015
Darwin21015

Hi how are you ? I hope you are well, I am very interested in your project, I consider myself the right person since I have more than two years of experience in postgresql I have developed databases with more than 50 t Mai multe

$200 USD în 10 zile
(5 recenzii)
3.2
Fotografia de profil a utilizatorului FooGeo
FooGeo

Hi, I have several years of experience with SQL work and would be happy to help you with your project. I am very excited about this opportunity and feel that I would be an excellent fit. As always I provide top quality Mai multe

$250 USD în 5 zile
(0 recenzii)
0.0
Postează un proiect similar