-
RtGet() using lseg.data library
Hi, how would I do a function like =RtGet("SYD1", [@RIC], "COUPN_RATE") in python using the lseg.data library? Thanks
-
Quesstion about RIC code of JGB
I cannnot take bid ask price of JGB by the code attached below. I would appreciate it if you could tell me the reason and solotions to correct this problem. I think this may happen because I cannot take appropriate RIC code of JGB. import lseg.data as ld from lseg.data.content import symbol_conversion ld.open_session()…
-
Question about getting bid ask of Isincodes by Codebook V2
I use the code below to get bid ask by codebook. My code is working but cannnot get the data whose isincode starts from JP. Could you tell me the reason if possible. import pandas as pd import lseg.data as ld from lseg.data.content import symbol_conversion ------------------------ 設定 ------------------------EXCEL_IN =…
-
CBT grains settlement
Please look at the settles for Soybeans SN25 , Corn CN25 and Wheat WN25 . Why is the cirrency USc ? This is messing up our settle capture Thanks Raja 4753957364
-
Linking VBA with the Data Tools functions
Is there a way to link the excel functions with VBA? I want to start my VBA code as soon as i resume updates.
-
Convert Bonds Issued Amounts in EUR using exchange rate at Issue Date
Hi all, I would like to API request to retrieve a list of bonds, with the outstanding amounts converted to EUR based on the exchange rate as of the issue date. Currently, the GOVSRCH function in Workspace performs conversions using the exchange rate as of the previous close. Can you help me? Best Giacomo
-
"Number of user subscription exceed the limit" error: news-stories-subscriptions endpoint
Hi, I am attempting to connect to the https://api.refinitiv.com/alerts/v1/news-stories-subscriptions via a Python script on my local machine. When doing a POST request to this, I keep hitting the following error: {"error":{"id":"3aa593ff-7498-4dbc-8aca-b3882f556d0a","code":"30016","status":"422","message":"Number of user…
-
Question about parsing exchtime value
Hi, I use below logic to parse exchange time SALTIM_MS / QUOTIM_MS: var time_ms = java.lang.Long.parseLong(str) val nsec: Long = (time_ms % 1000)*1000000 val seconds: Long = time_ms / 1000 % 60 val minutes: Long = time_ms / 60000 % 60 val hours: Long = time_ms / 3600000 % 24 time = LocalTime.of(hours.intValue(),…
-
How do i get the historical adresses of US companies?
I would like to investigate the relocation of corporate headquarters of publicly listed US companies. Therfore i need the old and new headquarter addresses and ideally also the relocation date/announcement of relocation date. How do I find that data? I have access to Refinitiv and Refinitiv Eikon.
-
How to get the latest segment name of listed companies, including annual report or Quarterly
I want to obtain the latest segment name information of listed companies from Eikon, both annual report information and quarterly report information are acceptable. But when running the results with the following code, there are no results for 300 companies, here are a few examples 2382.HK, 0196.HK, 0834.HK. I think this…
-
Question about getting bid ask of Isincodes by Codebook.
I want to obtain bid ask data by Code book. The code attached below is about getting bid ask from the input data; Isincode. Could you tell me why the code does not work. import pandas as pd import refinitiv.data as rd from refinitiv.data.content import symbol_conversion as sc # ← v1.6 ではこちら 1. セッション開始（Workspace/CodeBook…
-
I want to extract the period end dates for a universe where both Local and ADR coverage exist.
ld.get_history( universe=['4295867372'], fields=['TR.F.PeriodEndDate'], start="2000-01-01", end="2030-01-01", parameters={'FRQ': 'FQ', 'Period': 'FQ0'} ) However, this code does not extract all the quarter-end dates. Specifically, it fails to retrieve the date '29.03.2025'."
-
リフィニティブAPIに関する問合せについて
＜前提事項＞ 弊社のシステムでは、ADS146.242.129.226 もしくは、146.242.133.226 に接続し、 Enterprise Message API (EMA)を利用してデータを取得しております。 ＜照会事項＞ 以下の日時、RICにてEMA経由でデータ取得を行ったところ、 2025/4/24 10:30（日本時間）では取得不可、2025/4/24 13:00（日本時間）は取得可でした。 2025/4/24 10:30 にRIC：DIBJP1WD= について、情報取得できなかった理由をご教示願います。 ・取得不可のRIC ： “DIBJP1WD=” ・取得不可の日時 ： 2025/4/24 10:30…
-
I need to retrieve the financial period end dates from the income statement using Python.
My current code workspace_df = ld.get_history( universe=str(org_id), fields=['TR.Revenue', 'TR.F.Source', 'TR.F.PeriodEndDate'], start="2000-01-01", end="2050-01-01" ) However, this only returns annual period data. How can I modify the parameters to include quarterly period as well?"
-
How can I retrieve GDP information via the Excel Formula Builder?
Hello everyone, I am quite new to Refinitiv Workspace and have up until now only retrieved company information in Excel using the formula builder. However, now I need to retrieve historical GDP data in Excel for broader geographic regions, namely the US, Europe and Asia from the year 2002 until 2012. Is there any way to do…
