Unable to make the script work

Cayla_Soriano27

Hi Team,

Good day!

This is under case: 15584196
Query here is that the client seems to have experienced some issues pulling up the script below:

try:
session.open()
ld.session.set_default(session)
session.open_state

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_ss = ld.get_history(
universe=["USDSB3L5Y=RR",
"USDSB3L10Y=RR", #US ZC SWAP not working
"CADSB3BA5Y=RR", "CADSB3BA10Y=RR"],

start="2024-01-01",
end="2050-12-31", #change this in 2050
interval="daily",
count=None,
fields="" # 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_ss)

session.close()

Client also wants to have a teams call regarding this (which I can create upon your team's approval).

Can you kindly help us here?

Thank you!

Jirapongse

@Cayla_Soriano27

Thank you for reaching out to us.

The question and code appear similar to this discussion. Please review the answer provided in that discussion.

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.