-
How do i use the api to extract market overnight best and worst performers ?
I am coding in python with your desktop eikon api to try and extract the latest leaders and laggers across different asset classes inc fx, stocks, bonds, etf and crypto assets but failed I also trying to extract based on news but theres only broad economy news which i cannot zoom into asset specific .. how do i screen for…
-
volume data across venue
Hello, I recently noticed a discrepancy in trading volume from Eikon Data API for Canadian stocks. In particular, when comparing the consolidated volume for a ticker (say, 'TD') using the RIC = 'TD.CCP' with the aggregated volume for the ticker across all trading venues, I found that before 2024 they are quite close to…
-
How can I modify the VBA code to ensure that the RDP.HistoricalPricing formula always retrieves data
"We use a loop in Excel-VBA to retrieve historic data with RDP.HistoricalPricing() for a list of RICs. This process is often unstable as for some RICs we don't get data. The issue is not replicable, sometimes we get all data, sometimes some RICs don't get any data. We tried several ideas from LSEG help page e.g. use…
-
In Codebook, the screener does not work when the field TR.NAICSNationalIndustryCode is included. For
In Codebook, the screener does not work when the field TR.NAICSNationalIndustryCode is included. For example, the commands screener_output=Screener('U(IN(Equity(active,public,primary))), IN(TR.GICSSectorCode,"45"), IN(TR.NAICSNationalIndustryCode,"513210"), TOP(TR.H.EV(Curn=USD),7,nnumber),Curn=Native')…
-
Historical OHLC request freezes for 50+ ETF RICs over a 14-year range
I am trying to extract daily OHLCV data for a list of instruments using the Refinitiv Data Library. Here is the code I am using: import refinitiv.data as rd import pandas as pd rd.open_session() instruments = [ "IWDA.L","VAVUAG.L","VWRP.L","VWRA.L","EEDS.L","ISACI.L","SWDA.L","EIMI.L",…
-
Geograin Data through API
Hi! New(er) to using this API. I am trying to fetch basis data for the past month in order to model, using the geograin RICs. My dataframe was returning empty, See code chunk below. I'm a bit confused because DIB in workspace doesn't show any time series codes non-blank for the RIC, but I have a working excel formula (also…
-
how to get web link of a news article of I have its URN?
Hello Team, I would like to check if there is any programmatic method or API capability that allows us to retrieve the public web link for a Reuters news article directly from the NewsML URN returned by the API. For example, for the following URN: urn:newsml:reuters.com:20260312:nL1N40006E I was able to manually search…
-
Why am I losing trades when streaming tick data for YTCc1 using the LSEG-data pricing stream, even t
I am trying to stream tick level information about YTCc1 using the LSEG-data package in python. I can pull tick histories no worries, but i seem to be losing trades on the stream. I am only getting a small subset of trades in my stream. I have the require data permissions i believe, as i can see the tick stream in the…
-
How can I retrieve historical values for FID 9940 for Q‑suffix RICs using Python?
I am trying to extract historical data for FID 9940 for several Q‑suffix RICs. I am using the lseg-data Python library and the get_history() method, but it does not return any data for this field on historical dates. From what I understand, FID 9940 may be a real‑time or snapshot-only field, but I need to confirm whether…
-
The close price from the workspace doesn't match the one from the API
When I search for the price of EVs1 in the workspace, the closing price displayed on the page is inconsistent with the price obtained through the API. However, the Open, Low, and High prices are the same.
-
How to map Screener "Data Item Names" to "Data Item Codes (TR Codes)" via API or Master Dictionary?
I am an academic researcher using the lseg.data Python library to extract historical M&A data (SCREEN). Currently, I use the Workspace Screener to identify the variables I need. However, the Excel export only provides the "Data Item Name" (e.g., Premium Paid - 4 Weeks Prior to Announcement, Target Primary Ticker Symbol),…
