-
Evariste NYOUKI
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?
-
Wildcards in news search
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…
-
[First-time user] Real-time Engine Initialization Error
Hi, I logged onto Refinitiv Eikon - Microsoft Excel for the first time and tried the following code on A1 cell. "=@TR("IBM","CF_CLOSE","RH=IN")" The Refinitiv Eikon is online, as does the Datastream, and I tried several variations of the code from the user guide and I still have a difficulty debugging the error "Real-Time…
-
Does Eikon API library work via Fabric notebooks?
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…
-
Annual fundamentals data and institutional holdings data
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",…
-
Using Python API: Check all elements in a list are a valid RIC
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"…
-
filter companies by natural gas use / natural gas purchase
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!
-
News API filters exclusions
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…
-
Is it possible to make a connection to Eikon data API through a Python script in AWS?.
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…
-
RDP instrument search and Entitlements
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,…