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 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, 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).