While integrated C/ETRM systems have been commercially available for over two decades, they haven’t eliminated the usage of spreadsheets. And they won’t as business users in the commodity trading space will tell you so. According to a 2017 survey conducted by Comtech Advisory, spreadsheets were simply deemed faster and easier to use for certain tasks. At the same time, there is recognition that in a world of fast-moving markets, affected by multiple information sources, and subject to regulatory reporting, spreadsheet-based systems lack the controls, increase risk, and can’t deliver management the information for proper decision-making. That brings us to the proverbial title of this blog: if the spreadsheet jockey will not come to the integrated C/ETRM, then the integrated C/ETRM must come to the Spreadsheet! For the start-up and small enterprise trading firm, a spreadsheet offers a quick and cost-effective route to rudimentary deal capture and position management functionality, typically limited to handful of users only. Similarly, for the legacy-system-user, a spreadsheet offered a way to create workarounds, albeit isolated and disconnected, for functionality that cannot be supported by the legacy system, take too long to build or is too costly. There is no question about the value and power… continue reading
Continue reading If the Spreadsheet Jockey will not come to the integrated C/ETRM…. then the integrated C/ETRM must come to the Spreadsheet. This article appeared first on CTRM Center.
Source: CTRM Center