SQL code to allocate trade awards between traders

Dokončeno Zveřejněno před 5 lety K zaplacení v momentě doručení
Dokončeno K zaplacení v momentě doručení

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.

Programování databází PostgreSQL SQL

Identifikační číslo projektu: #18344413

O projektu

9 nabídek Projekt na dálku Aktivní před 5 lety

Uděleno uživateli:

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) Další

$150 USD za 7 dní
(11 recenzí)
4.7

9 Freelnceři na tento projekt zveřejňují nabídky v průměru $209

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 Další

$250 USD za 3 dní
(10 Recenzí)
5.4
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 za 3 dní
(13 Recenzí)
5.2
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 Další

$30 USD za 7 dní
(7 Recenzí)
3.8
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 Další

$200 USD za 10 dní
(5 Recenzí)
3.2
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 Další

$250 USD za 5 dní
(0 Recenzí)
0.0