-
Python Codebook Download Format
Hi Devportal, I have a few code on python codebook and looking to download as .py format no as .ipynb format. Please help me if you have any way to download it. Thank you.
-
Were there recent changes to "TR.IndexJLConstituentRIC.date" and "TR.IndexJLConstituentRIC.change"?
I used to get index changes in the SPX using the following code: index_changes = rd.get_data(universe = index_ric,fields = ["TR.IndexJLConstituentRIC.date", "TR.IndexJLConstituentRIC","TR.IndexJLConstituentName", "TR.IndexJLConstituentRIC.change"],parameters={"SDATE": init_date,"EDATE": end_date, 'IC':'B'}) As of…
-
Codebook App 30 min time frame
i have a question regarding LSEG Workspace as specially the Code Book App. I want to get historic data of an instrument e.g. LSEG.L for the fields BID, ASK and VOLUME on an 30 min time frame. In Excel it is possible to get the data via the Workspace Add-In. But in the Workspace Codebook App I don’t get the VOLUME data. How…
-
Unable to load syntax in Workspace Codebook. Result only shows blank line or black square.
I am trying to run the code below but I'm only getting blank result or a black square as a result: import refinitiv.data as rd rd.open_session() df = rd.get_data( universe = [ 'FDBc1' ] , fields = [ 'CF_CLOSE', 'CF_VOLUME', 'HST_CLOSE', 'HST_VOLUME' ] ) display(df) and import refinitiv.data as rd rd.open_session() df =…
-
Is there a validation process on the pricing templates in the codebook?
May I know is there a validation process on the pricing templates in the codebook? (e.g. FX forward, FX option, etc.)
-
Missing data for some RICs
In Codebook, the Python commands import refinitiv.data as dl dl.open_session() RICs=['MMM.N','BAG.L','AOS.N','AAON.OQ','ABDP.L','ABT.N','ABSO.ST','ACN.N','ARBN.AS','ADSGn.DE','ADBE.OQ','ADYEN.AS','ABNB.OQ','ALRM.OQ']…
-
Raising obo a client: TR.F.TotAssets in API
I am trying to retrieve some balance sheet data for a sample of large cap in euro area. Among them, I am not able to find the data even though I was able to 2 weeks ago: ACBr.AT FR0000131104 DE0005140008 ES0180907000 IT0005239360 DE0005552004 DE0007100000 ES0148396007 FR0000120073 FR0010208488 Do you know why is this the…
-
How to pull Outstanding Bonds of an Equity RIC categorized by Currency via Workspace CODEBK?
I would like to pull in the following data into CodeBook. Under the Debt and Credit tab, you can display the amount of bonds outstanding for a certain company (ex. APPL) sliced by currency. What is the name of this data in the data item browser, so that I can pull it in CodeBook?
-
Loop mutual funds holdings
Hi everyone, I am trying to download mutual fund holdings data using the following code in codebook: import refinitiv.data as rd from refinitiv.data.errors import RDError import pandas as pd import time LP=[ 'LP40215045', 'LP40212543', 'LP40235060', 'LP40209239', 'LP40209247', 'LP40215141', 'LP40212555', 'LP40209256',…
-
How do I connect the kernel on codebook (found in Workspace)? The kernel doesn't connect.
-
Phyton formula to get data for future contracts both active and expired. ie ESU25, ESU24^2
I am attempting to do that I hope you can provide guidance on. This will all be done using Python, which it is good to go. As an example, we can focus on the S&P E-mini (ES). 1) Is there a way to get all contracts for a future instrument? For example, expired, active, and future contracts. 2) Once we get the contracts, is…
-
Codebook Python missing results
In Codebook Python the command df=rd.get_data(['AAPL.OQ','LVMH.PA','APX.AX'], ['TR.ISINCode','TR.CompanyMarketCap.currency','TR.EV.currency'], parameters={'curn':'NATIVE', 'NULL':'Blank'}) returns <NA> for field TR.EV.currency. This was working all the time without problem until today when it failed. The problem was…
-
CodeBook Crontab or something similar for scheduling Python scripts
Hi everyone, could you please let me know if there is a way in CodeBook or anywhere else in Workspace to configure a task that would run a Python script at a specific time every day? Currently, I download the data manually by running the code, but I would like this process to be automated and executed daily at the same…
-
Scheduled Runs in Codebook
Is it possible to schedule runs at specific times in codebook? Alternatively, can I access get_data in refinitiv.data.eikon outside of codebook or is that only possible within notebook? With get_data I get exactly the data I need from within notebook, now I am looking for a way to schedule this process, either within…
-
Time out error when downloading bonds from the govsrch
Dear community, I am trying to download bonds information data from the govsrch using the following code: # Define the start and end dates start_date = '2025-01-01' end_date = '2025-06-30' # Generate a list of dates between the start and end dates date_range = pd.date_range(start=start_date, end=end_date) # Convert to a…
