Why is close not possible for the below:

MarcAnthony.Arce

1. Why is close not possible for the below:

# Pull selected rics, in this case a GoC bond, the 10 year benchmark and the 5 year benchmark. To get a list of the RICS associated with specific securities, you can simply browse the workspace application or try with "CA&cusip&="df_3 = ld.get_history(universe=["CA10YIL=RR", "CA30YIL=RR","US3MT=RR", "US2YT=RR", "US5YT=RR", "US10YT=RR", "US30YT=RR","DE3MT=RR", "DE2YT=RR", "DE10YT=RR", "DE30YT=RR","GB3MT=RR", "GB2YT=RR", "GB10YT=RR", "GB30YT=RR","GB3MT=RR", "GB2YT=RR", "GB10YT=RR", "GB30YT=RR",], #RIC code, can add more in the [] bracketsstart="2024-01-01",end="2050-12-31", #change this in 2050interval="daily",count=None,fields="OPEN_YLD" # This pulls ALL available historical fields. Add specific fields like "BID" to get specific columns. Multiple can be added by using [] e.g.["BID","ASK"]).reset_index()finally:display(df_3)

2. How to get ice bank of America credit spreads to government OAS

3. why can't I pull aCAXTWNF/C in Python?

Jirapongse

@MarcAnthony.Arce

Thank you for reaching out to us.

You can ignore the fields parameter and the library will return all available real-time historical fields. For example:

df_3 = ld.get_history(
    universe=["CA10YIL=RR", "CA30YIL=RR","US3MT=RR", "US2YT=RR", "US5YT=RR", "US10YT=RR", "US30YT=RR","DE3MT=RR", "DE2YT=RR", "DE10YT=RR", "DE30YT=RR","GB3MT=RR", "GB2YT=RR", "GB10YT=RR", "GB30YT=RR","GB3MT=RR", "GB2YT=RR", "GB10YT=RR", "GB30YT=RR",], #RIC code, can add more in the [] brackets
    start="2026-01-01",
    end="2050-12-31", #change this in 2050
    interval="daily",
    count=None,
    #fields="OPEN_YLD"
)

df_3["CA10YIL=RR"].columns

The available fields for CA10YIL=RR are:

Index(['HIGH_1', 'OPEN_PRC', 'LOW_1', 'HIGH_YLD', 'LOW_YLD', 'REAL_YLDA',

       'ACCR_INT', 'BID', 'REAL_YLDB', 'MID_PRICE', 'REAL_YLDM', 'ASK_HIGH_1',

       'ASK_LOW_1', 'OPEN_ASK', 'OPEN_YLD', 'AST_SWPSPD', 'ASK', 'ZSPREAD',

       'TRTN_PRICE', 'BEVEN_INF', 'INT_BEI'],

      dtype='object')

This forum is dedicated to software developers using LSEG APIs. The moderators on this forum do not have deep expertise in every bit of content available through LSEG products, which is required to answer content questions such as this one.

The best resource for content questions is the Helpdesk support team, which can be reached by submitting queries through LSEG Support. The support team will either have the required content expertise ready available or can reach out to relevant content experts to get the answer for you.

You need to ask for the Excel formula, such as =RDP.Data and =RDP.HistoricalPricing, that can be used to retrieve the required data. Then, we can help you converting that formula to Python code.