Get Bond Price

Get the indicative bond mid price for an ISIN.

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

Formula

=BlueGamma.BOND_PRICE(isin, [valuation_date])

Parameters

isin	string	12-character ISIN of the bond (e.g. XS1234567890)
valuation_date	string (optional)	Valuation date or datetime (UTC), e.g. 2026-07-17 or 2026-07-17T14:30:00. Date-only values price at end of day (23:59:59 UTC). Defaults to live.

Returns

Bond mid price as an indicative reference price.

Example

=BlueGamma.BOND_PRICE("XS1234567890")

=BlueGamma.BOND_PRICE("XS1234567890", "2024-06-30")

Notes

• The price is sourced from indicative pricing and is not a live market quote.
• If valuation_date is omitted, the function returns the latest available price.
• For historical lookups, the function returns the most recent quote on or before the valuation date.

---