How do I load interest rate fixings into the Quote Store?

Prev Next

You can load a fixing representing a published benchmark or reference interest rate for a given day, for example 1.24224503 for SOFR on 6 May 2026.

Note the following:

  • Interest rate fixings are required items of market data for instruments with floating legs such as certain complex bonds and interest rate swaps, to calculate cashflows and accrued interest.

  • Choices you make when uploading market data impact the composition of the recipe you must create in order to use that data.

See also: Market prices | FX spot rates | Inflation fixings

Methods

Call the UpsertQuotes API to load up to 2000 quotes in a single request. You must:

  • Encapsulate all the quotes in a single scope (namespace) in the URL.

  • For each quote, specify an ephemeral ID (to track errors in the response).

curl -X POST "https://<your-domain>.lusid.com/api/api/quotes/MyFixings"
  -H "Authorization: Bearer <your-API-access-token>"
  -H "Content-Type: application/json-patch+json"
  -d '{
  "Quote-0001": {
    "quoteId": {
      "quoteSeriesId": {
        "provider": "Lusid",
        "instrumentIdType": "RIC",
        "instrumentId": "GBP-LIBOR",
        "quoteType": "Price",
        "field": "mid"
      },
      "effectiveAt": "2026-01-01T00:00:00Z"
    },
    "metricValue": {
      "value": 0.497534, "unit": "GBP"
    }
  },
  "Quote-0002": {
    "quoteId": {
      "quoteSeriesId": {
        "provider": "Lusid",
        "instrumentIdType": "RIC",
        "instrumentId": "GBP-LIBOR",
        "quoteType": "Index",
        "field": "mid"
      },
      "effectiveAt": "2027-01-01T00:00:00Z"
    },
    "metricValue": {
      "value": 0.512738, "unit": "GBP"
    }
  }
}'

Navigate to Data Management > Quotes and click the Create quote button:

Write a Luminesce SQL query using the Lusid.Instrument.Quote.Writer provider and execute it using a tool such as the LUSID web app:

Data fields

This section supplements the API documentation and on-screen help text in the LUSID web app.

Mandatory field or parameter

Allowed values

Must be matched in recipe?

scope

Any, for example MyLIBORFixings

✅ dataScope field

provider

Any valid

✅ supplier field

field

Any valid for provider

✅ field field

instrumentIdType

RIC or ClientInternal

✅ key field, for example Quote.RIC.GBP-LIBOR or Quote.ClientInternal.*

instrumentId

Must match the  fixingReference field in the index convention of an instrument such as an IRS, for example GBP-LIBOR

quoteType

Index or Rate

✅ quoteType field

effectiveAt

A UTC datetime, or date and cut label

❌ but must be within quoteInterval

metricValue.value

The actual published rate, for example 0.489734

❌

metricValue.unit

Any intuitive string, for example GBP or None

❌

The following fields are optional:

  • A priceSource indicating a sub-supplier to the provider, for example Tradeweb or RRPS for Refinitiv DataScope. Match this using the priceSource field in a recipe. Note that if omitted, your recipe must also omit its priceSource field.

  • A lineage providing additional information.

  • We recommend not setting a scaleFactor for an interest rate fixing.

Subsequent updates

You can change the metricValue of an existing quote. Any other update constitutes a new quote in the time series.