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.