CT Grid News

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.

Recent News Posts

CT Grid on tablets 2 years, 2 months ago

New Calculation Engine 2 years, 5 months ago

New release with layout improvements 2 years, 8 months ago

New CT Grid Mobile App Released 2 years, 9 months ago