-
In RDP API Datagrid I get a few total assets values for the same fiscal year period. How is that pos
In RDP API Datagrid I get a few total assets values for the same fiscal year period. How is that possible? Please see screenshot attached. I have many similar examples.
-
How to pull whole list of active bonds for an issuer in python
In python, I need to download the full list of bonds that are currently active on the italian BTP curve. For each bond, I would like this information: -Cusip -ISIN -Dirty Price -Coupon -Last coupon date -Next coupon date -Issue date -Maturity -Description -yield to maturity For something else, I'm currently using the…
-
Requesting multiple instruments of historical data at once is only returning the top data point?
I am trying to figure out the best way in the C# Workspace Data API to pull out historical OHLC data for multiple markets at once to increase the speed instead of doing one by one. Using this sample project: 2.1.01-HistoricalPricing-Summaries My issue is that if I have a list of symbols... in response1, where i pass a…
-
how to calculate daily return for group of stocks in a dataframe & put output in different column
Hello, I have a list of some say 8 stocks in a dataframe from a sample universe of 4000 stocks. The stocks are listed by their RIC. I want to calculate the daily return & derive that output in a different column. the data frame sample will look like below: RICS on left side & prices on right side. How can Eikon API have a…
-
Can i get for Eikon api python, to generate a code for m&a deals screenin?
i need help for Eikon api python, to generate a code for m&a deals screening: worldwide deals, announcement date between 01.01.2010-31.07.2024, status completed, The deal value >$1 million, Both acquirer as target are Listed on a stock exchange, The acquirer holds <50% of the target’s publicly traded shares before the…
-
FixSpec in API format
I am trying to understand how to interpret Trade and Market condition qualifiers in tick history data. I have looked at the documentation provided at https://refinitiv.fixspec.com/stack/specs/elektron and i understand the meaning of those values. I wanted to ask, is there an API available that that defines all the enum…
-
How to accurately get data between your customised periods specified
Hi everyone, One thing that I am confused with regarding get_data_async, is that, depending on the datapoints I try and retrieve, I can't seem to get data within the scope of years that I specify. Say I have this for example: current_year = datetime.today().year start_year = current_year - 8 async with semaphore: #…
-
CURVB/SWPR versus MID price
Hi all, I have been struggling to validate the figures of the SWPR (swap pricer tool) which colleagues of mine use on a regular basis. I have tried to check the CURVB which perfectly corresponds to the SWPR output (rates in Zero curve sheets). However when I try to extract the rates it seems I'm unable to retrieve the same…
-
JP Morgan Query - Please confirm on why ADD action(OMMMapEntry.Action.ADD) was being published.
Hi, Would you please assist on query from JP Morgan. A user query for 3436.T and 1678.T RIC's. User has received unexpected update status on the following MBP keys. 1. MBP Keys: 20300000A RIC:3436.T MBP record details: MBPRecord(action=2, price=2030.0, qty=4100, side=ASK, time=1725239958257, localTime=10:19:18.257,…
-
how to achieve USUM1P=ECI data
how to achieve USUM1P=ECI series data, with prelim publish data and prelim publish date. our economic data's logic is blur, user want to test market reaction when economic data publishes. But either cannot get the Latest data (for example, the latest data is of 13th September with no data), or cannot get the last publish…
-
Can I get quaterly ESG data for FTSE100 as a bulk?
Can I get quaterly ESG data for FTSE100 as a bulk?
-
What is actual master RIC to get all SPY and SPX options ?
Can you please tell me What is actual master RIC to get all SPY and SPX options ? . I want to download SPY and SPX options complete data of 5 years.
-
Number of Reuters News, over a period, for US listed stocks - Distribution by stock
I would like to know how many Reuters News in English language we received between July13-20, for US listed stocks only. And then I'd like to know the distribution of stocks the news are related to. This is with RDP News - Wealth package Equity & Markets News, for North America region.
-
Can't seem to find some data on Oil Product
Hello, I can't seem to find some data. I would like to find what quotations and transportation costs for export are used for oil products on the Batumi-Rotterdam ports route. I need Refinitiv publications on the transportation of oil products (Preferably for fuel oil and VGO) Thank you!
-
Dividend Yield of All ETFs
Is there a way to get dividend yield data for all US stocks and ETFs in bulk using a Python API?
-
how to achieve USUM1P=ECI data
As our economic data's logic is blur, I cannot find out via which Ric i could get USUM1P=ECI 's latest published data. the Ric CF_Last not work. And eikon.get_data('USUM1P=ECI', ['ECI_ACT_DT', 'ECON_ACT', 'TR.IndicatorLastObservationDate']) not work either
-
Commodity Options data (Option Price)
Hi, Using the API, is there a way to retrieve options data (mainly option prices) for commodities (e.g., 0#NG+, 0#CL+) from a past date? For example, I need the values of some Natural Gas and Crude options as of 12/29/2023. Is it possible to get option prices for those options on that specific day? Currently, I use the…
-
Cannot download file from filings endpoint
For some files I get the following error when trying to download certain file urls, e.g. for emea1-apps.platform.refinitiv.com/Apps/AdvFilings/FRS_GET?DocumentId=78170311&ContentFormat=pdf): Document request failed, Exception is Could not find file…
-
Start from LEI to get company information
New user of Code Book inside Eikon API. I want to start with LEI and find corpororate information like parent LEI and industry code. Input: ZYBR0GI2DCOB4RV8NO37 Output industry group: debt fund
-
ETF data for Issuer, AUM, NAV and other fields
I am currently trying to retrieve two types of data: Static Data and Historical Data. Below is a sample code that I've been working with, but I am having trouble identifying the correct fields to use. I would appreciate your help in correctly adjusting the Select or Fields sections. * For Static Data, I need the following…
-
Missing Data for multiple rics
Using the Refinitiv.Data nuget package for c# and Eikon login information i am missing data for a number of rics example below ENOYBLARHZ5 2024-06-26 to 2024-07-15 ENOYBLCPHZ5 2024-06-10 to 2024-07-15 My query returns data both before and after the intervals listed above…
-
How can I get ctbname and ctbid for research api
Hi. I'm trying to get research report by research api, but I don't know how I can get ctbname and ctbid of broker. example endpoint:https://api.refinitiv.com/data/research/v1/bulk-request Please confirm.
-
how to get balance sheet item value from financial-statements API in RDP
Given concept code, where can i find the item value of the concept code? please give an demo of a concept code.
-
Condtion used in bond report tempate in DSS
why below condition is used in Datascope API , "Condition": { "BondScheduleTypeCodes": [ "UOPH" what does UOPH stands for ? do we have list of such codes . and can several Option Codes be used simultaneously in a single request?
-
Obtaining Years alongside retrieval of Fundamental Data Asynchronously
Hi everyone, I have a question regarding the Date column not coming with get_data_async function calls. When I am making calls like so: roa_datapoints = await content.fundamental_and_reference.Definition(universe=[f'{ric}'],fields=["TR.F.IncBefDiscOpsExordItems","TR.F.TotCurrAssets","TR.CommonName"],parameters={"SDate":…
-
How to know the currency in which my data is collected ? (using Python Eikon Data API)
Dear network, I am currently collecting companies financial data for my master's thesis, using Python Eikon Data API. I want all my data in USD but some companies have different standardized currency (eg file attached). When I collect the data with Jupyter, I don't know the currency of the data, and then how to convert it…
-
Understanding how RIC extensions can change Knowledge Direct API responses
Hi there, I am trying to understand how different RIC extensions can provide different datapoints when using the "/api/Quotes/Quotes.svc/REST/Quotes_1/RetrieveItem_3" via the Knowledge Direct API. For instance if I'm querying for AAPL.O I will receive "YRHIGH" but not "52WK_HIGH". On the flip side when I query for AAPL.NB…
-
Obtain Closing Price of stock on set series of dates and return NULL if there is not data for that d
Hi All, How can I obtain the daily closing price for a stock for specified dates, returning NULL on any specific dates that do not have data? I'd like to obtain the daily price of several stocks over a set period of time. Ideally my output will look like this: Where a day that the latest closing price is not available…
-
Hello, which sanction lists do Refinitiv use to complete their checks?
Hello, which sanction lists do Refinitiv use to complete their checks?
-
How to extract DV01 from 10 year US Treasury Yield curve using Eikon API? The data is on a page of R
-
Null Value First Notice Day for Future Contract and TermsAndCondition Template
requestUrl = r"https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractWithNotes" # requestUrl = r"https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractRaw" requestHeaders = { "Prefer": "respond-async", "Content-Type": "application/json; odata=minimalmetadata", "Authorization": "token " +…
-
ASX Tick Size Tables via RDP or ?
Hi, I'm trying to determine how or where I can receive the Tick Size Tables for a stock on the ASX Market. There is a standard tick size/price steps table shown below. However the note in the screen shot below indicates other security types can different rules. The ASX documentaton…
-
How to identify Pit trades in TRTH Date Time response
Hi, we're using TRTH downloading tick level data. We requested many columns from TRTH as below. I am wondering is there a field or trade flag that helps us to identify whether a trade belongs to Pit trade or not? https://www.investopedia.com/terms/p/pit.asp The reason is for some futures products in 2000-2006, we see many…
-
ExtractWithNotes does not return RIC in case of CUSIP as an input but works well with ISIN
https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractWithNotes does not return any RIC in case of CUSIP as an identifier in Input but works well in case of ISIN as an identifier. Please find attached list of CUSIPs and RIC error as below: Failure: 2024-08-07 12:43:35.193 [http-nio-8080-exec-2] ERROR…
-
Curve chain ric of XAU XAG
I want to know if XAU= XAG= have the curve data from RTMS interface ? if yes .could you help share the chain ric of them ? for example : USD/CNH RIC: CNH= Chain Ric : CNHFWD= how about XAU/USD and XAG/USD ?
-
How to Efficiently Retrieve TR.PrimaryInstrument for Delisted Equities?
Hello everyone, I'm currently working on a project where I retrieve RICs and PrimaryRICs for a set of ordinary shares from various global markets using the Refinitiv Research API (EQUITY_QUOTES) through codebook. Then I use the PrimaryRICs to gather fundamental data for these companies. However, I've encountered a problem…
-
How to Exclude Weekend Dates for Historical Prices via RD API Calls
I am sourcing daily historical prices for a universe of RICs (bulk RICs API call) via RD API. In the response I am getting weekend dates and obviously blank prices. How can I exclude the weekend dates in the response and only get dates/prices for business days.
-
Understand the RIC structure of the futures MEDM24
For this futures quote RIC: MEDM24 which is the quotePermID: 21956505209 i don't understand what the fifth digit '2' has to do with it. as far as i understand the RIC components when it comes to futures is: {rootCode}{deliveryMonthCode}{expiryYearCode} That would mean that the expiryYearCode is '24' instead of '4' that i…
-
How to find expired bond options
Good morning, I am working on a project that requires me to get the RIC and historical price data for several assets. Some of those assets are options on interest rate futures, such as options on us 10yr notes futures for example. The issue I have is that some of these options that I need to get the RIC of are expired,…
-
Unmatched financial statements reference dates with date index and EPS Report Date?
I am analysing Apple financial statements and noticed that the displayed date does not match with the reference date, the stock's fiscal year ends in September. aapl = ds.get_data(tickers = 'US0378331005', fields = ['WC01001A', "WC05901", "WC05902", "WC05903", "WC05904", 'W05350A'], start = '2020-12-31', kind=1, freq =…
-
Retrieve RIC codes from ISIN and Exchange in instrument search
I am currently working on retrieving RICs for instruments using the Refinitiv API, given an ISIN and exchange. I am using the endpoint: https://selectapi.datascope.refinitiv.com/RestApi/v1/Search/InstrumentSearch. My goal is to obtain the specific RIC for a given exchange and ISIN from the search results. For example, I am…