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. [Read More…]