Commodity Trading & Risk Management
Solution providers 

CTRM Blog


17.10.2019

Data - part 2

So you have many offices globally, a data team has visited each office and worked out how to obtain an automated dump of their transactional data. Each day that data can be translated into a standardised unit and field structure. 
In the most basic form, this will be a spreadsheet template or csv file, populated from the local contract management system and translated into a structure which can then populate the central data-warehouse. The ultimate goal is a real time update from the source system to the data-warehouse. 

Once the transactional data becomes available as an homogenous and clean source, then many advantageous options present themselves. 

I must mention another critical element at this point that relates to correct mark-to-market. Forward open risk needs to be marked to a current market price. A dedicated price database should be available for this, there are many off-the-shelf options which pull in all the liquid market data from global exchanges, submitting brokers and forex rates and also allow a lot of customisation such that custom price curves, input directly or as a basis to an already existing curve. Price databases are a huge subject unto themselves and will be a feature of a future blog. 

So ultimately we should aim to have a scenario where the global transactional data sits in a data warehouse with all forward contracts marked to a real-time or daily updated price database. This is now a single view of the truth of the current state of the business at any time. Once in place, all reporting should be conducted from this source.
This does not only mean the centralised risk and financial management reports but also every office globally should have permissioned access and report accordingly. It ensures everybody is looking at the same data and reporting on the same data. 

Here are just some advantages. 
1. Consistency of information across the organisation.
2. Global foreign exchange exposure.
3. Counter-party exposure which can roll up subsidiaries into global group company exposures.
4. Consistency and accuracy of mark-to-market. The same price is used for all trades of the same product and location globally. 
5. Transparency and consistency of cost items.
6. Transparency of contract rolling or cancellation and replacement.
7. Clarity of contract management process and measurement of operational KPI’s such as trade input and independent confirmations.
8. Return on working capital by business, geography, product.
9. Global geographical and product position exposure.
10. Clear view of global trade payables and receivables.
11. Risk adjusted return by product and counterpart. 
12. Global working capital utilisation and forward projection including variation margin.
13. Ease of global stress test and scenario analysis.
14. Better tracking of geopolitical risk exposure. 

The other great advantage is the efficiency of information access. Custom dashboards can be provided to the desktop and ad-hoc analysis can be carried out by anybody within their data permissions. It cannot be underestimated how much time is spent in many companies on gathering, checking and consolidating data. Once there is a single source of truth, the process becomes efficient and allows for very significant cost savings. In addition fast analysis and reporting allows for more efficient and informed decision making across all functions and translates directly into improved outcomes.

The question is whether any global commodity business can really afford not to invest in efficiently managing their data?

Admin - 11:33 | 7 comments

  1. gaurav

    07.01.2021

    very informative article about the commodity risk management.
    can you share with us some information about the USA commodity market review.

  2. wedding videographer

    15.09.2021

    I just want to let you know that I just check out your site and I find it very interesting and informative..

  3. China Molecular Sieve

    27.07.2022

    Maybe in the future when body styles of vehicles leave flavor, people could essentially unbolt their vehicle body, diminish it to fine residue, and have it formed once more into anything that they’d like. On the off chance that they are a youngster they might go for a Corvette, as they grow up, get hitched, and have a family they might conclude they need a SUV or smaller than normal van. Do you see the point yet.

  4. 꽁머니 지급

    12.08.2022

    그럼에도 불구하고 그것은 당신이 할 수 있는 기회에 당신이 인출을 하기 위한 클럽 전제 조건을 충족시키기 전에 도박 기계에 약 $1000를 베팅해야 하는 것입니다. 따라서 웹 룰렛에서 $2000를 획득했다고 가정하면 현재 약 $1,000의 지원을 받고 있으므로 도박 기계에서 $1000를 잃었는지 여부에 관계없이 $1000의 이익을 얻었습니다. 분명히 게임기 보상도 마찬가지로 혜택에 추가되므로 $1000 이상을 벌 수 있습니다.

  5. highlighter pens

    12.08.2022

    For every one of their benefits, wellspring pens are commonly not appropriate for accommodation and day to day use. Many individuals probably shouldn’t manage the problem of changing out ink. Wellspring pens require somewhat more consideration than ballpoint pens or rollerballs, and on the off chance that something turns out badly with them, you generally need to invest some energy sorting it out instead of throwing it and getting another one.

  6. refrigeration parts

    13.08.2022

    Over the course of the following many years, and, surprisingly, progressing forward with today, designing food handling hardware turned into a need. Handling machines expected to fulfill numerous necessities.

  7. 12Volt Solar Charger

    13.08.2022

    20 - 25 years guarantee on mono-and polycrystalline silicon sun powered chargers are normal. This ought to be the base while buying sun powered chargers, since today best sunlight based chargers have futures of 30 years and, surprisingly, longer. Investigate the production line guarantee and don’t acknowledge just a seller’s guarantee.

Add comment

Fill out the form below to add your own comments

To reduce automated spam, this function is protected with a captcha.

This requires content from the third-party provider Google to be loaded and cookies to be stored.



E-mailen
LinkedIn