Chapter 5 – Bond Markets
This chapter outlines how to locate and interpret bond‑market data within LSEG products, with a focus on search tools, RIC construction, chain navigation, yields, credit ratings, debt indices, and other key fixed‑income topics.
In this chapter, the Python examples use the LSEG Data Library for Python, and the code below imports the library and opens a session to retrieve data.
import lseg.data as ld
ld.open_session()
<lseg.data.session.Definition object at 0x1a846e5cfe0 {name='workspace'}>
Tools for Finding Data
Use the following LSEG Workspace tools to locate equity instruments, related displays, and historical data definitions.
LSEG Workspace – Global Search
-
Purpose: Single search box at the top of Workspace for finding securities, issuers, news, research, and apps.
-
How to open: Enter names, tickers, RICs, ISINs, or keywords in the search box and click Enter or Shift + Enter.

LSEG Workspace – Advanced Search
-
Purpose: Lets you build more precise queries with filters such as asset class, region, currency, sector, date range, and more.
-
How to open: Enter the Advanced Search (AS) in the LSEG Workpsace - Global Search to open the Advanced Search application.

LSEG Developer Community - RIC Search Tool
-
Purpose: A web-based tool on the LSEG Developer Community website that lets you search RICs by criteria such as asset class, country, or exchange.
-
How to open: Go to the LSEG Developer Community website and select RIC Search from the Developer Tools menu.

LSEG Data Library for Python - Search APIs
-
Purpose: The search family of APIs in the LSEG Data Library for Python provides users powerful free‑text and filtered search, and lookup services over a very large universe of financial instruments, organisations, people, and assets.
-
How to use: Call the ld.discovery.search method with a query or filter parameter to return items that match your specified criteria. For example, the following code searches for active US Treasury Bond items contributed by Refintiv.
ld.discovery.search(
view=ld.discovery.Views.GOV_CORP_QUOTES,
filter=("RCSGovtBondTypeLeaf eq 'US Treasury Bond' "
"and AssetState eq 'AC' "
"and ContributorCommonName eq 'Refinitiv'"),
top=10
)
| BusinessEntity | DocumentTitle | PI | RIC | |
|---|---|---|---|---|
| 0 | QUOTExFIXEDINCOMExGOVCORP | United States 10 Year Benchmark, Government Bo... | 0x00040500706e3926 | US10YT=RR |
| 1 | QUOTExFIXEDINCOMExGOVCORP | United States 2 Year Benchmark, Government Bon... | 0x00040500706c223f | US2YT=RR |
| 2 | QUOTExFIXEDINCOMExGOVCORP | United States 5 Year Benchmark, Government Bon... | 0x00040500706e120d | US5YT=RR |
| 3 | QUOTExFIXEDINCOMExGOVCORP | United States 3 Year Benchmark, Government Bon... | 0x000405006e7c0417 | US3YT=RR |
| 4 | QUOTExFIXEDINCOMExGOVCORP | United States 7 Year Benchmark, Government Bon... | 0x00040500706e3629 | US7YT=RR |
| 5 | QUOTExFIXEDINCOMExGOVCORP | United States 30 Year Benchmark, Government Bo... | 0x00040500706e4f50 | US30YT=RR |
| 6 | QUOTExFIXEDINCOMExGOVCORP | United States 20 Year Benchmark, Government Bo... | 0x00040500706e445b | US20YT=RR |
| 7 | QUOTExFIXEDINCOMExGOVCORP | UNITED STATES TREASURY 10Y Point, Government ... | 0x0004051959a407e2 | UST10YT=RR |
| 8 | QUOTExFIXEDINCOMExGOVCORP | UNITED STATES TREASURY 2Y Point, Government B... | 0x0004051959a3ff1d | UST2YT=RR |
| 9 | QUOTExFIXEDINCOMExGOVCORP | UNITED STATES TREASURY 5Y Point, Government B... | 0x0004051959a402e7 | UST5YT=RR |
The following code can be used to retrieve all available fields in the GOV_CORP_QUOTES view.
from lseg.data.content import search
response = search.metadata.Definition(
view = search.Views.GOV_CORP_QUOTES
).get_data()
response.data.df
| Type | Searchable | Sortable | Navigable | Groupable | Exact | Symbol | |
|---|---|---|---|---|---|---|---|
| AAACurrencyBondBenchmarkChain | String | False | False | False | False | False | False |
| AACurrencyBondBenchmarkChain | String | False | False | False | False | False | False |
| ABSMBSBondsRIC | String | False | False | False | False | False | False |
| ActiveEstimatesExist | Boolean | True | False | False | False | False | False |
| ActivityDate | Date | True | True | True | False | False | False |
| ... | ... | ... | ... | ... | ... | ... | ... |
| ViewsContentType | String | True | False | True | False | True | False |
| WarrantsCount | Double | True | True | True | False | False | False |
| WarrantType | String | True | False | False | False | False | False |
| WarrantTypeName | String | True | False | False | False | False | False |
| Wert | String | True | False | False | True | False | True |
797 rows × 7 columns
Users can then choose the searchable fields and include them in the filter parameter to obtain the instruments they need.
LSEG Workspace – Data Item Browser
-
Purpose: Explore and look up individual data items (fields), including their definitions, codes, and availability across asset classes and views, so users can choose the right fields for screens, templates, and downstream applications.
-
How to open: In LSEG Workspace, use the global search bar to search for “Data Item Browser” (or “DIB”) and launch the Data Item Browser app.

The items found in the Data Item Browser can be used with the ld.get_data method in the LSEG Data Library for Python to retrieve data for those items. For exmample, the following code retrieves the company name, last trade price, and unscaled accumulated number of shares traded for LSEG.L.
Bonds Guide and Speed-Guides
Bonds Guide
In LSEG Workspace, users can access Bonds Guide information by typing BNDG in the global search bar and pressing Enter.

Otherwise, users can still use the speed-guides page RICs to access the reference information.
Speed-Guides
Speed-guides are pre-defined reference pages that list important codes for bonds, indices, news and more.
Key bond-related speed-guides
BONDS– Guide to all bonds. (Chain)TREASURY– Guide to all government bonds. (Chain)EUROBONDS– Guide to all eurobonds. (Page)FUT/IR1– List of interest rate futures. (Page)BENCHMARKS– World benchmarks. (Chain)US/DEBT– US debt data. Use the two-character country code for other countries (for example,DE/DEBTfor Germany). (Chain)DE/DEBT- Germany debt data. (Page)LIQUIDCREDIT– Breakdown of liquid bonds by amount outstanding, rating and currency. (Chain)RPSBONDS– Breakdown of USD-denominated domestic and foreign issues. (Page)CONVERTIBLES– Convertible bonds. (Chain)CDSINDEX– Credit Default Swaps indices. (Chain)
In LSEG Workspace, users can enter a page RIC in the global search bar and press Enter to open the page and view its contents.

The same page data can also be retreived through LSEG Data Library for Python by using page RICs and the ROW80_1 to ROW80_25 fields. However, some speed-guide RICs are chain RICs that contains other speed-guide RICs and the code also handles those speed-guide chain RICs.
import pandas as pd
from lseg.data.discovery import Chain
pd.set_option("future.no_silent_downcasting", True)
RIC = "BONDS"
fields = [f"ROW80_{i}" for i in range(1, 26)] + ["REF_COUNT"]
df = ld.get_data(
universe=RIC,
fields=fields
)
#check if df['REF_COUNT'].iloc[0] is not na, if not print the fields. Otherwise, use Chain to get the constituents and print the fields for each constituent.
if pd.isna(df['REF_COUNT'].iloc[0]):
for i in range(0, len(df)):
print(*df.iloc[i, 1:26], sep="\n")
else:
chain = Chain(RIC)
df = ld.get_data(
universe=chain.constituents,
fields=[f"ROW80_{i}" for i in range(1, 26)]
)
for i in range(0, len(df)):
print(*df.iloc[i, 1:26], sep="\n")
GLOBAL FIXED INCOME GUIDE BONDS1
G L O B A L F I X E D I N C O M E G U I D E
========= SEARCH BY MARKET ========== ========= SEARCH BY COUNTRY =========
COMMERCIAL PAPER...........<CPAPER/1> G20 COUNTRIES..............<G20/DEBT>
CONVERTIBLES...........<CONVERTIBLES> EUROPE/MIDEAST/AFRICA.....<EMEA/DEBT>
CORPORATE DEBT...........<CORPORATES> ASIA/PACIFIC..............<APAC/DEBT>
CREDIT DEFAULT SWAPS.......<CDSINDEX> AMERICAS.................<AMERS/DEBT>
DERIVATIVES...................<DERIV>
EUROBONDS.................<EUROBONDS> ==========SEARCH BY SOURCE===========
EURO MARKETS...............<EUR/DEBT> BROKER GUIDE.................<BROKER>
FUTURES.....................<FUTURES> CONTRIBUTOR GUIDE.....<CONTRIBUTIONS>
GOVERNMENT DEBT............<TREASURY> SPECIALIST SERVICES......<DEBT/SPEC1>
GOVERNMENT STRIPS............<STRIPS> LSEG CAPITAL MARKETS DATA......<RT1>
INSURANCE LINKED SEC...<REFINITIVILS> DEBT INDICES...........<DEBT/INDICES>
ISLAMIC DEBT................<ISLAMIC>
JUMBOS/GLOBALS...............<JUMBOS> =========== BOND TRADING ============
LOANS.....................<CASHLOANS> TRFIT Fixed Income
MEDIUM TERM NOTES..........<MTNINDEX> Transactions..................<TRFIT>
MORTGAGE DEBT..............<MORTGAGE> TRFIT Composite Prices.........<CMPT>
OPTIONS.....................<OPTIONS> TRADEWEB Pricing Service...<TRADEWEB>
SOVEREIGN/MUNICIPAL.......<SOVEREIGN> TRACE Bond Trades.........<NASDBONDS>
PRICING BY MARKET.....<0#FIXEDINCOME>
DEFAULTED BONDS.........<0#DEFAULTED>
GLOBAL FIXED INCOME GUIDE BONDS2
============ NEW ISSUES ============= ======= LSEG PRICING SERVICE =========
NEW ISSUES................<NEWISSUES> US Issuance Bonds.......<0#RRPSBONDS>
European Issuance Bonds.<0#EMEARRPS=>
======== NEWS & INFORMATION ========= Asian Issuance Bonds....<0#ASIARRPS=>
Fixed Income News Guide..<DEBT/NEWS1>
All Debt News...................[DBT] ============== FUTURES ==============
Economic Indicators.........<ECONOMY> G24 Conversion Factors..<G24/FACTOR1>
Global Market Holidays.....<HOLIDAY1> Bond Future Cheapest to Dlvr...<CTD1>
==================== WEB LINK - LSEG FIXED INCOME VIEWS =====================
Search for bonds: Governments/Corporates/MBS/CMO/ABS/Municipals/Loans
Custom market reports: New Issues/Ratings/Redemptions/Defaults/League Tables
Go to <WEBLINKS>
============================================================================
MAIN GUIDE................<LSEG> LSEG HELP................<HELP>
Bond Chain RICs
You can use the following chains to navigate through to the details you need.
Useful chains include:
0#BONDS: Bonds Data0#TREASURY: Treasury Data0#EUROBONDSEurobonds Data0#CURVESInterest Rates0#BDFUTURES: All Bond Futures
These chains may include other chain RICs, so you may need to expand those as well to retrieve the RICs that provide prices.
The following code performs a three‑level expansion of the 0#BONDS chain RIC. By iteratively expanding each nested layer of the chain, the script ultimately uncovers and retrieves the individual RICs that make up the Canada Government Bond Benchmark Curve. These constituent RICs represent the specific benchmark securities used to construct the curve.
from lseg.data.discovery import Chain
chainRIC = '0#BONDS'
chain1 = Chain(chainRIC).constituents[0]
print(chain1)
chain2 = Chain(chain1).constituents[0]
print(chain2)
rics = Chain(chain2).constituents
print(rics)
0#CA-BONDS 0#CABMK= ['CA1MT=RR', 'CA2MT=RR', 'CA3MT=RR', 'CA6MT=RR', 'CA1YT=RR', 'CA2YT=RR', 'CA3YT=RR', 'CA4YT=RR', 'CA5YT=RR', 'CA7YT=RR', 'CA10YT=RR', 'CA20YT=RR', 'CA30YT=RR']
However, the same set of RICs can also be retrieved through the Search API, as shown below. The filter string can be adjusted to provide more precise search results.
ld.discovery.search(
view=ld.discovery.Views.GOV_CORP_QUOTES,
filter=("RCSCurveTypeLeaf xeq 'Government Bond Benchmark Curve Constituent' "
"and RCSCountryLeaf eq 'Canada' "
"and ContributorCommonName xeq 'REFINITIV'"),
top=50
)
| BusinessEntity | DocumentTitle | PI | RIC | |
|---|---|---|---|---|
| 0 | QUOTExFIXEDINCOMExGOVCORP | Canada 10 Year Benchmark, Government Bond Benc... | 0x000386007daf5a0d | CA10YT=RR |
| 1 | QUOTExFIXEDINCOMExGOVCORP | Canada 2 Year Benchmark, Government Bond Bench... | 0x000386007dad5f0a | CA2YT=RR |
| 2 | QUOTExFIXEDINCOMExGOVCORP | Canada 5 Year Benchmark, Government Bond Bench... | 0x000386007dad6336 | CA5YT=RR |
| 3 | QUOTExFIXEDINCOMExGOVCORP | Canada 1 Year Benchmark, Government Bond Bench... | 0x000386007daf5b0c | CA1YT=RR |
| 4 | QUOTExFIXEDINCOMExGOVCORP | Canada 3 Month Benchmark, Government Bond Benc... | 0x000386007dad6035 | CA3MT=RR |
| 5 | QUOTExFIXEDINCOMExGOVCORP | Canada 1 Month Benchmark, Government Bond Benc... | 0x000386007dad5d08 | CA1MT=RR |
| 6 | QUOTExFIXEDINCOMExGOVCORP | Canada 6 Month Benchmark, Government Bond Benc... | 0x000386007dad6431 | CA6MT=RR |
| 7 | QUOTExFIXEDINCOMExGOVCORP | Canada 3 Year Benchmark, Government Bond Bench... | 0x000386007dad6134 | CA3YT=RR |
| 8 | QUOTExFIXEDINCOMExGOVCORP | Canada 2 Month Benchmark, Government Bond Benc... | 0x000386007dad5e0b | CA2MT=RR |
| 9 | QUOTExFIXEDINCOMExGOVCORP | Canada 7 Year Benchmark, Government Bond Bench... | 0x000386007dad6530 | CA7YT=RR |
| 10 | QUOTExFIXEDINCOMExGOVCORP | Canada 4 Year Benchmark, Government Bond Bench... | 0x000386007dad6237 | CA4YT=RR |
| 11 | QUOTExFIXEDINCOMExGOVCORP | Canada 30 Year Benchmark, Government Bond Benc... | 0x000386007daf5e09 | CA30YT=RR |
| 12 | QUOTExFIXEDINCOMExGOVCORP | Canada 20 Year Benchmark, Government Bond Benc... | 0x000386007daf5d0a | CA20YT=RR |
The General Structure of Bond RICs
Fixed income RICs are composed of several parts. Generally, a bond RIC has the following components:

