-
GET CONSTITUENTS OF AN INDEX USING PYTHON CODE
How do I get the constituents of nifty 50 which is depicted by INNSE50 or .NSEI , I can see that on the datastream navigator but i want to extract via python code. I am trying to use this, df, err = ek.get_data( instruments = ['INNSE50'], fields = ['TR.IndexConstituentRIC', 'TR.IndexConstituentName'], parameters = {…
-
ADVERS app- broken not showing data
Research search function not working. Says No data available with no filters.- ADVRES I am trying to pull broker reports upon the release of the FY24 results, for Swisscom
-
FX cross in Turn Dates in API
Hi team, Specialist here from Customer Support. Related to this q&a Is there a way to retrieve Turn Dates for a specific currency pair directly on Python ? — LSEG Developer Community there is a specific parameter if you want to calculate CCy1 or CCy2 which is then discussed in this guide:…
-
I would like to inquiry about codebook, is the python environment secured and not open source? and a
I would like to inquiry about codebook, is the python environment secured and not open source? and also what server process the code? is the used library like numpy, pandas, matplotlib, scipy and etc secured and guaranteed from your side ? also can we execute the code internally on bank premises rather than AWS cloud?
-
how to select a list of companies in ADVEV app
Hi, I want to download earnings call transcripts of about 700 companies using ADVEV app, but I cannot use country or industry classify them. The companies are listed in an excel document. I wonder if "RIC/Company/Portfolio/List" could help me with this problem. Or if there is any better method than manually entering. Thank…
-
WS API How to Retrieve MBS, ABS, and Corporate Bond by Country or Currency
Currently, Our client is looking to obtain data on U.S. MBS (Mortgage-Backed Securities), ABS (Asset-Backed Securities), as well as corporate bonds categorized by country or currency. Until now, he has been using the following method to retrieve government bond data. However, he have not been successful in acquiring MBS…
-
Clarification on RIC Suffix with “^”
Hi, I have a list of RICs that include the suffix “^” followed by a letter and number — for example, ARNC.N^H23 and GTX.N^I20. Could you please explain what the letter and number after the “^” represent? Thank you for your help!
-
S&P 500 Index constituents every month
How can I get S&P500 index constituents every month since 2012-01-01? I am using excel sheet to download the data. I have tried using the function =@RDP .Data(".SPX","TR.IndexConstituentRIC","SDate=2012-01-01 CH=Fd RH=IN",B1) to get the ConstituentRIC, but it returned NULL. May I know why and how to solve this problem?…
-
How do I access alternative close prices via python API
Help! Is it possible to access alternative close prices from the python API? For example BRTDTDMc1 has 2 close prices. ASIA_CLOSE, EU_CLOSE, US_CLOSE, I want to access the ASIA close price as I am trying to find a common timestamp for the below list of prices. Reuters Code' : ['DUBSGSWMc2', 'MRBN1MMASc1', 'OQc1',…
-
Stream timeouts on websocket under python lseg.data API
We're streaming LSEG data using the LSEG Data Library for Python, using lseg.data.content.pricing. Sometimes— seemingly at random (different times of day, sometimes after streams have been up for hours, other times after just minutes), we receive Stream.on_status events with the following (example) payload: status: {'ID':…
-
Could you please try running the code below on your end to see if the same issue occurs?
Hi Team, Client have raised the below query. Could you please assist on the request. Query: May I ask you to try my code on your side, and see if the bug appears for you as well? It seems from your explanation that RDP is a more reliable backend platform. Why does this bug appear there then? My code again, for your…
-
Current sales, Net margin and wages or labour costs' and need to add to the field TRDPRC_1 with the
Current sales, Net margin and wages or labour costs' and need to add to the field TRDPRC_1 with the correct RIC I would like to download the 'current sales' , 'net margin' and eventually 'wages' or 'labor costs' and need to add to the field TRDPRC_1 with the correct RIC, wchich i do not find in the DIB ... can you and your…
-
App key is incorrect
I am getting this error. I've tried using a new API key but it isn't being resolved: 2025-08-05 11:51:37,203 P[50440] [MainThread 14636] Error on handshake url http://127.0.0.1:9000/api/handshake : EikonError(1, 'Status code 400: App key is incorrect')
-
How to pull historical price data for multiple companies in Excel using Workspace?
Hi everyone, I'm building a database in Excel with about 100 listed companies and indices. I want to pull historical closing price data for each of them—ideally with the dates in the first column, and each company's closing price in separate columns. I've used the formula builder tool in Excel to get the latest share price…
-
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 =…
