For the complete documentation index, see llms.txt. This page is also available as Markdown.

Get Timestamp

Fetches the most recent timestamp for a given data family (currently RATES) and index. Useful for checking when the data behind a quote was last updated.

New to the Excel Add-In? Install the add-in to start using this formula.

=BlueGamma.TIMESTAMP(family, value, [valuation_date])

Parameters

  • family string Data family to query. Supported: "RATES"

  • value string Identifier within the chosen family (e.g., "SOFR", "SONIA", "1M EURIBOR" for RATES).

  • valuation_date string (optional) Valuation date or datetime, interpreted as UTC. Accepts a date or datetime cell, DATE(y,m,d) + TIME(h,m,s), or an ISO string like "2026-07-17T14:30:00". Date-only values price at end of day (23:59:59 UTC). Defaults to live. Useful for checking exactly which data snapshot an intraday valuation resolves to.


Returns

Timestamp of the most recent data point before the specified valuation time, as an Excel date-time serial number in your computer's local time. Format the cell as a date and time (for example with the custom format yyyy-mm-dd hh:mm) to read it.


Example

=BlueGamma.TIMESTAMP("RATES", "SOFR")

The cell shows a date-time serial number. Once formatted as a date and time, it reads as the date and local time of the latest SOFR curve update.

Last updated

Was this helpful?