SQL code to allocate trade awards between traders

Befejezett Kiadva: 5 évvel ezelőtt Kiszállításkor fizetve
Befejezett Kiszállításkor fizetve

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.

Adatbázis-programozás PostgreSQL SQL

Projektazonosító: #18344413

A projektről

9 ajánlat Távolról teljesíthető projekt Utoljára aktív: 5 évvel ezelőtt

Odaítélve:

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) Továbbiak

$150 USD 7 napon belül
(11 értékelés)
4.7

9 szabadúszó tett átlagosan 209$ összegű árajánlatot erre a munkára

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 Továbbiak

$250 USD 3 napon belül
(10 vélemény)
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 3 napon belül
(13 vélemény)
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 Továbbiak

$30 USD 7 napon belül
(7 vélemény)
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 Továbbiak

$200 USD 10 napon belül
(5 vélemény)
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 Továbbiak

$250 USD 5 napon belül
(0 vélemény)
0.0