Small contract and position management database for metal merchants
4768
£500(approx. $628)
- Posted:
- Proposals: 3
- Remote
- #63714
- Archived
Description
Experience Level: Expert
Our small international physical commodity trading group is looking to build a simple contract management and position reporting solution in MS Access to help us manage our trading activity.
There are many professional solutions on the market for commodity trading, but they cost astronomical sums of money, and are too complex and sophisticated for our current needs. We only have one-two transactions per day and at the moment manage all the data manually on spread sheets.
The purpose of the database would be to allow operators to input data in a uniformed way, get contract number generated and then change the status of the order as it goes through different stages of the deal.
We need some matching mechanism that would allow matching of Sales to Purchases and vice versa (as we can open short or long positions and then cover them by sales or purchases). Also we can have partial sales of positions. Eg. We bought a lot of 100 tonnes of metal from Italy to be delivered to Spain. Then we sold 20 to one Spanish customer, 50 to another Spanish customer. So we will have 2 sold positions and one long/stock remaining, and so on.
Also we would like to be able to view some simple reports showing all positions (LONG, SHORT, STOCK, SOLD, SHIPPED, LIQUIDATED) and pivot charts that sort our positions by status and product in terms of total tonnage and estimated p/l.
I have attached a template of some database tables and forms.
Please state how much your work will cost and how long it will take you to modify what we have to meet our needs.
Thank you.
There are many professional solutions on the market for commodity trading, but they cost astronomical sums of money, and are too complex and sophisticated for our current needs. We only have one-two transactions per day and at the moment manage all the data manually on spread sheets.
The purpose of the database would be to allow operators to input data in a uniformed way, get contract number generated and then change the status of the order as it goes through different stages of the deal.
We need some matching mechanism that would allow matching of Sales to Purchases and vice versa (as we can open short or long positions and then cover them by sales or purchases). Also we can have partial sales of positions. Eg. We bought a lot of 100 tonnes of metal from Italy to be delivered to Spain. Then we sold 20 to one Spanish customer, 50 to another Spanish customer. So we will have 2 sold positions and one long/stock remaining, and so on.
Also we would like to be able to view some simple reports showing all positions (LONG, SHORT, STOCK, SOLD, SHIPPED, LIQUIDATED) and pivot charts that sort our positions by status and product in terms of total tonnage and estimated p/l.
I have attached a template of some database tables and forms.
Please state how much your work will cost and how long it will take you to modify what we have to meet our needs.
Thank you.
Stepan Z.
0% (0)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
24 May 2011
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies