-
Problem connecting to excel PowerlinkCOMAddIn.COMAddIn using python win32com.clieny
I am trying to open an excel workbook, connect to the Refinitiv Addin and refresh some formulas using python win32com.client, but unfortunately that is yielding an error as highlighted below. Here's the code I am using: import win32com.client excel = win32com.client.Dispatch("Excel.Application") wb = excel.Workbooks.Add()…
-
I would like to check if the .bat file attached is compatible to run with Workspace?
Hi Team, the client wants to use a .bat file that will allow him to launch the Workspace Excel add-in. However, it is causing an runtime error in Workspace Excel. May I know if this is compatible with Workspace? Please note the same .bat file is working with Eikon.
-
Getting Best Match via Entity Search API
Hi, Please see my code below my sanctions_df_upgrade has a column caption which are company names. I am looping over that column and mapping it against the PermID db via the Entity Search API My ask is - now I am assuming that the first match found with the parameter num set to 1 is the best match. But is there a better…
-
LSEG Data Library for Python - extended documentation for valid parameter values
Where can i get full documentation of all the valid arguments that can be used with the LSEG Data library for python? For example, the get Fundamentals data function takes a dict for the parameters argument - where can i get a list of all the keys and definitions that are supported for this arg?…
-
Back-end errors in get_data and SCREEN
Hello - I have a script that I've used for over a year without many problems, but lately I am getting a lot of "400 Bad Requested universes". You can see below I am screening for companies. When I put this screener syntax in Excel's TR function, I am able to download companies fine. However, I need this Python workflow to…
-
retrieve and concatenate results return from historical pricing parallel requests with events
Based on this github example, i learn how to create parallel requests with events , where i need to retrieve snapshot data. However, I have a question, how do i concatenate the results to form a larger dataframe ? Code below produce errors, as df_snap is referenced before assignment. Can someone show me the propoer way to…
-
LDError: 'dict' object has no attribute 'url'
Currently, I am encountering an error when using either rd, or ld while making data requests through the API gateway. The error is: "LDError: 'dict' object has no attribute 'url'". Please assist me with this issue.
-
Obtaining a large number of LEIs from using PermID
I used OpenPermID's match function to match names to PermIDs in bulk, and I would also like to know the associated LEIs if possible. However from the documentation it seems the only available way to obtain it is by using the lookup function and checking 'tr-org:hasLEI', which would require a separate request for every…
-
about start / end parameters
I have a question regarding parameters. I found the start param is inclusive and the end param is exlusive on this forum, but I am unable to retrieve the data a s expected. df=get_history(universe= "MCU0", fields= ["OPEN_PRC","HIGH_1","LOW_1","TRDPRC_1","CASH_SETL"],start='2024/12/6',end='2024/12/10') [out] MCU0 OPEN_PRC…
-
Please help with this code, since I am unable to make this code work "OLS Regression[3]" from RDP wi
The chart table is not returning any values for OLS regression. Full code below and I have highlighted in bold for the code on "OLS Regression[3]". import getpass import refinitiv.dataplatform as rdp # the RDP library for Python import pandas as pd import numpy as np import cufflinks as cf # to plot graph by pandas data…
-
how to calculate annual dividends per share using direct functions or python?
I need assistance with obtaining dividend data from various companies. Since not all companies pay dividends at the same intervals, it is most practical to calculate the total annual dividend. In the attached image, you can see that individual dividend payments are listed. However, I would like to display the summed annual…
-
How can we know which fields are available for returning time stamps using get_history?
I am trying to receive time stamps (more granular than daily) using get_history. I know there are different intervals that I can select, and I can return time stamps with certain items. I am curious if there is a way to identify which fields can be retrieved for time stamps using get_history. I understand get_data function…
-
Would appreciate an explanation for it?
I am trying to pass a request for a ticker symbol, that is valid. Still it always throws an error with message of Investor Full Name. Any idea what is about? I can relate it to having investor names empty and so on.
-
How to extract company wide data
All, I am new to this data set- As part of trial , we have a daily dump of news (***.news.refinitiv.com) in a complex json structure (The file we got is RDP_STORY_T30.RTRS_CMPNY_EMEA.2024-11-05.REC.JSON) I am trying to extract the data like Data published, symbol,title and news etc. Due to complex structure and too much…
-
error message: Error.EikonError: Error code 400 | Backend error. 400 Bad Request
Hi, I am running code that was once reliable, but now I get a backend error about half the time the code runs. ek.get_data('0#.AORD(2024-01-01)', other_fields+beneish_fields+altman_fields, {'Period': 2024}) other_fields+beneish_fields+altman_fields: ['TR.CompanyFYearEnd', 'TR.F.TotRevenue(Period=2024).periodenddate',…
