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.
=BlueGamma.TIMESTAMP(family, value, [valuation_date])
Parameters
family
stringData family to query. Supported:"RATES"value
stringIdentifier 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?