Country Code
The country code is the ISO 3166 two-letter code specifying the country of issue. Typically it simply uses the first two letters of the currency code, which represents the country code, e.g. AT for Austria or FR for France
Official Code (Local Code)
The local code used varies from market to market and LSEG supports the full range of ID numbering agencies.
Some countries do not have an official code and have adopted a local market convention or a LSEG-derived code
Delimiter
The delimiter is always =.
Source Code
The source code tells you where the price comes from; typically this is either a contributor or an exchange.
-
Contributor codes are used for OTC-traded instruments.
- Example:
DE113505=BAYM– Bund 6 7/8 quoted by Bayerische Landesbank in Munich (BAYM). - You can find a list of contributor codes on page
TREASURYID.
- Example:
-
Exchange codes are one or two characters long:
F– Frankfurt.L– London.LU– Luxembourg.PMI– Swedish Summary Information exchange.- Example:
DE113514=F– Bund 6 1/4 on the Frankfurt Stock Exchange.
You can also use the Search API to search for bond RICs.
For example, the code below uses the Search API to search for Germany’s long‑term federal bond RICs contributed by the Frankfurt Stock Exchange. The filter string can be adjusted to provide more precise search results.
ld.discovery.search(
view=ld.discovery.Views.GOV_CORP_QUOTES,
filter="ContributorCode xeq 'F' and RCSGovtBondTypeLeaf eq 'Bund'",
top=10
)
| BusinessEntity | DocumentTitle | PermID | PI | RIC | |
|---|---|---|---|---|---|
| 0 | QUOTExFIXEDINCOMExGOVCORP | Germany, Federal Republic of (Government), Bon... | 55836404089 | 0x000405000bb400be | DE113517=F |
| 1 | QUOTExFIXEDINCOMExGOVCORP | Germany, Federal Republic of (Government), Bon... | <NA> | 0x00102c93548e2154 | DE110251=F |
| 2 | QUOTExFIXEDINCOMExGOVCORP | Germany, Federal Republic of (Government), Bon... | <NA> | 0x001055baf1f418e2 | DEBU3Z04=F |
| 3 | QUOTExFIXEDINCOMExGOVCORP | Germany, Federal Republic of (Government), Bon... | <NA> | 0x001055b3c857066f | DEBU2700=F |
| 4 | QUOTExFIXEDINCOMExGOVCORP | Germany, Federal Republic of (Government), Bon... | <NA> | 0x00102cad31b8263e | DE110253=F |
| 5 | QUOTExFIXEDINCOMExGOVCORP | Germany, Federal Republic of (Government), Bon... | <NA> | 0x00105521d41a1cb6 | DEBU2Z05=F |
| 6 | QUOTExFIXEDINCOMExGOVCORP | Germany, Federal Republic of (Government), Bon... | <NA> | 0x001055d898530b5d | DEBU2D00=F |
| 7 | QUOTExFIXEDINCOMExGOVCORP | Germany, Federal Republic of (Government), Bon... | <NA> | 0x0010554e90fa0362 | DEBU3Z00=F |
| 8 | QUOTExFIXEDINCOMExGOVCORP | Germany, Federal Republic of (Government), Bon... | <NA> | 0x00102c4d49b3179c | DE110246=F |
| 9 | QUOTExFIXEDINCOMExGOVCORP | Germany, Federal Republic of (Government), Bon... | <NA> | 0x00102cc957d01e6c | DE110249=F |
Super RICs
Super RICs show key data for a bond, including:
- The last three contributed prices.
- Additional information such as Open/High/Low/Close.
- Calculated values (depending on the type of bond).
Super RICs have the same structure as government and treasury bonds described above, except that there is no source code at the end.
Example:
DE113514=
For most major bond types, including eurobonds and treasuries, the key data displayed includes:
-
Real-time spread to benchmark.
-
Real-time spread to interest-rate swap.
-
Real-time spread to asset swap.
-
Native and ISMA yield to maturity.
-
Accrued interest.
-
Modified duration.
-
Convexity.
-
Basis Point Value.
-
Reference data (including credit rating and clearing code).
Data can be retrieved using the ld.get_data method, while the Data Item Browser tool allows you to search for available fields.
ld.get_data(
universe = ['DE113514='],
fields = ['TR.FiDebtType','TR.FiCountryName','TR.FiMaturityDate','TR.FiMaturityStandardYield']
)
| Instrument | Debt Type | Country Name | Maturity Date | Yield To Maturity | |
|---|---|---|---|---|---|
| 0 | DE113514= | BUND | Germany | 2030-01-04 | 2.253116 |
Chain – contributed prices for the secondary (OTC) market
Often, the easiest way to find a bond is to start with the chain displays of OTC-traded bonds for each country.
To construct a chain RIC, prefix the code with 0#.
For the secondary (OTC) market, the chains show:
- Details of different issues.
- Contributed prices from a range of market players.
The code is made up of:
- The two-character country code
- The instrument indicator
- The delimiter
Example (Germany):

This shows all instruments in that chain – short-, medium- and long-term issues.
You can view a single part of the chain by adding S (short), M (medium) or L (long) at the end:
0#DETSYS=– short-term bonds.0#DETSYM=– medium-term bonds.0#DETSYL=– long-term bonds.
You can use the Chain class and the ld.get_data method to expand chains and retrieve data.
from lseg.data.discovery import Chain
RICs = Chain('0#DETSY=').constituents
ld.get_data(
universe=RICs,
fields = ['TR.FiDebtType','TR.FiCountryName','TR.FiMaturityDate','TR.FiMaturityStandardYield']
)
| Instrument | Debt Type | Country Name | Maturity Date | Yield To Maturity | |
|---|---|---|---|---|---|
| 0 | DEBU0E27= | BUBL | Germany | 2026-03-18 | 1.981308 |
| 1 | DEBU2204= | SCHATZE | Germany | 2026-03-19 | 2.276516 |
| 2 | DE114183= | BOBL | Germany | 2026-04-10 | 2.131777 |
| 3 | DEBU0E28= | BUBL | Germany | 2026-04-15 | 1.903015 |
| 4 | DEBU0E29= | BUBL | Germany | 2026-05-13 | 1.902104 |
| ... | ... | ... | ... | ... | ... |
| 90 | DE110261= | BUND | Germany | 2053-08-15 | 3.390463 |
| 91 | DE103075= | BUND | Germany | 2053-08-15 | 3.380459 |
| 92 | DEBU4Z06= | PRIN | Germany | 2054-08-15 | 3.651016 |
| 93 | DEBU2D00= | BUND | Germany | 2054-08-15 | 3.386719 |
| 94 | DEBU2D01= | BUND | Germany | 2056-08-15 | 3.39398 |
95 rows × 5 columns
The Search API can also be used to search for the required bond RICs, as shown below. The filter string can be adjusted to provide more precise search results.
ld.discovery.search(
view=ld.discovery.Views.GOV_CORP_QUOTES,
filter = ("AssetType eq 'DEBT' "
"and RCSCountryLeaf eq 'Germany' "
"and ContributorTypeName eq 'LSEG' "
"and DbType eq 'GOVT' "
"and PriceSource eq 'REFINITIV COMPOSITE' "
"and IsBondQuote eq true"),
top=10)
| BusinessEntity | DocumentTitle | PI | RIC | |
|---|---|---|---|---|
| 0 | QUOTExFIXEDINCOMExGOVCORP | Germany, Federal Republic of (Government), Bon... | 0x0010559bf7d80afb | DEBU2502= |
| 1 | QUOTExFIXEDINCOMExGOVCORP | Germany, Federal Republic of (Government), Bon... | 0x001055ed71f51834 | DEBU3Z04= |
| 2 | QUOTExFIXEDINCOMExGOVCORP | Germany, Federal Republic of (Government), Bon... | 0x001055081cf9238b | DEBU2Z06= |
| 3 | QUOTExFIXEDINCOMExGOVCORP | Germany, Federal Republic of (Government), Bon... | 0x001055b24c30058e | DE103075= |
| 4 | QUOTExFIXEDINCOMExGOVCORP | Germany, Federal Republic of (Government), Bon... | 0x001055fea0131c14 | DEBU2Z05= |
| 5 | QUOTExFIXEDINCOMExGOVCORP | Germany, Federal Republic of (Government), Bon... | 0x001055e9b4991c9d | DEBU2210= |
| 6 | QUOTExFIXEDINCOMExGOVCORP | Germany, Federal Republic of (Government), Bon... | 0x00102cbaa88b2184 | DE110251= |
| 7 | QUOTExFIXEDINCOMExGOVCORP | Germany, Federal Republic of (Government), Bon... | 0x0010552e5bea0fd5 | DEBU4Z06= |
| 8 | QUOTExFIXEDINCOMExGOVCORP | Germany, Federal Republic of (Government), Bon... | 0x001055863ded0516 | DEBU2Z01= |
| 9 | QUOTExFIXEDINCOMExGOVCORP | Germany, Federal Republic of (Government), Bon... | 0x00102c1f9f95351c | DE110262= |
Competing Market Maker chains
For a single treasury issue, you can view a chain of competing Market Makers.
The code structure is: 0#DE113514=.
You can use the Chain class and the ld.get_data method to expand chains and retrieve data.
from lseg.data.discovery import Chain
RICs = Chain('0#DE113514=').constituents
ld.get_data(
universe=RICs,
fields = ['TR.FiIssuerName','TR.FiDebtType','TR.FiCountryName',
'TR.FiMaturityDate','TR.FiMaturityStandardYield','TR.FIMaturityCorpConvexity']
).dropna()
C:\Users\jphuriph\AppData\Roaming\Python\Python312\site-packages\lseg\data_tools_dataframe.py:177:FutureWarning: Downcasting object dtype arrays on .fillna, .ffill, .bfill is deprecated and will change in a future version. Call result.infer_objects(copy=False) instead. To opt-in to the future behavior, set pd.set_option('future.no_silent_downcasting', True)
| Instrument | Issuer Name | Debt Type | Country Name | Maturity Date | Yield To Maturity | Convexity | |
|---|---|---|---|---|---|---|---|
| 1 | DE0001135143=TWEB | GERMANY, FEDERAL REPUBLIC OF (GOVERNMENT) | BUND | Germany | 2030-01-04 | 2.253116 | 0.144166 |
| 2 | DE000113514=1M | GERMANY, FEDERAL REPUBLIC OF (GOVERNMENT) | BUND | Germany | 2030-01-04 | 2.253116 | 0.144166 |
| 4 | DE0001135143=BAYM | GERMANY, FEDERAL REPUBLIC OF (GOVERNMENT) | BUND | Germany | 2030-01-04 | 2.253116 | 0.144166 |
| 5 | DE0001135143=CALP | GERMANY, FEDERAL REPUBLIC OF (GOVERNMENT) | BUND | Germany | 2030-01-04 | 2.253116 | 0.144166 |
| 6 | DE113514=CALP | GERMANY, FEDERAL REPUBLIC OF (GOVERNMENT) | BUND | Germany | 2030-01-04 | 2.253116 | 0.144166 |
| 7 | DE0001135143=DDBK | GERMANY, FEDERAL REPUBLIC OF (GOVERNMENT) | BUND | Germany | 2030-01-04 | 2.253116 | 0.144166 |
| 8 | DE0001135143=DEKA | GERMANY, FEDERAL REPUBLIC OF (GOVERNMENT) | BUND | Germany | 2030-01-04 | 2.253116 | 0.144166 |
| 9 | DE0001135143=DZBF | GERMANY, FEDERAL REPUBLIC OF (GOVERNMENT) | BUND | Germany | 2030-01-04 | 2.253116 | 0.144166 |
| 10 | DE0001135143=HELE | GERMANY, FEDERAL REPUBLIC OF (GOVERNMENT) | BUND | Germany | 2030-01-04 | 2.253116 | 0.144166 |
| 11 | DE0001135143=HVBG | GERMANY, FEDERAL REPUBLIC OF (GOVERNMENT) | BUND | Germany | 2030-01-04 | 2.253116 | 0.144166 |
| 12 | DE0001135143=JPML | GERMANY, FEDERAL REPUBLIC OF (GOVERNMENT) | BUND | Germany | 2030-01-04 | 2.253116 | 0.144166 |
| 13 | DE0001135143=LBBW | GERMANY, FEDERAL REPUBLIC OF (GOVERNMENT) | BUND | Germany | 2030-01-04 | 2.253116 | 0.144166 |
| 14 | DE0001135143=LUSG | GERMANY, FEDERAL REPUBLIC OF (GOVERNMENT) | BUND | Germany | 2030-01-04 | 2.253116 | 0.144166 |
| 15 | DE0001135143=NDEA | GERMANY, FEDERAL REPUBLIC OF (GOVERNMENT) | BUND | Germany | 2030-01-04 | 2.253116 | 0.144166 |
| 16 | DE0001135143=NOLB | GERMANY, FEDERAL REPUBLIC OF (GOVERNMENT) | BUND | Germany | 2030-01-04 | 2.253116 | 0.144166 |
| 17 | DE0001135143=NXIP | GERMANY, FEDERAL REPUBLIC OF (GOVERNMENT) | BUND | Germany | 2030-01-04 | 2.253116 | 0.144166 |
| 18 | DE0001135143=SGEP | GERMANY, FEDERAL REPUBLIC OF (GOVERNMENT) | BUND | Germany | 2030-01-04 | 2.253116 | 0.144166 |
| 20 | DE0001135143=ICAP | GERMANY, FEDERAL REPUBLIC OF (GOVERNMENT) | BUND | Germany | 2030-01-04 | 2.253116 | 0.144166 |
| 21 | DE0001135143=TMKR | GERMANY, FEDERAL REPUBLIC OF (GOVERNMENT) | BUND | Germany | 2030-01-04 | 2.253116 | 0.144166 |
| 23 | DE113514=RRPS | GERMANY, FEDERAL REPUBLIC OF (GOVERNMENT) | BUND | Germany | 2030-01-04 | 2.253116 | 0.144166 |
The Search API can also be used to search for the required bond RICs, as shown below. The filter string can be adjusted to provide more precise search results.
ld.discovery.search(
view=ld.discovery.Views.GOV_CORP_QUOTES,
filter = "MainSuperRIC eq 'DE113514='",
select = "DocumentTitle,RIC,ContributorCommonName,MaturityDate,IssueCouponRateFormatted",
top=100)
| DocumentTitle | RIC | ContributorCommonName | MaturityDate | IssueCouponRateFormatted | |
|---|---|---|---|---|---|
| 0 | Germany, Federal Republic of (Government), Bon... | DE000113514=2M | MARKETAXESS L2 | 2030-01-04 | 6.25 |
| 1 | Germany, Federal Republic of (Government), Bon... | DE000113514=1M | MARKETAXESS | 2030-01-04 | 6.25 |
| 2 | Germany, Federal Republic of (Government), Bon... | DE0001135143=ICTO | ICAP EU OTF | 2030-01-04 | 6.25 |
| 3 | Germany, Federal Republic of (Government), Bon... | DE0001135143=MKCP | MARKETAXESS COMPOSITE PLUS | 2030-01-04 | 6.25 |
| 4 | Germany, Federal Republic of (Government), Bon... | DE0001135143=TBEM | TRADEWEB EU B.V. - MTF | 2030-01-04 | 6.25 |
| ... | ... | ... | ... | ... | ... |
| 65 | Germany, Federal Republic of (Government), Bon... | DE0001135143=TRU | TRADEECHO APA EU | 2030-01-04 | 6.25 |
| 66 | Germany, Federal Republic of (Government), Bon... | DE0001135143=TWFT | TRADEWEB/FTSE | 2030-01-04 | 6.25 |
| 67 | Germany, Federal Republic of (Government), Bon... | DE0001135143=TWMK | TRADEWEB MARKS | 2030-01-04 | 6.25 |
| 68 | Germany, Federal Republic of (Government), Bon... | DE0001135143=VALR | VALMER | 2030-01-04 | 6.25 |
| 69 | Germany, Federal Republic of (Government), Bon... | DE0001135143SP=VALR | VALMER | 2030-01-04 | 6.25 |
70 rows × 5 columns
Chains by Market Maker
You can view a chain of all treasury bonds quoted by a specific primary dealer or Market Maker using the structure:
[CountryCode][InstrumentIndicator]=[MarketMakerID]
Example (French primary dealer):
0#FRTSY=RRPS
Where:
FR– country code for France.TSY– instrument indicator for treasury bond.RRPS– Market Maker ID for Refintiv Evaluated.
You can use the Quote appliation in the LSEG Workspace to open this chain.

