-
Fewer Observations when downloading data again
Hello everyone, I am a PhD student and I've been using Refinitiv to download firm-level data for my research. I'm currently facing a problem. I downloaded my main dataset around September 2024. In March 2025, I needed to add another variable, so I re-run the same script to download the data through the Python API. The…
-
Retrieving Bond Rating Data Based on Tickers
I'm trying to retrieve the most recent bond ratings from Moody's, S&P, and Fitch from a list of tickers. I convert the list of tickers to both ISIN and RICs with this code that seems to work: I tried throwing the whole list of codes as either RICa rics = codes['RIC'].tolist() or ISIN as isin = codes['IssueISIN'].tolist()…
-
How to get historical price data of GOV BOND(EXPIRED/MATURED) like JP10504214C9 more efficiently
It seems to work below code but is there more efficiently codes like historical_function in workspace API? ### import refinitiv.data as rd import refinitiv.data.content.ipa.financial_contracts as rdf from refinitiv.data.content.ipa.financial_contracts import bond rd.open_session() import pandas as pd from datetime import…
-
Evaluation Number of members of the Executive Board
Hello, I am new to the Refinitiv Workspace and am currently investigating factors influencing executive compensation (empirical analysis). Unfortunately, I have not yet found the number of members of the management board. Is there a suitable key figure that tells me this? I would like to know the number of people who cause…
-
cannot import name 'get_service_and_details_omm' from 'lseg.data.delivery._stream'
Hi, When I try to run the code bellow, I have the error ImportError: cannot import name 'get_service_and_details_omm' from 'lseg.data.delivery._stream' import lseg.data as ldimport pandas as pd ld.open_session() # Store data in DataFrames df1 = ld.get_data( universe=['LCOCALMc1'], fields=['CONTR_MNTH', 'EXPIR_DATE',…
-
Workspace Python API: Error: no proxy address identified
We are currently migrating our users from Eikon to Workspace, and they are trying to run their Python scripts using the same scripts and api key that they used with the Eikon API (that as I understand should work fine for Workspace?). However they are getting the following error, which they don't get when the Eikon API is…
-
Total Return for an Index
Hi, I would think this would be an easy question, but I can't seem to get a total return for S&P 500 (or other example indices, for that matter), but the formula works fine for stocks. Can someone please advise? My call is below: ek.get_data(['.SP500'],['TR.TotalReturn'],{'SDate':'2017-01-01', 'EDate':'2018-01-01'})
-
get_symbology() from SEDOL to RIC returns "no best match available"
I am trying to convert SEDOL to RIC through get_symbology, but it returns "no best match available". Meanwhile, Same SEDOL is able to convert SEDOL to ISIN. However, I tested it with other SEDOL, it is able to convert SEDOL to RIC. Those unavailable assets are mainly ETFs, and I wonder is this the reason that cause the…
-
meaning of the field VOL_X_PRC1
What is the meaning of the field VOL_X_PRC1. Does this imply VWAP? I see in the Eikon as well as the Workspace product, the field VWAP is not supported when requesting data. Can VOL_X_PRC1 be used for VWAP. Are there any other recommendations for the same.
-
Different Volume of historic intraday bars for CFI2Z5
Hello, I've found that the volume for CFI2Z5 and other futures is often different when requesting the historic data subsequently in a short space of time. Is this expected, or could there be another way to request the data so the historic volume remains constant. I've used the HistoricalPricing-Summaries project in the…
-
How can I print an Workspace QuoteApp Window from workspace Excel VBA
Hello I'm using workspace , could you please tell me how i can open a print quote from refinitiv workspace VBA ? I used "reuters://REALTIME/verb=FullQuote/ric= on refinitiv EIKON excel , but with Workspace excel , it doesn't work
-
how to migrate from EikonDataAPI_46 to LSEG Workspace ?
We have built Historical and Realtime code to extract prices from Refinitiv Eikon using EikonDataAPI_46. https://github.com/LSEG-API-Samples/Article.EikonDataAPI.DotNet.Library/tree/main/EikonDataAPI/EikonDataAPI_46 Can someone advise what is the best way to migrate this to LSEG Workspace?
-
Discrepancies between TotalAssetsActual and TotAssets values for EA banks
Hello, We regularly query banks data from Refinitiv Workspace for TotalAssetsActual. We noticed several discrepancies between the values of this variable and those of TotAssets, though in principle they should align. Specifically: for some banks and periods, e.g. RIC DBKGn.DE - quarters between 2023 Q1 and 2024 Q3, there…
-
What is the rate limit of events api of historical pricing in LSEG Data Library？
I am using the LSEG Data Library for Python to extract price data via Workspace. I divided the ric list into a few groups, and each group contains 25 rics. Then I tried to retrieve the data in a loop. It worked for a few minutes and finally threw out 429 error. I noticed there is rate limit for RDP API, but not sure if it…
-
Filing API returns error message "User did not have entitlements to the field".
Hello, when I tried to get filing data with Python Filing API, I only get NAs and above error message. I was able to download full correct data using ADVFIL function on LSEG WORKSPACE desktop app. However, I need to acquire filing data for over 3,000 firms. I cannot download all of it manually. Here is my code:…
