Hello I am trying to download fundamentals data for a number of years (2000-2024) and RICs. The code I use is like this: data_items = [ "TR.CIKNumber", "TR.NAICSIndustryGroupCode", "TR.TotalAssets.date", "TR.NumberOfAnalysts", "TR.TotalCurrentAssets" ] parameters = { "SDate": start_date, "EDate": end_date, "Frq": "Y",…
My ultimate aim is to be able to do a Ekion Python API query like this df_ric, err = ek.get_data(RIC_List, ['TR.PriceClose','TRDPRC_1'],) Where RIC_List has 1800 elements, 99% of which are RICs in string format and the remaining 1% are not RICs and need to be skipped automatically. (Querying each element using a "try"…
Hello team, reaching out on behalf of a client. Could you please help me with getting the analyst forecast data and actual EPS data for all US firms from 2000-2024 via Python? We cannot use Excel since the number of firms is too large.
Hello, I'm trying to build a news query and was wondering if there was a way to pass through freetext phrases that could use wildcards. For example, I have this below ( ( Topic:FUND AND Language:LEN ) NOT ( Source:DJN OR Source:FT ) NOT ( \"Net Asset\" ) ) But the text search ignores the filter if the news phrase is "Net…
I'm trying to filter out news through the EIKON api and have built the following query. I would expect this to exclude news items sourced from LSE but I find news items from this in my resultset. ( ( Topic:FUND AND Language:LEN ) NOT ( Source:DJN OR Source:NBSX OR Source:HIIS OR Source:HOSE OR Source:PHSE OR Source:BSE OR…
I wonder if there is a way to be using eikon library via Fabric notebooks ? like so: # Connect to Refinitiv and get datadf_holdings, FundHoldings = ek.get_data([fund_isin],['TR.FundHoldingName', 'TR.FundHoldingRIC','TR.FundPercentageOfFundAssets', 'TR.FundLatestFilingDate'],{'Endnum':'5000'}) would you have a code sample…
Hello I want to retrieve open interest data on some futures contracts. With ek.get_data, I can indeed retrieve the last data. But what I want is the price series. And with ek.get_timeseries, it doesn't work: I get NA values. Does anyone have a solution?
Hi all, I have a python script to retrieve data using Eikon Data API, which works when I run it in my local visual studio code, but I wanted to automate it through AWS. Here the connection is not working because (I believe) to do it through the API, a session must be logged in in the Eikon terminal. This is the error it's…
We pull instruments using these following queries from RDP /search api. curl --location "https://api.refinitiv.com/search/beta1/" --header "content-type: application/json" -H "Authorization: Bearer ....” --data "{ \"View\": \"SearchAll\", \"Filter\": \"RIC eq 'MNI50500J5'\", \"Select\": \"RIC, RicRoot,…
Hi, I would like to filter companies by their natural gas consumption/purchase. Is this possible? So far I have not been able to find a suitable filter. Thanks for your support!
It looks like you're new here. Sign in or register to get started.
