-
How can I extract firm-year panel data for DAX/MDAX/SDAX companies from LSEG Workspace efficiently?
Hi, I am conducting an empirical panel study (fixed effects) on board diversity in German listed firms for 2022–2024. I need firm-year data (e.g. female board representation, ROA, ROE, Tobin’s Q, governance and ownership variables) for DAX, MDAX and SDAX companies, but I cannot retrieve these variables reliably in LSEG…
-
Best practices for OmmConsumerClient#onStatusMsg(StatusMsg, OmmConsumerEvent)
What are the recommended best practices for handling errors received via the OmmConsumerClient::onStatusMsg(StatusMsg, OmmConsumerEvent) callback? On Saturday morning, a number of our subscriptions received status messages indicating Closed / Suspect / Not Entitled / Reverify. These messages were delivered via onStatusMsg.…
-
Most recent news headlines of specific news category for multiple ISINs
Via the python API, what is the most cost-efficient way of obtaining the news headline of a given news category (e.g., scheduled events) from a date closest to a given input date for a given list of different ISINs? More precisely, the inputs are a list of ISINs, a date, a news category while the outputs should be…
-
API query
Hi Team, Is there a way in API to pull a RIC using Company name? Our client has a total of 1500++ Company name, we are trying to check if we can have an option to pull the RIC using API.
-
what should I do ?
I am facing an error I am not able to use anything in the platform
-
Downloading historical ETF holdings
I want to download the historical stock holdings of an ETF (VONE.O). I tried the following: holdings = rd.get_data(universe = ['VONE.O'], fields = ['TR.FundHoldingRIC', 'TR.FundHoldingName', 'TR.FundHoldingsDate', 'TR.HoldingsDate', 'TR.FundNumberOfShares', 'TR.FundPercentageOfFundAssets'], parameters =…
-
Converting mnemonic to RIC for python use
.
-
Query on Accessing Global Exchange Holiday Calendars via LSEG Python API
I am currently working on global equities data and need access to official trading holiday calendars across multiple exchanges. I am using the LSEG Python API for data ingestion and wondering if there is a way to retrieve: i) Future trading holidays across global equity exchanges ii) Historical holiday calendars, including…
-
client request DSS API
Can you please assist ? Client asked for a piece of code (SQL Snowflake or Python API) or the necessary documentation to write that code. The code has to : 1. Receive a currency pair and a date as input 2. Return the implied volatility for the currency pair that given day. Another side question, I checked the endpoints you…
-
How to create agents using N8N?
Hi Team, I have a Workspace Client who is learning to create agents using N8N. The client is planning to create his own agent one day and hope it will be able to access Workspace via an API. Additional client verbatim: "It is my understanding that most software providers are providing api keys for ai agents, like N8N,…
-
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?
-
Disable SSL verification
how we can disable the SSL verification in the python implementation/code. This is the error ERROR: An error occurred while requesting URL('https://api.refinitiv.com/auth/oauth2/v2/token [api.refinitiv.com]'). ConnectError('[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self-signed certificate in certificate…
-
API Endpoint for Data Notifications by Product/ProductID
Hello, I was exploring the Alerts and Notif APIs on the API playground and I can't seem to find an endpoint where I can find data notifications related to a specific product/productID (i.e Real-Time Managed Distribution Service). Is there an endpoint for that? Also, I seem to not have permission to play around with the…
-
unable to get portfolio weights for custom portfolio using ld.get_data("PORTFOLIO(Borealis)",
Hi Team , unable to get portfolio weights for custom portfolio using ld.get_data("PORTFOLIO(Borealis)",['TR.PortfolioStatementDate','TR.PortfolioModifiedDate','TR.PortfolioConstituentName','TR.PortfolioShares','TR.PortfolioWeight', 'TR.CompanyMarketCapitalization(Scale=6)'] ) second screenshot shows expected output using a…
-
Get_history request is not returning same fields - Unexpected error in data returned from data sourc
Hi The below request has worked very reliably over the past few weeks when I tried: df_prices = get_history( universe=ticker, fields=['TRDPRC_1','ACVOL_UNS','TRNOVR_UNS','VWAP', 'TR.TotalReturn', 'TR.CompanyMarketCap'], interval='1d', start=start_date, end=end_date, adjustments='CCH' ) But today I tried three times and…
