-
Downloading CDS Spread
Hi, I'm trying to compute the CDS-bond basis for each company (reference entity or issuer). The data I have now is the companies' names (e.g., 'VOLKSBANK WIEN AG') and their corporate bonds (with ISINs). To compute the CDS-bond basis, I first need to download CDS spread and bond yield for each company. For the former, I…
-
Board composition of listed companies
Hello, Is there a way for me to retrieve the list of all officiers in a company and each of their committee membership using the Codebook environment? I have raised this issue earlier, as it is possible to see a person being a member of different committees in the screener, but in the codebook we see only one committee per…
-
What are the item codes to use in a python code for Promoter holding, MF holdings, institutional hol
What are the item codes to use in a python code for data fields Promoter holding, MF holdings, institutional holdings, and their change on quarterly basis?
-
Why does this data item TR.FundIndexTracking doesn't work on API but works with Workspace Excel?
Why does this data item TR.FundIndexTracking doesn't work on API but works with Workspace Excel? import refinitiv.data as rd rd.open_session() df = rd.get_data( universe = [ 'LP40203779', 'LP40219887' ], fields = [ 'TR.FundDomicile','TR.FundIndexTracking' 'TR.FundLaunchDate' ] ) display(df) Excel formula is working fine.…
-
I want the biggest intraday move so if I have a timeseries with a minute interval at what point
I am trying to find an example in codebook examples how I can retrieve the biggest intraday move of an instrument in a timeseries data overview. So put differently what is the code to retrieve this data preferable with a supported event that triggered the move. for ICE Endex TTFA Day ahead and Month ahead 0#TFMBM this is…
-
CodeBook: Error code -1 when trying to access historical bid/ask prices via batch queries.
I am trying to access historical bid/ask prices for a list of RICs (bonds). I am querying them in batches of 500 RICs at a time. Some batches return an error code -1 with the message 'headers'. When this occurs, the entire batch is treated as invalid, and none of the observations from that batch are returned. For example,…
-
I want to pull these instruments via Python in CodeBook.
I'm interested in these tickers which I currently load via Excel JPYTN= JS(FXFWDJPYTN) Is there a standard code you can provide which saves the results to a csv, or prints to screen or something like that?
-
The client is currently using the code below. However, their universe contains approximately 1,000 t
Hi Team, Good day. Query: The client is currently using the code below. However, their universe contains approximately 1,000 to 1,500 RICs, and adding each RIC manually into the universe list is time‑consuming. Is there a way where an Excel file is uploaded in code book and the RICs are automatically ingested into the code…
-
Hello, how does the codebook work from memory point of view? Does it use cloude RAM or user pc RAM?
Query: Hello, how does the codebook work from memory point of view? Does it use cloude RAM or user pc RAM? Can I parallelize function? How much RAM is there? Moreover, can I run a code in parallel?
-
Codebook error urgent
Hi, Team — I have someone who isn't comfortable sharing his codes here in the forum but needs immediate help in making them work. May I please have someone email to quickly modify some of his code to make it work in LSEG Workspace Codebook?
-
API Queries: misaligned data
If I try the below query, it looks good: response= fundamental_and_reference.Definition( ["5000274109"], ["AVAIL(TR.F.PERIODENDDATE(STTYPE=BAL), TR.F.PERIODENDDATE(STTYPE=INC), TR.F.PERIODENDDATE(STTYPE=CAS))","AVAIL(TR.F.PERIODENDDATE(STTYPE=BAL).fperiod, TR.F.PERIODENDDATE(STTYPE=INC).fperiod,…
-
I'm working in codebook using a jupyter notebook.
I'm working in codebook using a jupyter notebook. I have some data in an excel which I want to add to my analysis. I have dropped the excel file into the same folder in codebook as my Jupyter file, however the following code cannot load the file into the Jupyter notebook: Lombards =…
-
How to use the below in Codebook?
Client wants to retrieve the EUR OIS Swap Zero Curve historically using Codebook. We have this in API Playground. how to use this in codebook? API Playground I also found this in Github but I cant get it to work:…
-
i was trying to collect data via codebook. However i found that the performance declines significant
i was trying to collect data via codebook. However i found that the performance declines significantly when i request more than 1 ric at a time. It seems that the excel add in is much quicker. is this a generic issues or are their ways to speed up the process through more efficient coding? unfortunately i can not attach…
-
Why have TR.EV.currency and TR.F.EV.currency stopped working again?
The fields TR.EV.currency and TR.F.EV.currency have stopped working again (this has happened in the past as well).For example, the Python commanddf=dl.get_data(['GOOGL.OQ','AAPL.OQ','LVMH.PA','RKT.L','MELI.OQ'],…
