Many organizations within the global commodity trade rely on Excel for building and maintaining forward curves. While Excel is great for many things like data manipulation, it lacks the version control, data integration, and the straight-through processing capabilities required for efficient curve building.
Much of the sophisticated logic required for effective curve building, such as calendar and term logic, bootstrapping of overlapping data points, and leveraging various types of interpolations for data gaps, requires home grown non-standardized logic which typically requires the aid of a specialist. Spreadsheets quickly become complex and difficult for other consumers or managers within the organization to understand or support – not to mention the inefficiencies associated with a spreadsheet distribution model.
A curve automation tool, such as MarketView’s MarketView CurveBuilder, can simplify the curve building experience and provide all decision makers with the ability to easily develop, test and automate the generation of simple or complex curves.
Main Benefits of Using a Curve Automation Tool Over Excel
• Built-in term/calendar support
• Built-in bootstrapping and interpolations
• Curve schedule manager and dashboard
• Complete revisions history of each curve
• Over 350 data sources available out of the box (including proprietary data)
• Define custom roll rules
• Curve visualization/consumption in other products such as desktop platform, spreadsheets, or downstream systems
• C/ETRM automation
Move away from Excel and try a free trial of MarketView CurveBuilder for a transparent, easy-to-use, and auditable application that can vastly improve your forward curve building experience.
Thoughts? Comment below.
Jaenneke Wolf
Latest posts by Jaenneke Wolf (see all)
- Q&A: 2017 Natural Gas Outlook: A Market In Transition Webinar - March 24, 2017
- Building Curves in Excel is Risky - September 6, 2016
- Value of Data Integration During Challenging Times - August 2, 2016