SQL code to allocate trade awards between traders

Ολοκληρωμένο Αναρτήθηκε Πριν 5 χρόνια Πληρώθηκε κατά την παράδοση
Ολοκληρωμένο Πληρώθηκε κατά την παράδοση

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.

Προγραμματισμός Βάσης Δεδομένων PostgreSQL SQL

Ταυτότητα Εργασίας: #18344413

Σχετικά με την εργασία

9 προτάσεις Απομακρυσμένη εργασία Ενεργό Πριν 5 χρόνια

Ανατέθηκε στον:

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) Περισσότερα

$150 USD σε 7 μέρες
(11 Αξιολογήσεις)
4.7

9 freelancers κάνουν προσφορές κατά μέσο όρο $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 Περισσότερα

$250 USD σε 3 μέρες
(10 Αξιολογήσεις)
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 μέρες
(13 Αξιολογήσεις)
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 Περισσότερα

$30 USD σε 7 μέρες
(7 Αξιολογήσεις)
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 Περισσότερα

$200 USD σε 10 μέρες
(5 Αξιολογήσεις)
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 Περισσότερα

$250 USD σε 5 μέρες
(0 Αξιολογήσεις)
0.0