-
Need help on how to link Workspace with power BI
I am trying to use the API method with Python. The issue is that due to company restrictions I only have access to the PyCharm environment, which complicates things as all guides seem to be using Jupyter or similar environments (with syntax that isn’t recognized by PyCharm) The first hurdle is to install the Refinitiv data…
-
I'm not connecting through the CodeBook app directly. I'm using VSCode with an external environment.
Hello Team. This is an issue on behalf of a client: "I'm using Python 3.10.12 and the refinitiv.data (rd) package, version 1.6.2.When testing your code in my environment, I encountered the following error: RDError: Error code -1 | Insufficient scope for key=/data/datagrid/beta1/, method=POST failed. Required scope:…
-
Workspace Add Analysis>EMA display different numbers than pd.ewm using Python
Using the following snippet as in a former question [Is it possible to pull Exponential Moving Average data using the RD Library?](https://community.developers.refinitiv.com/discussion/112022/is-it-possible-to-pull-exponential-moving-average-data-using-the-rd-library/p1?tab=accepted) for `TSLA.O` will give an EMA endpoint…
-
Data S&P 500 to excel - beginner
Hello everyone, I'm a complete beginner using refinitive Eikon for my Master's thesis. I need data on the manufacturing companies of S&P 500 from the years 2010 to 2019. How can I dowload lists like this so that I have it in an excel file? Is it possible to download who was CEO for the respective company in those years?…
-
How to retrieve corporate bonds from a list of parent companies and their related subsidiaries
Hello, I'm trying to develop a method to extract all bond emissions for a list of companies by using Workspace API. Starting from a parent company ID, I can get all the related subsidiaries / affiliates. My goal now is to retrieve to retrieve all the bonds from the parent company and subsidiaries, but only the corporate…
-
How to convert the example ("Automating_Trendline_Feature_Generation") for a currency
One the CodeBOOK app, there is an example name "Automating_Trendline_Feature_Generation" ( Examples/08. Trading/Automating_Trendline_Feature_Generation.ipynb). In this example, they use the index "0#.FTSE". My request is that i want to use this analysis not for an stock index but for FX currency like EUR/USD; But i do not…
-
How can I pull VIX index price data via BigQuery?
I would be particularly grateful for some sample code. Thank you!
-
Python ld.get_data() Unable to collect data for field 'TR.ASKPRICE.DATE' and some specific idenfier
I have a list of over 800 bond ISIN and I am using ld.get_data() in a loop to download historical pricing data in chunks (see attached txt file). I need a solution to handle cases where no data is available, so that no errors are returned. First isin chunk: ['ES0200002022', 'IT0005057770', 'US00289WAA99', 'USE00020AA01',…
-
How can I find the RIC for green bond ISIN to download historical prices?
I obtained a list of green bond ISIN via rdp.search() tool using python. For this list I then wanted to download historical prices. This also worked for most of the green bonds. I obtained prices between 2018 and 2023 using rdp.get_data(). However for some ISIN only bid prices are returned and no ask prices or spreads. I…
-
Python Query
Hi! I am trying to develop a Python script to get the GPS position of ships from Eikon. I already have an API key, and the problem I am facing when running it is the following: Check if Eikon Desktop or Eikon API Proxy is running. 2024-12-26 08:51:57,091 P[21284] [MainThread 27348] Error on handshake url…
-
Fastest way to pull API data to existing DataFrame (using nonhemogenous SDate)
Very curious to learn if there is a better (faster) way to pull API data on an existing df when the 'SDate' varies by row. I'm new to programming, so I've only figured out how to do this using a for loop. Is there a better (faster) way to do this? Example code below: [1] import refinitiv.data as rd [2] import pandas as pd…
-
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?…
-
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.
-
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…
