Historical data in Excel

Dec. 12, 2021, 10:55 p.m. - posted by Alex

Tonight's Excel Add-In release (v2.0.3010) allows you to access your historical data via the new CTHISTORICAL function.  The syntax for the function looks like this:

=CTHISTORICAL(timestamp, product, period, column, curve)

Excel date/time formats are supported, as well as strings in this format "YYYY-MM-DD HH:MM:SS".  Here's an example of historical settle values for LS Gasoil Futures at 6pm UTC:

Get in touch with our support to learn more.