You can use the Chain class and the ld.get_data method to expand chains and retrieve data.
from lseg.data.discovery import Chain
RICs = Chain('0#FRTSY=RRPS').constituents
ld.get_data(
universe=RICs,
fields = ['DSPLY_NAME','COUPN_RATE','MATUR_DATE','CURRENCY',
'ACT_TP_1','PRIMACT_1','SEC_ACT_1','BOND_TYPE',
'RT_YIELD_1','SEC_YLD_1','GEN_VAL1','GEN_VAL2']
)
| Instrument | DSPLY_NAME | COUPN_RATE | MATUR_DATE | CURRENCY | ACT_TP_1 | PRIMACT_1 | SEC_ACT_1 | BOND_TYPE | RT_YIELD_1 | SEC_YLD_1 | GEN_VAL1 | GEN_VAL2 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | FR0010916924=RRPS | FRANCE | 3.5 | 2026-04-25 | EUR | B | 100.16 | 100.17 | STR | 2.160878 | 2.101878 | 17.129 | -8.975 |
| 1 | FR0013131877=RRPS | FRANCE | 0.5 | 2026-05-25 | EUR | B⇧ | 99.66 | 99.67 | STR | 2.131703 | 2.077703 | 14.257 | -11.887 |
| 2 | FR001400FYQ4=RRPS | FRANCE | 2.5 | 2026-09-24 | EUR | B | 100.16 | 100.17 | STR | 2.17667 | 2.15067 | 8.5441 | -9.8719 |
| 3 | FR0013200813=RRPS | FRANCE | 0.25 | 2026-11-25 | EUR | B | 98.63 | 98.65 | STR | 2.201851 | 2.177851 | 10.134 | -8.26 |
| 4 | FR0014003513=RRPS | FRANCE | 0.0 | 2027-02-25 | EUR | B⇧ | 97.89 | 97.91 | STR | 2.235086 | 2.209086 | 7.9469 | -4.1914 |
| 5 | FR0013250560=RRPS | FRANCE | 1.0 | 2027-05-25 | EUR | B⇧ | 98.5 | 98.53 | STR | 2.271078 | 2.248078 | 14.29 | -1.066 |
| 6 | FR001400NBC6=RRPS | FRANCE | 2.5 | 2027-09-24 | EUR | B⇧ | 100.26 | 100.29 | STR | 2.321702 | 2.303702 | 12.0927 | -0.2524 |
| 7 | FR0011317783=RRPS | FRANCE | 2.75 | 2027-10-25 | EUR | B⇧ | 100.66 | 100.69 | STR | 2.327336 | 2.306336 | 11.96 | -1.152 |
| 8 | FR001400AIN5=RRPS | FRANCE | 0.75 | 2028-02-25 | EUR | B | 96.93 | 96.97 | STR | 2.367726 | 2.346726 | 14.4484 | -1.7044 |
| 9 | FR0013286192=RRPS | FRANCE | 0.75 | 2028-05-25 | EUR | B | 96.49 | 96.53 | STR | 2.400319 | 2.382319 | 17.727 | 0.14 |
| 10 | FR001400XLW2=RRPS | FRANCE | 2.4 | 2028-09-24 | EUR | B | 99.88 | 99.95 | STR | 2.446302 | 2.416302 | 21.8257 | 3.129 |
| 11 | FR0013341682=RRPS | FRANCE | 0.75 | 2028-11-25 | EUR | B⇧ | 95.54 | 95.58 | STR | 2.46952 | 2.45452 | 24.377 | 4.76 |
| 12 | FR001400HI98=RRPS | FRANCE | 2.75 | 2029-02-25 | EUR | B⇧ | 100.71 | 100.75 | STR | 2.498123 | 2.483123 | 27.3898 | 6.4084 |
| 13 | FR0000571218=RRPS | FRANCE | 5.5 | 2029-04-25 | EUR | B⇧ | 108.85 | 108.92 | STR | 2.518025 | 2.497025 | 29.552 | 7.459 |
| 14 | FR0013407236=RRPS | FRANCE | 0.5 | 2029-05-25 | EUR | B⇧ | 93.78 | 93.82 | STR | 2.543132 | 2.528132 | 18.023 | 9.345 |
| 15 | FR0014016G71=RRPS | FRANCE | 2.4 | 2029-09-24 | EUR | B⇧ | 99.38 | 99.42 | STR | 2.583128 | 2.571128 | 22.3989 | 11.3446 |
| 16 | FR0013451507=RRPS | FRANCE | 0.0 | 2029-11-25 | EUR | B⇧ | 90.89 | 90.93 | STR | 2.606442 | 2.593442 | 23.844 | 11.768 |
| 17 | FR001400PM68=RRPS | FRANCE | 2.75 | 2030-02-25 | EUR | B⇧ | 100.37 | 100.41 | STR | 2.650119 | 2.638119 | 29.8308 | 15.7766 |
| 18 | FR0011883966=RRPS | FRANCE | 2.5 | 2030-05-25 | EUR | B⇧ | 99.29 | 99.34 | STR | 2.679265 | 2.667265 | 32.391 | 16.725 |
| 19 | FR0013516549=RRPS | FRANCE | 0.0 | 2030-11-25 | EUR | B⇧ | 87.97 | 88.01 | STR | 2.757308 | 2.746308 | 28.76 | 20.787 |
| 20 | FR001400Z2L7=RRPS | FRANCE | 2.7 | 2031-02-25 | EUR | B⇧ | 99.52 | 99.59 | STR | 2.804644 | 2.789644 | 33.0994 | 23.4732 |
| 21 | FR0012993103=RRPS | FRANCE | 1.5 | 2031-05-25 | EUR | B⇧ | 93.64 | 93.69 | STR | 2.829787 | 2.819787 | 35.546 | 24.213 |
| 22 | FR0014002WK3=RRPS | FRANCE | 0.0 | 2031-11-25 | EUR | B⇧ | 84.91 | 84.95 | STR | 2.904996 | 2.895996 | 43.2947 | 28.3129 |
| 23 | FR0014007L00=RRPS | FRANCE | 0.0 | 2032-05-25 | EUR | B⇧ | 83.27 | 83.32 | STR | 2.992938 | 2.982938 | 38.8573 | 33.9466 |
| 24 | FR0000187635=RRPS | FRANCE | 5.75 | 2032-10-25 | EUR | B⇧ | 116.25 | 116.34 | STR | 3.005828 | 2.991828 | 40.39 | 33.249 |
| 25 | FR001400BKZ3=RRPS | FRANCE | 2.0 | 2032-11-25 | EUR | B⇧ | 93.62 | 93.67 | STR | 3.065026 | 3.057026 | 46.2574 | 38.6643 |
| 26 | FR001400H7V7=RRPS | FRANCE | 3.0 | 2033-05-25 | EUR | B⇧ | 99.13 | 99.17 | STR | 3.13552 | 3.12952 | 48.2357 | 43.1838 |
| 27 | FR001400L834=RRPS | FRANCE | 3.5 | 2033-11-25 | EUR | B⇧ | 101.99 | 102.02 | STR | 3.203027 | 3.198027 | 53.2027 | 46.421 |
| 28 | FR0013313582=RRPS | FRANCE | 1.25 | 2034-05-25 | EUR | B⇧ | 85.55 | 85.6 | STR | 3.28669 | 3.27869 | 55.976 | 53.136 |
| 29 | FR001400QMF9=RRPS | FRANCE | 3.0 | 2034-11-25 | EUR | B⇧ | 97.5 | 97.54 | STR | 3.334015 | 3.329015 | 60.5376 | 55.7218 |
| 30 | FR0010070060=RRPS | FRANCE | 4.75 | 2035-04-25 | EUR | B⇧ | 110.69 | 110.81 | STR | 3.368759 | 3.353759 | 63.992 | 57.44 |
| 31 | FR001400X8V5=RRPS | FRANCE | 3.2 | 2035-05-25 | EUR | B⇧ | 98.46 | 98.54 | STR | 3.396423 | 3.386423 | 56.4539 | 59.8127 |
| 32 | FR0014012II5=RRPS | FRANCE | 3.5 | 2035-11-25 | EUR | B⇧ | 100.32 | 100.48 | STR | 3.459151 | 3.439151 | 62.7076 | 63.6784 |
| 33 | FR0013154044=RRPS | FRANCE | 1.25 | 2036-05-25 | EUR | B⇧ | 80.66 | 80.73 | STR | 3.540001 | 3.531001 | 70.778 | 69.449 |
| 34 | FR0014009O62=RRPS | FRANCE | 1.25 | 2038-05-25 | EUR | B⇧ | 76.15 | 76.22 | STR | 3.715076 | 3.707076 | 88.2401 | 78.9179 |
| 35 | FR0010371401=RRPS | FRANCE | 4.0 | 2038-10-25 | EUR | B⇧ | 103.13 | 103.21 | STR | 3.683865 | 3.675865 | 49.685 | 74.329 |
| 36 | FR0013234333=RRPS | FRANCE | 1.75 | 2039-06-25 | EUR | B⇧ | 79.3 | 79.37 | STR | 3.755982 | 3.747982 | 56.806 | 79.215 |
| 37 | FR0013515806=RRPS | FRANCE | 0.5 | 2040-05-25 | EUR | B⇧ | 63.76 | 63.83 | STR | 3.861638 | 3.853638 | 67.5 | 87.293 |
| 38 | FR0010773192=RRPS | FRANCE | 4.5 | 2041-04-25 | EUR | B⇧ | 107.5 | 107.58 | STR | 3.836439 | 3.829439 | 64.957 | 82.568 |
| 39 | FR001400WYO4=RRPS | FRANCE | 3.6 | 2042-05-25 | EUR | B⇧ | 96.03 | 96.15 | STR | 3.934953 | 3.924953 | 74.724 | 89.9171 |
| 40 | FR001400CMX2=RRPS | FRANCE | 2.5 | 2043-05-25 | EUR | B⇧ | 81.63 | 81.67 | STR | 3.996013 | 3.992013 | 80.6585 | 93.8462 |
| 41 | FR0014002JM6=RRPS | FRANCE | 0.5 | 2044-06-25 | EUR | B⇧ | 54.8 | 54.9 | STR | 4.043709 | 4.032709 | 70.5518 | 98.2092 |
| 42 | FR0011461037=RRPS | FRANCE | 3.25 | 2045-05-25 | EUR | B⇧ | 89.54 | 89.59 | STR | 4.042687 | 4.038687 | 70.323 | 97.021 |
| 43 | FR0014015MU5=RRPS | FRANCE | 4.1 | 2046-05-25 | EUR | B⇧ | 100.12 | 100.26 | STR | 4.090157 | 4.080157 | 75.5038 | 102.8361 |
| 44 | FR0013257524=RRPS | FRANCE | 2.0 | 2048-05-25 | EUR | B⇧ | 68.91 | 68.98 | STR | 4.174264 | 4.168264 | 83.393 | 110.945 |
| 45 | FR001400NEF3=RRPS | FRANCE | 3.0 | 2049-06-25 | EUR | B | 82.67 | 82.75 | STR | 4.177163 | 4.171163 | 73.7064 | 111.6051 |
| 46 | FR0013404969=RRPS | FRANCE | 1.5 | 2050-05-25 | EUR | B | 59.18 | 59.23 | STR | 4.225254 | 4.220254 | 78.5 | 116.893 |
| 47 | FR0013480613=RRPS | FRANCE | 0.75 | 2052-05-25 | EUR | B⇧ | 44.99 | 45.05 | STR | 4.283073 | 4.277073 | 84.69 | 124.425 |
| 48 | FR0014004J31=RRPS | FRANCE | 0.75 | 2053-05-25 | EUR | B⇧ | 43.63 | 43.68 | STR | 4.307092 | 4.302092 | 86.7092 | 127.2367 |
| 49 | FR001400FTH3=RRPS | FRANCE | 3.0 | 2054-05-25 | EUR | B⇧ | 78.75 | 78.85 | STR | 4.316476 | 4.309476 | 87.5146 | 129.8743 |
| 50 | FR0010171975=RRPS | FRANCE | 4.0 | 2055-04-25 | EUR | B⇧ | 94.95 | 95.12 | STR | 4.306996 | 4.295996 | 86.835 | 130.02 |
| 51 | FR001400OHF4=RRPS | FRANCE | 3.25 | 2055-05-25 | EUR | B⇧ | 82.23 | 82.37 | STR | 4.333347 | 4.323347 | 89.5165 | 132.7751 |
| 52 | FR001400XJJ3=RRPS | FRANCE | 3.75 | 2056-05-25 | EUR | B⇧ | 89.989 | 90.221 | STR | 4.351015 | 4.336015 | 91.5051 | 135.6906 |
| 53 | FR0014016CV2=RRPS | FRANCE | 4.4 | 2057-05-25 | EUR | B⇧ | 100.44 | 100.61 | STR | 4.372969 | 4.362969 | 93.7175 | 138.9317 |
| 54 | FR0010870956=RRPS | FRANCE | 4.0 | 2060-04-25 | EUR | B⇧ | 93.57 | 93.75 | STR | 4.365262 | 4.354262 | 92.9 | 141.118 |
| 55 | FR0013154028=RRPS | FRANCE | 1.75 | 2066-05-25 | EUR | B⇧ | 51.4 | 51.91 | STR | 4.317085 | 4.274085 | 88.134 | 142.654 |
| 56 | FR0014001NN8=RRPS | FRANCE | 0.5 | 2072-05-25 | EUR | B⇧ | 26.17 | 26.61 | STR | 4.069609 | 4.019609 | 63.441 | 125.2698 |
The Search API can also be used to search for the required bond RICs, as shown below. The filter string can be adjusted to provide more precise search results.
ld.discovery.search(
view=ld.discovery.Views.GOV_CORP_QUOTES,
filter = (
"ContributorCode eq 'RRPS' "
"and IsBondQuote eq true "
"and AssetType eq 'DEBT' "
"and IssuerTicker eq 'FRGOVT' "
"and RCSGovtBondTypeLeaf eq 'OAT'"
),
select = "DocumentTitle,RIC,ContributorCommonName,MaturityDate,IssueCouponRateFormatted",
top=10)
| DocumentTitle | RIC | ContributorCommonName | MaturityDate | IssueCouponRateFormatted | |
|---|---|---|---|---|---|
| 0 | France, Republic of (Government), Bond Quote, ... | FR001400Z2L7=RRPS | REFINITIV EVALUATED | 2031-02-25 | 2.7 |
| 1 | France, Republic of (Government), Bond Quote, ... | FR0013200813=RRPS | REFINITIV EVALUATED | 2026-11-25 | 0.25 |
| 2 | France, Republic of (Government), Bond Quote, ... | FR001400IKW5=RRPS | REFINITIV EVALUATED | 2039-03-01 | 0.55 |
| 3 | France, Republic of (Government), Bond Quote, ... | FR0013257524=RRPS | REFINITIV EVALUATED | 2048-05-25 | 2.0 |
| 4 | France, Republic of (Government), Bond Quote, ... | FR001400H7V7=RRPS | REFINITIV EVALUATED | 2033-05-25 | 3.0 |
| 5 | France, Republic of (Government), Bond Quote, ... | FR001400XJJ3=RRPS | REFINITIV EVALUATED | 2056-05-25 | 3.75 |
| 6 | France, Republic of (Government), Bond Quote, ... | FR0010447367=RRPS | REFINITIV EVALUATED | 2040-07-25 | 1.8 |
| 7 | France, Republic of (Government), Bond Quote, ... | FR0010371401=RRPS | REFINITIV EVALUATED | 2038-10-25 | 4.0 |
| 8 | France, Republic of (Government), Bond Quote, ... | FR0013480613=RRPS | REFINITIV EVALUATED | 2052-05-25 | 0.75 |
| 9 | France, Republic of (Government), Bond Quote, ... | FR001400BKZ3=RRPS | REFINITIV EVALUATED | 2032-11-25 | 2.0 |
Benchmark Chains
The RIC code for a specific benchmark is in this format:

