Get Timestamp

Fetches the most recent timestamp for a given rate family and value (eg RATES/FIXINGS). 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_time])

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_time string (optional) Valuation time in YYYY-MM-DD format. Defaults to the latest available.

---

Returns

Timestamp of the most recent data point before the specified valuation time, in UTC. Format: YYYY-MM-DD HH:MM UTC.

---

Example

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

→ 45176.60556 (Excel serial) Formatted as 2025-08-30 15:32 (local time).