Get Bond Yield

Get the indicative bond yield-to-maturity for an ISIN.

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

Formula

=BlueGamma.BOND_YIELD(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 yield-to-maturity as a decimal (e.g. 0.0412 for 4.12%).

Example

=BlueGamma.BOND_YIELD("XS1234567890")

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

Notes

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

---