You can use the Quote appliation in the LSEG Workspace to open this chain.

from lseg.data.discovery import Chain
RICs = Chain('0#USBMK=').constituents
ld.get_data(
universe=RICs,
fields = ['DSPLY_NAME','COUPN_RATE','MATUR_DATE','CURRENCY','ACT_TP_1','PRIMACT_1','SEC_ACT_1','BOND_TYPE','RT_YIELD_1','SEC_YLD_1','BMK_SPD','SWAP_SPRD']
)
| Instrument | DSPLY_NAME | COUPN_RATE | MATUR_DATE | CURRENCY | ACT_TP_1 | PRIMACT_1 | SEC_ACT_1 | BOND_TYPE | RT_YIELD_1 | SEC_YLD_1 | BMK_SPD | SWAP_SPRD | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | US1MT=RR | US 1M T-BILL | 0 | 2026-04-07 | USD | B⇩ | 3.645 | 3.625 | STR | 3.7076 | 3.6872 | 0 | 4.9 |
| 1 | US6WK=RR | US 6W T-BILL | 0 | 2026-04-16 | USD | B⇧ | 3.655 | 3.615 | STR | 3.7186 | 3.6778 | 0 | 6.2 |
| 2 | US2MT=RR | US 2M T-BILL | 0 | 2026-05-05 | USD | B⇩ | 3.6375 | 3.6175 | STR | 3.7105 | 3.69 | 0 | 5.2 |
| 3 | US3MT=RR | US 3M T-BILL | 0 | 2026-06-04 | USD | B⇩ | 3.6 | 3.57 | STR | 3.6794 | 3.6485 | 0 | 1.9 |
| 4 | US4MT=RR | US 4M T-BILL | 0 | 2026-07-07 | USD | B⇩ | 3.5975 | 3.5775 | STR | 3.6891 | 3.6684 | 0 | 3.8 |
| 5 | US6MT=RR | US 6M T-BILL | 0 | 2026-09-03 | USD | B⇩ | 3.5425 | 3.515 | STR | 3.6532 | 3.6243 | 0 | 2.3 |
| 6 | US1YT=RR | US 1Y T-BILL | 0 | 2027-02-18 | USD | B⇩ | 3.455 | 3.42 | STR | 3.5928 | 3.5555 | 0 | 5.3 |
| 7 | US2YT=RR | US 2Y T-NOTE | 3.375 | 2028-02-29 | USD | B⇩ | 99.605469 | 99.609375 | STR | 3.5833 | 3.5812 | 0 | 19.0 |
| 8 | US3YT=RR | US 3Y T-NOTE | 3.5 | 2029-02-15 | USD | B⇧ | 99.71875 | 99.722656 | STR | 3.6011 | 3.5997 | 0 | 23.7 |
| 9 | US5YT=RR | US 5Y T-NOTE | 3.5 | 2031-02-28 | USD | B⇧ | 98.953125 | 98.960938 | STR | 3.7323 | 3.7306 | 0 | 31.5 |
| 10 | US7YT=RR | US 7Y T-NOTE | 3.75 | 2033-02-28 | USD | B⇧ | 98.929688 | 98.9375 | STR | 3.9268 | 3.9255 | 0 | 40.3 |
| 11 | US10YT=RR | US 10Y T-NOTE | 4.125 | 2036-02-15 | USD | B⇧ | 99.875 | 99.890625 | STR | 4.1402 | 4.1383 | 0 | 45.9 |
| 12 | US20YT=RR | US 20Y T-BOND | 4.625 | 2046-02-15 | USD | B⇩ | 98.734375 | 98.765625 | STR | 4.7235 | 4.721 | 0 | 73.9 |
| 13 | US30YT=RR | US 30Y T-BOND | 4.75 | 2056-02-15 | USD | B⇩ | 99.90625 | 99.9375 | STR | 4.7557 | 4.7537 | 0 | 77.8 |
The Search API can also be used to search for the required bond RICs, as shown below. The filter string can be adjusted to provide more precise search results.
ld.discovery.search(
view=ld.discovery.Views.GOV_CORP_QUOTES,
filter = (
"IssuerTicker eq 'USGOVT' "
"and AssetType eq 'YIELD CURVE CONSTITUENT' "
"and IsBondQuote eq true "
"and RCSCurveTypeLeaf eq 'Government Bond Benchmark Curve Constituent' "
"and RCSGovtBondTypeLeaf eq 'US Treasury Bill' "
"and RCSOrganisationTypeLeaf eq 'Government' "
"and ContributorCode eq 'RR'"
),
select = (
"DocumentTitle,RIC,ContributorCommonName,RCSCurrencyLeaf"
"RCSTermMaturityLeaf,MaturityDate,IssueCouponRateFormatted"),
top=10)
| DocumentTitle | RIC | ContributorCommonName | RCSCurrencyLeaf | RCSTermMaturityLeaf | MaturityDate | IssueCouponRateFormatted | |
|---|---|---|---|---|---|---|---|
| 0 | United States 3 Month Benchmark, Government Bo... | US3MT=RR | REFINITIV | US Dollar | 3 Month | 2026-06-04 | 0 |
| 1 | United States 1 Year Benchmark, Government Bon... | US1YT=RR | REFINITIV | US Dollar | 1 Year | 2027-02-18 | 0 |
| 2 | United States 1 Month Benchmark, Government Bo... | US1MT=RR | REFINITIV | US Dollar | 1 Month | 2026-04-07 | 0 |
| 3 | United States 6 Month Benchmark, Government Bo... | US6MT=RR | REFINITIV | US Dollar | 6 Month | 2026-09-03 | 0 |
| 4 | United States 2 Month Benchmark, Government Bo... | US2MT=RR | REFINITIV | US Dollar | 2 Month | 2026-05-05 | 0 |
| 5 | United States 4 Month Benchmark, Government Bo... | US4MT=RR | REFINITIV | US Dollar | 4 Month | 2026-07-07 | 0 |
| 6 | United States 6 Week Benchmark, Government Bon... | US6WK=RR | REFINITIV | US Dollar | 6 Week | 2026-04-16 | 0 |
| 7 | UNITED STATES TREASURY 1M Point, Government B... | UST1MT=RR | REFINITIV | US Dollar | 1 Month | 2026-04-07 | 0 |
| 8 | UNITED STATES TREASURY 2M Point, Government B... | UST2MT=RR | REFINITIV | US Dollar | 2 Month | 2026-05-05 | 0 |
| 9 | UNITED STATES TREASURY 3M Point, Government B... | UST3MT=RR | REFINITIV | US Dollar | 3 Month | 2026-06-04 | 0 |
Benchmark constituents
Treasury market yields follow these principles:
- Where yields are traded (rather than prices), Reuters takes the contributed yield and calculates the price.
- Where the price is traded, Reuters takes the contributed price and calculates the yield.
Example of a US 30-year treasury yield RIC:
US30YT=RR
Where:
US– country code for USA.30Y– 30-year maturity.T– treasury.=RR– Reuters calculated value.
Local codes
German security codes
| Code | Instrument |
|---|---|
BA | Ten-year Government Bond (Bundesanleihe). |
BO | Five-year Government Bond (Bundesobligation). |
BP | Federal Mail Bond (Bundespost). |
DB | Bahnanleihe – currently no bond in the market. |
BF | Unity Bond – currently no bond in the market. |
BS | Treasury Note (Bundesschatzanweisung). |
TR | Treuhandanstalt. |
Gilts
Codes for UK Gilts all begin with GBT. They then have a number of components:
- Type indicator.
- Coupon code.
- Year of maturity.
Type indicators for Gilts
| Code | Instrument |
|---|---|
T | Treasury |
E | Exchequer |
F | Funding |
C | Conversion |
IR | Irredeemable |
IL | Index Linked |
WAR | War bonds |
Coupon codes
To identify the coupon rate, UK Gilt issues use a one- to three-character code. The code is in two parts:
- The first one or two characters represent the big figure (such as 9 or 10 per cent).
- The final character (when there are two or three) is a letter that represents the fractional part.
| Letter | Fraction |
|---|---|
E | 1/8 |
Q | 1/4 |
R | 3/8 |
H | 1/2 |
F | 5/8 |
T | 3/4 |
S | 7/8 |
Examples:
12Qrepresents 12 1/4%.9Hrepresents 9 1/2%.9represents 9%.
The final part of a UK Gilt RIC is two digits indicating the year of maturity.
Example:
-
A Treasury bond with a coupon of 7.75% maturing in 2015 would be
GBT7T15=.The Search API can also be used to search for the required GILT bond RICs in UK, as shown below. The filter string can be adjusted to provide more precise search results.
ld.discovery.search(
view=ld.discovery.Views.GOV_CORP_INSTRUMENTS,
filter = (
"RCSGovtBondTypeLeaf xeq 'GILT' "
"and RCSIssuerCountryLeaf eq 'United Kingdom' "
),
select = (
"DocumentTitle,RIC,MaturityDate,CouponRate,"
"RCSGovtBondTypeLeaf,InstrumentTypeDescription"),
top=10)
| DocumentTitle | RIC | MaturityDate | CouponRate | RCSGovtBondTypeLeaf | InstrumentTypeDescription | |
|---|---|---|---|---|---|---|
| 0 | United Kingdom of Great Britain and Northern I... | GBT1H26= | 2026-07-22 | 1.5 | GILT | Gilt Treasury Stock |
| 1 | United Kingdom of Great Britain and Northern I... | GBT0R26= | 2026-10-22 | 0.375 | GILT | Gilt Treasury Stock |
| 2 | United Kingdom of Great Britain and Northern I... | GBT4E27= | 2027-01-29 | 4.125 | GILT | Gilt Treasury Stock |
| 3 | United Kingdom of Great Britain and Northern I... | GBT3T27= | 2027-03-07 | 3.75 | GILT | Gilt Treasury Stock |
| 4 | United Kingdom of Great Britain and Northern I... | GBT1Q27= | 2027-07-22 | 1.25 | GILT | Gilt Treasury Stock |
| 5 | United Kingdom of Great Britain and Northern I... | GBT4Q27= | 2027-12-07 | 4.25 | GILT | Gilt Treasury Stock |
| 6 | United Kingdom of Great Britain and Northern I... | GBT0E28= | 2028-01-31 | 0.125 | GILT | Gilt Treasury Stock |
| 7 | United Kingdom of Great Britain and Northern I... | GBT4R28= | 2028-03-07 | 4.375 | GILT | Gilt Treasury Stock |
| 8 | United Kingdom of Great Britain and Northern I... | GBT4H28= | 2028-06-07 | 4.5 | GILT | Gilt Treasury Stock |
| 9 | United Kingdom of Great Britain and Northern I... | GBT1F28= | 2028-10-22 | 1.625 | GILT | Gilt Treasury Stock |
US maturity month codes
For US bonds, months can be coded differently for general, registered and bearer tie-breaker purposes:
| Month | General | Registered | Bearer tie-breaker |
|---|---|---|---|
| January | A | 1 | a |
| February | B | 2 | b |
| March | C | 3 | c |
| April | D | 4 | d |
| May | E | 5 | e |
| June | F | 6 | f |
| July | G | 7 | g |
| August | H | 8 | h |
| September | I | 9 | i |
| October | J | O (letter) | j |
| November | K | N | k |
| December | L | D | l |
Eurobonds
Medium-term notes (MTNs)
- MTNs typically vary from 30 days to 30 years.
- MTNs are issued under a programme that states the maximum total amount to be issued.
- Each tranche of securities issued under the programme has a pricing supplement giving details of the terms of issue.
For larger publicly issued EMTNs, the RICs available on Reuters have the same structure as eurobonds (see below).
New eurobond issues
For listings of new eurobond issues, use the chain:
0#NEWCORP
This chain includes other chain RICs, so you may need to expand those as well to retrieve the RICs that provide prices.
Eurobonds and the most liquid MTNs follow this structure:
<IssuerCountryCode><CommonCode>=
Example:
US329111806=
The following code performs a three‑level expansion of the
0#NEWCORP chain RIC. By iteratively expanding each nested layer of the chain, the script ultimately uncovers and extracts the individual RICs from the first instrument within the chain. These RICs can then be passed to the ld.get_data method to retrieve the corresponding data.
from lseg.data.discovery import Chain
chainRIC = '0#NEWCORP'
chain1 = Chain(chainRIC).constituents[0]
print(chain1)
chain2 = Chain(chain1).constituents[0]
print(chain2)
rics = Chain(chain2).constituents
ld.get_data(
universe=rics,
fields = ['DSPLY_NAME','COUPN_RATE','MATUR_DATE','CURRENCY','ACT_TP_1',
'PRIMACT_1','SEC_ACT_1','BOND_TYPE','RT_YIELD_1','SEC_YLD_1',
'GEN_VAL1','GEN_VAL2']
)
0#NEWCORPS 0#NEWCORPSEUR ['US329111806=', 'US330359021=', 'US330359013=', 'NL330291206=', 'CH330091606=', 'DE329884414=', 'US329111768=', 'DE329696367=', 'FR0014016GD1=', 'BE0390294636=', 'FR0014016QK5=', 'DE329884392=', 'NL328577925=', 'NL330861479=', 'US330359005=', 'JP326250180=', 'NL330290455=', 'IT329685179=', 'DE329696359=', 'US329111741=', 'FR0014016EE4=', 'FR330726083=', 'GRC5611262D6=', 'GB330430494=', 'IT328960915=', 'NL329970213=', 'DE329884368=', 'DE326189723=', 'SE329380327=', 'DEA460Q6=', 'FR322453612=', 'FR0014016PI1=', 'CH330091835=', 'DE329696197=', 'FR0014016GC3=', 'ES330969261=', 'US330358998=', 'US330970006=', 'JP326249815=', 'DEA460Q5=']
C:\Users\jphuriph\AppData\Roaming\Python\Python312\site-packages\lseg\data_tools_dataframe.py:177:FutureWarning: Downcasting object dtype arrays on .fillna, .ffill, .bfill is deprecated and will change in a future version. Call result.infer_objects(copy=False) instead. To opt-in to the future behavior, set pd.set_option('future.no_silent_downcasting', True)
| Instrument | DSPLY_NAME | COUPN_RATE | MATUR_DATE | CURRENCY | ACT_TP_1 | PRIMACT_1 | SEC_ACT_1 | BOND_TYPE | RT_YIELD_1 | SEC_YLD_1 | GEN_VAL1 | GEN_VAL2 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | US329111806= | PEPSICO | 4.15 | 2047-02-11 | EUR | B⇧ | 98.917 | 99.6 | STR | 4.2286 | 4.1786 | 88.257 | 123.157 |
| 1 | US330359021= | BAKER HUGHES H | 4.737 | 2046-03-11 | EUR | B⇧ | 99.529 | 100.549 | STR | 4.7741 | 4.6941 | 142.9074 | 177.7002 |
| 2 | US330359013= | BAKER HUGHES H | 4.193 | 2038-03-11 | EUR | B⇧ | 99.725 | 100.125 | STR | 4.2227 | 4.1795 | 133.2682 | 125.9682 |
| 3 | NL330291206= | HEINEKEN | 3.875 | 2038-02-26 | EUR | B⇩ | 98.369 | 98.832 | STR | 4.0494 | 3.9995 | 115.8409 | 108.9299 |
| 4 | CH330091606= | DSM | 3.75 | 2038-02-25 | EUR | B⇩ | 97.655 | 98.117 | STR | 4.0002 | 3.9503 | 110.8207 | 103.6205 |
| 5 | DE329884414= | T-MOBILE USA | 3.9 | 2038-02-19 | EUR | B⇩ | 97.924 | 98.383 | STR | 4.1231 | 4.0732 | 123.2143 | 116.3458 |
| 6 | US329111768= | PEPSICO | 3.7 | 2038-02-11 | EUR | B⇩ | 98.612 | 99.08 | STR | 3.8468 | 3.7969 | 95.5806 | 88.7724 |
| 7 | DE329696367= | INFINEON TECHNOL | 3.75 | 2037-02-16 | EUR | B⇩ | 98.05 | 98.482 | STR | 3.9728 | 3.9229 | 108.1799 | 103.6752 |
| 8 | FR0014016GD1= | LVMH | 3.375 | 2036-02-25 | EUR | B⇧ | 98.08 | 98.324 | STR | 3.6075 | 3.5776 | 71.452 | 70.5469 |
| 9 | BE0390294636= | FLUVIUS SYSTEM O | 3.75 | 2036-02-16 | EUR | B⇩ | 99.282 | 99.688 | STR | 3.8378 | 3.7878 | 94.6758 | 93.6209 |
| 10 | FR0014016QK5= | CARREFOUR | 3.875 | 2035-12-05 | EUR | B⇧ | 97.338 | 97.667 | STR | 4.2157 | 4.1731 | 132.6652 | 133.3723 |
| 11 | DE329884392= | T-MOBILE USA | 3.625 | 2035-02-19 | EUR | B⇩ | 98.366 | 98.735 | STR | 3.8439 | 3.7939 | 104.5851 | 103.2445 |
| 12 | NL328577925= | KPN | 3.5 | 2034-05-12 | EUR | B⇩ | 98.163 | 98.506 | STR | 3.762 | 3.712 | 96.497 | 93.1108 |
| 13 | NL330861479= | AHOLD DELHAIZE | 3.625 | 2034-03-12 | EUR | B⇩ | 99.548 | 99.888 | STR | 3.6913 | 3.6414 | 89.3281 | 84.6647 |
| 14 | US330359005= | BAKER HUGHES H | 3.812 | 2034-03-11 | EUR | B⇩ | 99.591 | 100.268 | STR | 3.8724 | 3.7726 | 107.3428 | 103.6115 |
| 15 | JP326250180= | MITSUBISHI | 3.375 | 2034-03-03 | EUR | B⇩ | 97.606 | 97.941 | STR | 3.7272 | 3.6773 | 92.9219 | 88.587 |
| 16 | NL330290455= | HEINEKEN | 3.375 | 2034-02-26 | EUR | B⇩ | 98.142 | 98.479 | STR | 3.6477 | 3.5977 | 85.0711 | 81.7779 |
| 17 | IT329685179= | ADR | 3.625 | 2034-02-17 | EUR | B⇩ | 98.398 | 98.865 | STR | 3.8626 | 3.7927 | 106.4556 | 103.473 |
| 18 | DE329696359= | INFINEON TECHNOL | 3.5 | 2034-02-16 | EUR | B⇩ | 98.633 | 99.104 | STR | 3.7014 | 3.6314 | 90.3361 | 86.9217 |
| 19 | US329111741= | PEPSICO | 3.3 | 2034-02-11 | EUR | B⇩ | 98.517 | 98.855 | STR | 3.5171 | 3.4672 | 77.6121 | 68.6747 |
| 20 | FR0014016EE4= | SAGESS | 3.125 | 2033-05-25 | EUR | B⇩ | 97.898 | 98.208 | STR | 3.4608 | 3.4109 | 15.6177 | 72.4027 |
| 21 | FR330726083= | EUTELSAT COM | 6.25 | 2033-03-15 | EUR | B⇩ | 100.351 | 101.174 | STR | 6.2618 | 6.0641 | 366.9878 | 352.4181 |
| 22 | GRC5611262D6= | CAPITAL CLEAN | 3.75 | 2033-02-25 | EUR | B⇧ | 96.11 | 96.68 | STR | 4.4512 | 4.3512 | 175.4044 | 173.766 |
| 23 | GB330430494= | SAGE GROUP | 3.821 | 2033-02-25 | EUR | B⇧ | 98.021 | 98.432 | STR | 4.1537 | 4.0838 | 145.5695 | 144.0509 |
| 24 | IT328960915= | ACQUIRENTE UNICO | 3.5 | 2033-02-11 | EUR | B⇧ | 99.238 | 99.659 | STR | 3.6257 | 3.5557 | 92.7699 | 90.9943 |
| 25 | NL329970213= | ENEXIS HLDG | 3.0 | 2032-02-25 | EUR | B⇩ | 98.169 | 98.432 | STR | 3.3435 | 3.2936 | 75.9506 | 57.4104 |
| 26 | DE329884368= | T-MOBILE USA | 3.2 | 2032-02-19 | EUR | B⇩ | 98.356 | 98.722 | STR | 3.5107 | 3.4408 | 92.6656 | 74.1894 |
| 27 | DE326189723= | CHEPLAPHARM | 6.75 | 2032-02-15 | B⇧ | 100.53 | 101.028 | STR | 6.7004 | 6.5507 | 418.3694 | 399.3702 | |
| 28 | SE329380327= | FASTIGHETS | 3.625 | 2031-08-25 | EUR | B⇩ | 98.405 | 98.739 | STR | 3.9585 | 3.8886 | 137.348 | 121.0966 |
| 29 | DEA460Q6= | PCC | 5.5 | 2031-04-01 | EUR | B⇧ | 99.164 | 99.582 | STR | 5.8143 | 5.7143 | 322.0298 | 307.2749 |
| 30 | FR322453612= | EUTELSAT COM | 5.75 | 2031-03-15 | EUR | B⇩ | 100.305 | 100.937 | STR | 5.7431 | 5.5608 | 324.0191 | 304.0784 |
| 31 | FR0014016PI1= | VINCI | 0.75 | 2031-03-04 | EUR | B | 95.9 | 96.4 | CNV | 1.5623 | <NA> | <NA> | 30.0 |
| 32 | CH330091835= | DSM | 3.0 | 2031-02-25 | EUR | B⇩ | 98.433 | 98.656 | STR | 3.3476 | 3.2977 | 75.562 | 61.6656 |
| 33 | DE329696197= | INFINEON TECHNOL | 3.0 | 2031-02-16 | EUR | B⇩ | 98.568 | 98.879 | STR | 3.3186 | 3.2488 | 72.46 | 58.8427 |
| 34 | FR0014016GC3= | LVMH | 2.625 | 2030-06-25 | EUR | B⇩ | 98.274 | 98.43 | STR | 3.0622 | 3.0224 | 55.82 | 34.9359 |
| 35 | ES330969261= | SACYR ES | 4.75 | 2030-05-29 | EUR | B⇩ | 103.104 | 103.519 | STR | 3.9917 | 3.8919 | 174.7518 | 127.9111 |
| 36 | US330358998= | BAKER HUGHES H | 3.226 | 2030-03-11 | EUR | B⇩ | 99.138 | 99.388 | STR | 3.4605 | 3.3922 | 95.746 | 75.546 |
| 37 | US330970006= | FIDELITY NTL INF | 3.45 | 2030-03-10 | EUR | B⇩ | 99.516 | 99.772 | STR | 3.5821 | 3.5121 | 107.9066 | 87.22 |
| 38 | JP326249815= | MITSUBISHI | 2.75 | 2030-03-03 | EUR | B⇩ | 98.269 | 98.451 | STR | 3.2203 | 3.1703 | 71.7308 | 51.6099 |
| 39 | DEA460Q5= | PCC | 4.0 | 2028-02-01 | EUR | <NA> | <NA> | <NA> | STR | <NA> | <NA> | <NA> | <NA> |
Eurobond chains
Eurobond chains are grouped by currency of issue and type (straight, floater or convertible).
Key pages:
EUROBOND1toEUROBOND7– by currency of issue.
Example:
0#EUROCADSAB=– Canadian dollar-denominated straight eurobonds where the issuer name starts with A or B.
You can use the Chain class and the ld.get_data method to expand chains and retrieve data.
from lseg.data.discovery import Chain
chainRIC = '0#EUROCADSAB='
rics = Chain(chainRIC).constituents
ld.get_data(
universe=rics,
fields = ['DSPLY_NAME','COUPN_RATE','MATUR_DATE','CURRENCY','ACT_TP_1',
'PRIMACT_1','SEC_ACT_1','BOND_TYPE','RT_YIELD_1','SEC_YLD_1',
'GEN_VAL1','GEN_VAL2']
)
| Instrument | DSPLY_NAME | COUPN_RATE | MATUR_DATE | CURRENCY | ACT_TP_1 | PRIMACT_1 | SEC_ACT_1 | BOND_TYPE | RT_YIELD_1 | SEC_YLD_1 | GEN_VAL1 | GEN_VAL2 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | XS024421996= | ASIAN DEV | 4.65 | 2027-02-16 | CAD | B⇩ | 101.98 | 102.036 | STR | 2.5047 | 2.4449 | 10.2162 | 15.3984 |
| 1 | XS182809209= | ADB | 2.9 | 2028-05-31 | CAD | B⇩ | 100.251 | 100.465 | STR | 2.7814 | 2.6817 | 6.9432 | 24.0004 |
| 2 | CA106508739= | ALBERTA PROVINCE | 3.47 | 2029-05-08 | CAD | B⇩ | 101.501 | 101.652 | STR | 2.968 | 2.9181 | 13.6968 | 33.1946 |
Floating rate notes and convertible chains
Floating rate note (FRN) and convertible chains use the same structure.
F– FRNs, such as0#EUROJPYF=C– convertibles, such as0#EUROAUDC=
You can use the Chain class and the ld.get_data method to expand chains and retrieve data.
from lseg.data.discovery import Chain
chainRIC = '0#EUROAUDC='
rics = Chain(chainRIC).constituents
ld.get_data(
universe=rics,
fields = ['DSPLY_NAME','COUPN_RATE','MATUR_DATE','CURRENCY','ACT_TP_1',
'PRIMACT_1','SEC_ACT_1','BOND_TYPE','RT_YIELD_1','YLD_NETCHG',
'GEN_VAL2']
)
C:\Users\jphuriph\AppData\Roaming\Python\Python312\site-packages\lseg\data_tools_dataframe.py:177:FutureWarning: Downcasting object dtype arrays on .fillna, .ffill, .bfill is deprecated and will change in a future version. Call result.infer_objects(copy=False) instead. To opt-in to the future behavior, set pd.set_option('future.no_silent_downcasting', True)
| Instrument | DSPLY_NAME | COUPN_RATE | MATUR_DATE | CURRENCY | ACT_TP_1 | PRIMACT_1 | SEC_ACT_1 | BOND_TYPE | RT_YIELD_1 | YLD_NETCHG | GEN_VAL2 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | AU232800348= | WEBJET | 0.75 | 2026-04-12 | AUD | B⇩ | 99.039 | 99.5057 | CNV | 9.2726 | -2.0418 | 150 |
| 1 | AU235954559= | NEW HOPE | 2.75 | 2026-07-02 | AUD | <NA> | <NA> | CNV | -120.8963 | <NA> | 400 | |
| 2 | AU225034770= | FLIGHT CENTRE | 2.5 | 2027-11-17 | AUD | B | 97.25 | 97.75 | CNV | 4.0479 | 0.2377 | 110 |
| 3 | AU248763752= | DEXUS FIN | 3.5 | 2027-11-24 | AUD | B⇩ | 103.5 | 104.0 | CNV | 3.5937 | 0.6534 | 40 |
| 4 | AU240044374= | FLIGHT CENTRE | 1.625 | 2028-11-01 | AUD | B | 99.0 | 99.5 | CNV | 1.9173 | 0.0003 | 150 |
| 5 | AU285611881= | NEW HOPE | 4.25 | 2029-07-12 | AUD | B⇩ | 107.25 | 107.75 | CNV | 1.9201 | -0.1508 | 350 |
| 6 | AU286296149= | TELIX PHARMS | 2.375 | 2029-07-30 | AUD | B⇧ | 95.75 | 96.25 | CNV | 3.6356 | 0.1215 | 350 |
| 7 | AU289996460= | NATIONAL STORAG | 3.625 | 2029-09-19 | AUD | B⇩ | 114.75 | 115.25 | CNV | -0.5867 | 0.1265 | 120 |
| 8 | AU317081766= | CIP FUNDING | 3.5 | 2030-09-03 | AUD | B⇩ | 99.25 | 99.75 | CNV | 3.6196 | 0.1516 | 100 |
| 9 | AU317159161= | FLIGHT CENTRE | 2.5 | 2032-09-03 | AUD | B⇩ | 98.25 | 98.75 | CNV | 2.7543 | 0.2123 | 150 |
The Search API can also be used to search for the Fixed Rate Euro Bonds, as shown below. The filter string can be adjusted to provide more precise search results.
For example, you can use the AssetCategoryName property to search for Fixed Rate, Floating Rate or Convertible bonds.
| Bond Type | AssetCategoryName |
|---|---|
| Fixed Rate Bond | Fixed Income/Fixed Rate Bond |
| FRN | Fixed Income/Floater |
| Cconvertible | Fixed Income/Convertible |
ld.discovery.search(
view=ld.discovery.Views.GOV_CORP_QUOTES,
filter = (
"RCSCountryLeaf eq 'Eurobond' "
"and PriceSource eq 'REFINITIV COMPOSITE EMEA' "
"and RCSCurrencyLeaf eq 'Euro' "
"and RCSCouponTypeLeaf eq 'Plain Vanilla Fixed Coupon' "
"and AssetState eq 'AC' "
"and IsBondQuote eq true "
"and AssetStatus eq 'ISS' "
"and Currency eq 'EUR' "
"and RCSOrganisationTypeName eq 'Corporation' "
"and AssetCategoryName eq 'Fixed Income/Fixed Rate Bond' "
),
select = (
"DocumentTitle,RIC,MaturityDate,RCSIssuerCountryLeaf,"
"IssueCouponRate,AssetCategoryName,RCSCountryName"),
top=10)
| DocumentTitle | RIC | MaturityDate | RCSIssuerCountryLeaf | IssueCouponRate | AssetCategoryName | RCSCountryName | |
|---|---|---|---|---|---|---|---|
| 0 | Banco Santander SA, Bond Quote, SAN 2.75 04-Ju... | ES184673924= | 2038-07-04 | Spain | 2.75 | [Fixed Income/Fixed Rate Bond] | Market of Issue\Eurobond |
| 1 | Alliander NV, Bond Quote, ALNDR 3 07-Oct-2034,... | NL291331009= | 2034-10-07 | Netherlands | 3.0 | [Fixed Income/Fixed Rate Bond] | Market of Issue\Eurobond |
| 2 | Digital Intrepid Holding BV, Bond Quote, DLRDG... | US242871600= | 2032-07-18 | Netherlands | 1.375 | [Fixed Income/Fixed Rate Bond] | Market of Issue\Eurobond |
| 3 | Credit Agricole CIB Financial Solutions SA, Bo... | FR298019353= | 2028-04-03 | France | 7.0 | [Fixed Income/Fixed Rate Bond] | Market of Issue\Eurobond |
| 4 | Nomura Bank International PLC, Bond Quote, NMH... | JP292863721= | 2030-01-10 | United Kingdom | 7.87 | [Fixed Income/Fixed Rate Bond] | Market of Issue\Eurobond |
| 5 | HSBC Bank PLC, Bond Quote, HSBCU 10 24-Aug-202... | GB327073753= | 2026-08-24 | United Kingdom | 10.0 | [Fixed Income/Fixed Rate Bond] | Market of Issue\Eurobond |
| 6 | Bayer AG, Bond Quote, BAYG 4 26-Aug-2026, REFI... | DE263011198= | 2026-08-26 | Germany | 4.0 | [Fixed Income/Fixed Rate Bond] | Market of Issue\Eurobond |
| 7 | SoftBank Group Corp, Bond Quote, SFTBK 5.75 08... | JP285442346= | 2032-07-08 | Japan | 5.75 | [Fixed Income/Fixed Rate Bond] | Market of Issue\Eurobond |
| 8 | HSBC Bank PLC, Bond Quote, HSBCU 10 04-Jun-202... | GB299499260= | 2026-06-04 | United Kingdom | 10.0 | [Fixed Income/Fixed Rate Bond] | Market of Issue\Eurobond |
| 9 | Citigroup Global Markets Funding Luxembourg SC... | US315896746= | 2036-03-03 | Luxembourg | 7.62 | [Fixed Income/Fixed Rate Bond] | Market of Issue\Eurobond |
Cheapest to deliver
The following codes give useful overviews of cheapest-to-deliver bonds:
0#CTD0#CHEAPEST0#CHEAPEST20#DLV: all deliverable bonds by future
Conversion factors
G24/FACTOR1– G24 conversion factors.0#CF– Conversion factor chain.
You can use the Chain class and the ld.get_data method to expand chains and retrieve data.
from lseg.data.discovery import Chain
chainRIC = '0#CTD'
chain1 = Chain(chainRIC).constituents[0]
rics = Chain(chain1).constituents
ld.get_data(
universe=rics,
fields = ['DSPLY_NAME','COUPN_RATE','MATUR_DATE','CURRENCY','ACT_TP_1',
'PRIMACT_1','SEC_ACT_1','RT_YIELD_1','YLD_NETCHG',
'GEN_VAL2']
)
| Instrument | DSPLY_NAME | COUPN_RATE | MATUR_DATE | CURRENCY | ACT_TP_1 | PRIMACT_1 | SEC_ACT_1 | RT_YIELD_1 | YLD_NETCHG | GEN_VAL2 | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | AULc1=CTD | UST 4 3/4 N/53 | 4.75 | 2053-11-15 | USD | B | 100.109 | 100.188 | 4.742 | 0.011 | 0.055 |
| 1 | AULc2=CTD | UST 4 3/4 N/53 | 4.75 | 2053-11-15 | USD | B | 100.109 | 100.188 | 4.742 | 0.011 | 0.36 |
| 2 | AULc3=CTD | UST 4 3/4 N/53 | 4.75 | 2053-11-15 | USD | B | 100.109 | 100.188 | 4.742 | 0.011 | 0.589 |
Credit ratings
If your interests in credit ratings are more general, start at the RATINGS Speed-Guide page which links to:
- US and international bond rating reviews.
- Rating actions and assignments.
- Ratings news and analysis.
- Domestic services.
The Ratings Service provides comprehensive coverage from five top rating agencies of all European, global sovereign and supranational issuers. It includes:
- Senior unsecured (short- and long-term) ratings.
- Subordinated (long-term) issuer credit ratings.
- Extensive cross-referencing to related information such as Reuters news, fixed income information and equity prices.
Note: This service covers international credit ratings only.
The Speed-Guide page data can also be retreived through LSEG Data Library for Python by using page RICs and the ROW80_1 to ROW80_25 fields.
RIC = "RATINGS"
fields = [f"ROW80_{i}" for i in range(1, 26)]
df = ld.get_data(
universe=RIC,
fields=fields
)
for i in range(0, len(df)):
print(*df.iloc[i, 1:26], sep="\n")
RATINGS - LSEG SPEED GUIDE RATINGS
C R E D I T R A T I N G S G U I D E
Welcome to the RATINGS GUIDE. To access information double-click in < > or [ ].
========================== REGIONAL RATING SERVICES ==========================
-AMERICAS----------------------------- -ASIA---------------------------------
Dominion Bond Rating Svc......<DBRS01> Japanese Ratings Service...<JP/RATING>
US Corp Ratings...........<RATINGS/US> Korea Investors Service(KIS)<KIS01>-64
Malaysian Rating Corp......<MRATING01>
PhilRatings Services Corp.....<CIBI00>
Ram Berhad....................<RAMBHD>
Eikon users can view individual Debt rating on Bond View. Issuer level ratings
are also available on Issuer Ratings page under the "Debt" tab on Bond View.
============================== NEWS & ANALYSIS ===============================
All LSEG Debt News................................................<DEBT/NEWS1>
Ratings News.............................................................[AAA]
==============================================================================
Broker Guide<BROKER> Main Guide<LSEG> Debt Guide<BONDS>
Lost?Selective Access?.....<USER/HELP> LSEG Phone Support.....<PHONE/HELP>
Bond Views (LSEG Workspace)
Bond Views are web-based displays that provide a consolidated view of bond information.
In LSEG Workspace, users can open the Bond View by entering a RIC in the global search bar and pressing Enter. The view displays the bond's data across multiple categorized tabs.

LSEG Data Library for Python provides several methods and classes that can be used to retrieve bond information, prices, historical data, news and analytic prices.
Bond Information
The bond information can typically be retrieved using ld.get_data with the appropriate fundamental fields prefixed with TR. Users can locate these fields and parameters through the Data Item Browser tool, or—where available—by clicking the small (?) icon displayed next to a field name to identify the source field that provides the data.

For example, the following code uses LSEG Data Library for Python to retrieve bond information for
US242871600=.
ld.get_data(
universe=['US242871600=','ES184673924='],
fields=['TR.FIIssuerName','TR.FIMaturityDate','TR.FiCurrency',
'TR.FiIssuerFitchLongRating','TR.FiFaceIssuedTotal',
'TR.FiNumberAccruedDays','TR.FiPrice','TR.FICouponTypeDescription',
'TR.FiAssetSubTypeDescription','TR.FiAssetTypeDescription']
)
| Instrument | Issuer Name | Maturity Date | Currency | Issuer Fitch Long Rating | Face Issued Total | Number Accrued Days | Price | Coupon Type Description | Asset Sub Type Description | Asset Type Description | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | US242871600= | DIGITAL INTREPID HOLDING BV | 2032-07-18 | EUR | BBB | 750000000 | 236 | 85.892 | Fixed:Plain Vanilla Fixed Coupon | Eurobond | Corporate |
| 1 | ES184673924= | BANCO SANTANDER SA | 2038-07-04 | EUR | A | 25000000 | 250 | 80.161 | Fixed:Plain Vanilla Fixed Coupon | Eurobond | Corporate |
When a field provides historical data, the ld.get_history method can be used to obtain its historical time series. You can check which fields support historical data by using the Data Item Browser tool.
ld.get_history(
universe=['US242871600=','ES184673924='],
fields=['TR.BIDPRICE','TR.ASKPRICE','TR.MIDPRICE',
'TR.CLEANPRICE','TR.DIRTYPRICE'],
start='2026-01-01',
end='2026-01-31'
)
| US242871600= | ES184673924= | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Bid Price | Ask Price | Mid Price | Clean Price | Dirty Price | Bid Price | Ask Price | Mid Price | Clean Price | Dirty Price | |
| Date | ||||||||||
| 2026-01-01 | 85.954 | 86.318 | 86.136 | 85.954 | 86.5982 | 79.767 | 80.166 | 79.9665 | 79.767 | 81.1608 |
| 2026-01-02 | 85.577 | 85.939 | 85.758 | 85.577 | 86.2249 | 79.499 | 79.897 | 79.698 | 79.499 | 80.9004 |
| 2026-01-05 | 85.9 | 86.263 | 86.0815 | 85.9 | 86.5517 | 79.787 | 80.186 | 79.9865 | 79.787 | 81.1959 |
| 2026-01-06 | 86.072 | 86.436 | 86.254 | 86.072 | 86.7275 | 80.044 | 80.445 | 80.2445 | 80.044 | 81.4604 |
| 2026-01-07 | 86.212 | 86.576 | 86.394 | 86.212 | 86.8712 | 80.092 | 80.493 | 80.2925 | 80.092 | 81.516 |
| 2026-01-08 | 86.164 | 86.528 | 86.346 | 86.164 | 86.8345 | 80.191 | 80.592 | 80.3915 | 80.191 | 81.6376 |
| 2026-01-09 | 86.223 | 86.587 | 86.405 | 86.223 | 86.8973 | 80.255 | 80.657 | 80.456 | 80.255 | 81.7091 |
| 2026-01-12 | 86.224 | 86.588 | 86.406 | 86.224 | 86.9021 | 80.461 | 80.864 | 80.6625 | 80.461 | 81.9226 |
| 2026-01-13 | 86.246 | 86.61 | 86.428 | 86.246 | 86.9278 | 80.382 | 80.784 | 80.583 | 80.382 | 81.8512 |
| 2026-01-14 | 86.418 | 86.782 | 86.6 | 86.418 | 87.1036 | 80.47 | 80.873 | 80.6715 | 80.47 | 81.9467 |
| 2026-01-15 | 86.31 | 86.673 | 86.4915 | 86.31 | 87.0069 | 80.508 | 80.911 | 80.7095 | 80.508 | 82.0073 |
| 2026-01-16 | 86.226 | 86.589 | 86.4075 | 86.226 | 86.9267 | 80.456 | 80.858 | 80.657 | 80.456 | 81.9628 |
| 2026-01-19 | 86.319 | 86.682 | 86.5005 | 86.319 | 87.0235 | 80.431 | 80.833 | 80.632 | 80.431 | 81.9454 |
| 2026-01-20 | 86.303 | 86.666 | 86.4845 | 86.303 | 87.0112 | 80.541 | 80.944 | 80.7425 | 80.541 | 82.0629 |
| 2026-01-21 | 86.215 | 86.577 | 86.396 | 86.215 | 86.927 | 80.033 | 80.433 | 80.233 | 80.033 | 81.5625 |
| 2026-01-22 | 86.179 | 86.541 | 86.36 | 86.179 | 86.9023 | 80.059 | 80.459 | 80.259 | 80.059 | 81.6111 |
| 2026-01-23 | 86.156 | 86.517 | 86.3365 | 86.156 | 86.8831 | 80.03 | 80.429 | 80.2295 | 80.03 | 81.5896 |
| 2026-01-26 | 86.253 | 86.615 | 86.434 | 86.253 | 86.9838 | 80.28 | 80.681 | 80.4805 | 80.28 | 81.8471 |
| 2026-01-27 | 86.346 | 86.708 | 86.527 | 86.346 | 87.0806 | 80.185 | 80.585 | 80.385 | 80.185 | 81.7597 |
| 2026-01-28 | 86.573 | 86.936 | 86.7545 | 86.573 | 87.3114 | 80.371 | 80.772 | 80.5715 | 80.371 | 81.9532 |
| 2026-01-29 | 86.629 | 86.992 | 86.8105 | 86.629 | 87.3787 | 80.514 | 80.916 | 80.715 | 80.514 | 82.1188 |
| 2026-01-30 | 86.632 | 86.995 | 86.8135 | 86.632 | 87.3854 | 80.384 | 80.785 | 80.5845 | 80.384 | 81.9963 |
Real-Time Prices
Real‑time prices represent the streaming data displayed in the Quote app. These real‑time streaming fields differ from fundamental and reference fields in that they do not include the TR prefix, as seen in PRIMACT_1, SEC_ACT_1, DSPLY_NAME, and RT_YIELD_1.
Using the LSEG Data Library for Python, users can use the the ld.get_data or ld.open_pricing_stream method to retrieve current prices or streaming prices respectively. For example, the following code subscribes to real-time streaming data for
US242871600= and ES184673924=.
import time
import datetime
from IPython.display import display, clear_output
def display_data(data, instrument, stream):
clear_output(wait=True)
current_time = datetime.datetime.now().time()
print(current_time, "- Data received for", instrument)
display(stream.get_snapshot())
stream = ld.open_pricing_stream(
universe=['US242871600=','ES184673924='],
fields=['DSPLY_NAME','MATUR_DATE','PRIMACT_1','SEC_ACT_1','PCTCHNG','RT_YIELD_1','SEC_YLD_1','CTBTR_1','BMK_SPD','COUPN_RATE'],
on_data=display_data
)
#Run for 10 seconds to receive some data, then close the stream
time.sleep(10)
stream.close()
18:12:23.026639 - Data received for ES184673924=
| Instrument | DSPLY_NAME | MATUR_DATE | PRIMACT_1 | SEC_ACT_1 | PCTCHNG | RT_YIELD_1 | SEC_YLD_1 | CTBTR_1 | BMK_SPD | COUPN_RATE | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | US242871600= | DIGITAL INT HOLD | 2032-07-18 | 86.189 | 86.544 | 0.0244 | 3.8683 | 3.7984 | LPS | 124.6293 | 1.375 |
| 1 | ES184673924= | BANCO SANTANDE | 2038-07-04 | 80.334 | 80.732 | -0.0386 | 4.9153 | 4.8653 | LPS | 207.0269 | 2.75 |
<OpenState.Closed: 'Closed'>
The ld.get_history method can also be used to retrieve historical data for real‑time fields. To do so, you may omit the fields parameter, and the API will return all available historical real‑time fields for the requested instruments.
ld.get_history(
universe=['US242871600='],
start='2026-01-01',
end='2026-01-31'
)
C:\Users\jphuriph\AppData\Roaming\Python\Python312\site-packages\lseg\data_tools_dataframe.py:177:FutureWarning: Downcasting object dtype arrays on .fillna, .ffill, .bfill is deprecated and will change in a future version. Call result.infer_objects(copy=False) instead. To opt-in to the future behavior, set pd.set_option('future.no_silent_downcasting', True)
| US242871600= | YLDTOMAT | BID_HIGH_1 | OPEN_BID | BID_LOW_1 | HIGH_YLD | LOW_YLD | MID_PRICE | A_YLD_1 | ACCR_INT | ISMA_A_YLD | ... | OIS_SPREAD | TED_SPREAD | INT_GV_SPD | REDEM_DATE | ASP6M | ASP3M | ASP1M | DIRTY_PRC | CLEAN_PRC | MAC_DURTN |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Date | |||||||||||||||||||||
| 2026-01-02 | 3.9206 | 86.008 | 85.889 | 85.577 | 3.9206 | 3.8373 | 85.758 | 3.8506 | 0.6479 | 3.8506 | ... | 140.3602 | <NA> | 128.9976 | 20320718 | 105.0236 | 112.1462 | 120.8701 | 86.2249 | 85.577 | 6.2209 |
| 2026-01-05 | 3.8591 | 85.941 | 85.618 | 85.6 | 3.9171 | 3.8512 | 86.0815 | 3.7893 | 0.6517 | 3.7893 | ... | 136.5013 | <NA> | 125.2387 | 20320718 | 102.3965 | 109.4844 | 118.1447 | 86.5517 | 85.9 | 6.2189 |
| 2026-01-06 | 3.827 | 86.104 | 85.813 | 85.808 | 3.8779 | 3.8208 | 86.254 | 3.757 | 0.6555 | 3.757 | ... | 136.5437 | <NA> | 125.6381 | 20320718 | 102.1588 | 109.1317 | 117.8025 | 86.7275 | 86.072 | 6.2166 |
| 2026-01-07 | 3.801 | 86.298 | 86.067 | 86.067 | 3.8289 | 3.7845 | 86.394 | 3.7312 | 0.6592 | 3.7312 | ... | 136.8902 | <NA> | 125.5198 | 20320718 | 103.5556 | 110.6263 | 119.4007 | 86.8712 | 86.212 | 6.2142 |
| 2026-01-08 | 3.8132 | 86.253 | 86.235 | 86.061 | 3.8331 | 3.7961 | 86.346 | 3.7433 | 0.6705 | 3.7433 | ... | 136.5137 | <NA> | 125.2395 | 20320718 | 102.9622 | 109.9726 | 118.7068 | 86.8345 | 86.164 | 6.2058 |
| 2026-01-09 | 3.8028 | 86.223 | 86.176 | 86.083 | 3.8298 | 3.8028 | 86.405 | 3.7329 | 0.6743 | 3.7329 | ... | 134.9795 | <NA> | 123.8712 | 20320718 | 100.9215 | 108.1128 | 116.6577 | 86.8973 | 86.223 | 6.2032 |
| 2026-01-12 | 3.8036 | 86.271 | 86.238 | 86.092 | 3.8291 | 3.7946 | 86.406 | 3.7337 | 0.6781 | 3.7337 | ... | 137.7016 | <NA> | 125.5353 | 20320718 | 104.1126 | 111.1592 | 119.6133 | 86.9021 | 86.224 | 6.2004 |
| 2026-01-13 | 3.8004 | 86.278 | 86.278 | 86.042 | 3.8397 | 3.7942 | 86.428 | 3.7304 | 0.6818 | 3.7304 | ... | 137.1643 | <NA> | 125.5024 | 20320718 | 103.3188 | 110.2818 | 118.5465 | 86.9278 | 86.246 | 6.1977 |
| 2026-01-14 | 3.7682 | 86.457 | 86.23 | 86.194 | 3.8114 | 3.7607 | 86.6 | 3.6984 | 0.6856 | 3.6984 | ... | 135.2434 | <NA> | 123.076 | 20320718 | 102.3197 | 109.2208 | 117.5924 | 87.1036 | 86.418 | 6.1954 |
| 2026-01-15 | 3.792 | 86.442 | 86.442 | 86.294 | 3.7951 | 3.7665 | 86.4915 | 3.7222 | 0.6969 | 3.7222 | ... | 137.0933 | <NA> | 124.3445 | 20320718 | 103.4228 | 110.418 | 118.7839 | 87.0069 | 86.31 | 6.1869 |
| 2026-01-16 | 3.8092 | 86.442 | 86.442 | 86.19 | 3.8161 | 3.7665 | 86.4075 | 3.7392 | 0.7007 | 3.7392 | ... | 136.9281 | <NA> | 124.3381 | 20320718 | 102.8557 | 109.9662 | 118.3263 | 86.9267 | 86.226 | 6.1839 |
| 2026-01-19 | 3.7922 | 86.462 | 86.251 | 86.251 | 3.8053 | 3.7646 | 86.5005 | 3.7223 | 0.7045 | 3.7223 | ... | 136.091 | <NA> | 124.2203 | 20320718 | 101.5102 | 108.7054 | 117.071 | 87.0235 | 86.319 | 6.1814 |
| 2026-01-20 | 3.7963 | 86.343 | 86.343 | 86.094 | 3.8367 | 3.7886 | 86.4845 | 3.7264 | 0.7082 | 3.7264 | ... | 136.5138 | <NA> | 124.3588 | 20320718 | 101.5212 | 108.7658 | 116.8984 | 87.0112 | 86.303 | 6.1786 |
| 2026-01-21 | 3.8143 | 86.453 | 86.266 | 86.163 | 3.8243 | 3.7683 | 86.396 | 3.7444 | 0.712 | 3.7444 | ... | 134.2668 | <NA> | 122.3322 | 20320718 | 100.7924 | 108.0663 | 116.1888 | 86.927 | 86.215 | 6.1756 |
| 2026-01-22 | 3.8242 | 86.36 | 86.264 | 86.14 | 3.8318 | 3.7892 | 86.36 | 3.7543 | 0.7233 | 3.7543 | ... | 136.0118 | <NA> | 123.2762 | 20320718 | 101.0842 | 108.3931 | 116.4816 | 86.9023 | 86.179 | 6.1673 |
| 2026-01-23 | 3.8297 | 86.196 | 86.145 | 86.034 | 3.8534 | 3.822 | 86.3365 | 3.7599 | 0.7271 | 3.7599 | ... | 135.0778 | <NA> | 122.2222 | 20320718 | 99.5294 | 106.9495 | 115.1193 | 86.8831 | 86.156 | 6.1645 |
| 2026-01-26 | 3.8119 | 86.305 | 86.145 | 86.129 | 3.8359 | 3.8018 | 86.434 | 3.742 | 0.7308 | 3.742 | ... | 135.6829 | <NA> | 123.4163 | 20320718 | 101.1046 | 108.4048 | 116.5815 | 86.9838 | 86.253 | 6.162 |
| 2026-01-27 | 3.7949 | 86.394 | 86.231 | 86.203 | 3.8226 | 3.7856 | 86.527 | 3.725 | 0.7346 | 3.725 | ... | 134.3169 | <NA> | 121.7414 | 20320718 | 99.2948 | 106.6432 | 114.9692 | 87.0806 | 86.346 | 6.1594 |
| 2026-01-28 | 3.752 | 86.573 | 86.314 | 86.314 | 3.8021 | 3.752 | 86.7545 | 3.6821 | 0.7384 | 3.6821 | ... | 132.5428 | <NA> | 119.8262 | 20320718 | 97.7637 | 105.0748 | 113.3318 | 87.3114 | 86.573 | 6.1572 |
| 2026-01-29 | 3.7441 | 86.664 | 86.55 | 86.499 | 3.7692 | 3.7374 | 86.8105 | 3.6742 | 0.7497 | 3.6742 | ... | 133.0512 | <NA> | 120.6679 | 20320718 | 99.1917 | 106.5994 | 114.7679 | 87.3787 | 86.629 | 6.1491 |
| 2026-01-30 | 3.7445 | 86.689 | 86.589 | 86.519 | 3.7664 | 3.7335 | 86.8135 | 3.6746 | 0.7534 | 3.6746 | ... | 133.094 | <NA> | 120.112 | 20320718 | 99.0957 | 106.3113 | 114.6166 | 87.3854 | 86.632 | 6.1464 |
21 rows × 40 columns
News
Using the LSEG Data Library for Python, users can call the ld.news.get_headlines method with the 'R:<RIC>' news query to retrieve news headlines related to a specific RIC.
The following code retrieve English news headlines that relate to US242871600= and display the first headline and story.
news_df = ld.news.get_headlines("R:US242871600= and LEN")
display(news_df)
| headline | storyId | sourceCode | |
|---|---|---|---|
| versionCreated | |||
| 2026-03-10 11:08:18.337 | Update: Can Digital Realty Trust (DLR: $179.68... | urn:newsml:newsroom:20260310:nNRAzrwzs7:0 | NS:NEWNYS |
| 2026-03-10 10:48:03.928 | Past Week: Digital Core REIT (DCRU: 48.50c) do... | urn:newsml:newsroom:20260310:nNRAzrwrmy:0 | NS:NEWBIF |
| 2026-03-10 10:27:11.292 | Schroder Investment Management Group Cuts Stak... | urn:newsml:newsroom:20260310:nNRAzrwid1:0 | NS:TRADAJ |
| 2026-03-10 09:30:18.348 | Natixis Advisors LLC Grows Position in Digital... | urn🔗webnews:20260310:nNRAzrvsnm:0 | NS:MARBEA |
| 2026-03-10 09:27:13.547 | Natixis Advisors LLC Purchases 8,400 Shares of... | urn:newsml:newsroom:20260310:nNRAzrvpqf:0 | NS:TRADAJ |
| 2026-03-10 07:34:17.107 | Andrew P. Power's Digital Realty Trust top gai... | urn:newsml:newsroom:20260310:nNRAzru87g:0 | NS:NEWPEO |
| 2026-03-10 02:17:16.454 | Past Week: Digital Realty Trust (DLR: $179.68)... | urn:newsml:newsroom:20260310:nNRAzrrjgi:0 | NS:GLOWEE |
| 2026-03-10 00:02:34.081 | Singapore's next data-centre growth wave lies ... | urn:newsml:reuters.com:20260310:nNRAzrqdqq:1 | NS:BSNTMS |
| 2026-03-09 23:47:34.657 | Digital Realty Trust (FQI: EUR154.02) shares f... | urn:newsml:newsroom:20260309:nNRAzrq92z:0 | NS:CNBSTR |
| 2026-03-09 23:08:09.793 | Singapore's next data-centre growth wave lies ... | urn🔗webnews:20260309:nNRAzrpsdx:0 | NS:BUSTIM |
The retrieved response includes news headlines and their corresponding story IDs, which can be used to fetch the full news stories. The following code uses the first news story ID to fetch the first complete news story.
from IPython.display import HTML
story = ld.news.get_story(news_df.iloc[0]['storyId'])
#Display only the first 1000 characters of the story for brevity
HTML(story[:1000])
NYSE STOCK REPORT
Ahead of this morning's market opening, Digital Realty Trust closed higher the previous trading day. Digital Realty Trust (NYSE:DLR), the NYSE's 3rd largest Diversified Real Estate Investment Trust (REIT) by market cap, lifted 2.0% during its previous trading session to close at $179.68.
Source: New York Stock Exchange: https://www.nasdaq.com/market-activity/stocks/DLR, company (Digital Realty Trust)
UPCOMING EVENT: DIVIDEND
The company today announced a quarterly dividend of $1.22 per share for Q4/2025; unchanged from the previous quarter (Q3/2025) dividend of $1.22. The ex-dividend date is Friday, March 13, 2026 and the record date is Friday, March 13, 2026 and it is payable on Tuesday, March 31. Total dividends per share paid in the 12 months ended February 24
Bond Analytics
LSEG Data Library for Python supports IPA (Instrument Pricing Analytics) for Bond Contracts which provides pricing and risk analytics calculated from the instrument’s contractual terms plus current market data. It helps you retrieve measures such as clean/dirty price, accrued interest, yield, duration, convexity, and cash-flow-related outputs in a consistent API workflow. In practice, this lets you evaluate bond valuation and sensitivity across instruments without manually implementing pricing formulas, while keeping calculations aligned with LSEG analytics conventions.
The following code retrieves analytics for a specific bond from LSEG's IPA Financial Contracts service and returns the results in tabular form. It focuses on key valuation metrics, including instrument description, market data date, price, yield, spread versus government benchmarks, and spread versus sector/rating benchmarks. The output is a ready-to-analyze dataset that can be used for quick valuation and relative-value checks. The list of available parameters as well as available fields can be found on the LSEG Developers Community here.
from lseg.data.content.ipa.financial_contracts import bond
response = bond.Definition(
instrument_code="US242871600=",
fields=[
"InstrumentDescription",
"MarketDataDate",
"Price",
"YieldPercent",
"GovernmentSpreadBp",
"SectorRatingSpreadBp",
"RatingSpreadBp"
]
).get_data()
response.data.df
| InstrumentDescription | MarketDataDate | Price | YieldPercent | GovernmentSpreadBp | SectorRatingSpreadBp | RatingSpreadBp | |
|---|---|---|---|---|---|---|---|
| 0 | DLR 1.375 07/18/32 '32 | 2026-03-10 12:27:52 | 86.3035 | 3.845711 | 125.345096 | 6.321215 | 26.406969 |
The following code requests bond analytics for a small set of U.S. Treasury benchmark instruments in one batch. It applies a specific valuation context, using bid-side pricing and a fixed market-data date, so all results are comparable on the same basis. The output is a table of key measures such as description, date, price, yield, and z-spread for each instrument.
import lseg.data.content.ipa.financial_contracts as ldf
response = ldf.Definitions(
universe=[
bond.Definition(instrument_code="US1YT=RR"),
bond.Definition(instrument_code="US5YT=RR"),
bond.Definition(instrument_code="US10YT=RR")
],
pricing_parameters=bond.PricingParameters(
market_data_date="2020-07-05",
price_side=bond.PriceSide.BID
),
fields=[
"InstrumentDescription",
"MarketDataDate",
"Price",
"YieldPercent",
"ZSpreadBp"]
).get_data()
response.data.df
| InstrumentDescription | MarketDataDate | Price | YieldPercent | ZSpreadBp | |
|---|---|---|---|---|---|
| 0 | UST Bill 06/17/21 MATd | 2020-07-05 | 99.851028 | 0.157329 | 10.720676 |
| 1 | UST 0.250 06/30/25 MATd | 2020-07-05 | 99.765625 | 0.297412 | 21.75372 |
| 2 | UST 0.625 05/15/30 | 2020-07-05 | 99.5625 | 0.670924 | 28.699598 |
Summary
This chapter provides a practical guide to working with bond-market data across LSEG Workspace and the LSEG Data Library for Python. It begins with discovery workflows, showing how to use Global Search, Advanced Search, RIC Search, and the Data Item Browser to identify relevant bond instruments, fields, and data definitions for downstream analysis.
It then explains core fixed-income identifier conventions, including bond RIC structure (country code, local code, delimiter, and optional source code), Super RICs, page RICs, and chain RICs. Through these examples, the chapter shows how to expand chains, navigate nested constituents, and locate specific universes such as benchmark curves, market-maker quotes, eurobond segments, and country-specific treasury listings.
From a data-access perspective, the notebook demonstrates multiple retrieval patterns: reference/fundamental data with ld.get_data, historical time series with ld.get_history, and real-time updates with streaming APIs. It also includes related-news workflows, linking instruments to headlines and full stories so users can combine price, analytics, and event context in a single research process.
Finally, the chapter introduces Instrument Pricing Analytics (IPA) for bond contracts, highlighting how standardized pricing and risk outputs can be requested for one or many instruments under a shared pricing context. This supports consistent valuation, spread comparison, and sensitivity analysis across bond sets without requiring users to manually build valuation models.