-
QPS Financial Contracts API - Structured Products error message: Invalid Correlation Data.
Hello team, I keep getting the following error message while pricing structured products using QPS financial contracts API: 'Cannot price Structured Products. Invalid correlation data.' It seems that when there are more than one Equity underliers the error would be triggered. I have priced similar products with single…
-
How retrieval all rics from an exchange (exceeding 10,000 rows)
I want to retrieval all rics from NYSE for example, but following code return the top+skip can never exceed 10,000. Is there any way to retrieval all rics? If any other modules work is ok as well, doesn't have to be search.definition. This is not a lot of data, can't image why set this limit.
-
How to filter only normal stocks?
Hi. I am trying to search all stocks rics from an exchange, but the return many are not stocks such as in screenshot iShares Trust - iShares Core S&P 500 ETF. And many lot of rics for the same stock for CBA there are 7 rics, but only CBA.AX is the normal one, how can I filter out those during retrieve? I don't want to drop…
-
Decode Login Response to understand if it is successful or not
Hello, I am unable to find examples where the login response has been decoded to check if login was successful or not. Can you help me with sample code or examples for the EMA Java SDK for the above use case?
-
What RICS to use when using get_history to get data for expired spreads ie LGOX4-Z4
I am using the following call for refintiv data platform via python : rd.get_history('LGOX4-Z4', ['OPEN_PRC', 'HIGH_1', 'LOW_1', 'SETTLE'], 'weekly') The above returns a "universe not found error". When changed to a non expired spread (i.e LGOF5-G5) it works fine. I already attempted using '0#LGOX4-Z4' and 'DLGOX4-Z4' per…
-
How to retrieve news headlines with NewId or StoryID?
Hello, We have access only to the below URI: /data/news/v1/headlines With this URI, is it possible to retrieve news headlines by providing the NewsId or the storyID as input parameter?
-
Query the refinitiv.data API in databricks
Hi everyone, I'm currently building an application using databricks, and in this process I'm migrating some scripts that were previously running on my local PC to run in a databricks notebook. I'm using refinitiv-data-1.6.2 to query the data. This is my auth flow : rd.open_session(config_name='credentials.json') with…
-
How do we calculate Maturity year in MMD feeds?
1. In mmdyields.jsonl file for MMD feeds, How do we calculate Maturity year for YieldCurveName : AAA PRERE TE? 2. Do we have all the YieldCurveName values mandatory in every feed or there is a chance of missing few?
-
How to get all bonds issued by companies in an index, e.g. 0#.GDAXHI using python?
How to get all bonds issued by companies in an index, e.g. 0#.GDAXHI using python? Is there a way we can list down all constituent RICs under 0#.GDAXHI, then use the result in rd.discovery.search > rd.discovery.Views.GOV_CORP_INSTRUMENTS to retrieve all the bonds issued?
-
Refinitiv Data Library for Python: Error code 429
Hello, I'm using the Refinitiv data library for python. In particular, I'm using the following function and have been getting some errors for too many requests. Using rd.get_history(), we were pulling data for a total of 6,458 RICs, separating the requests out into loops of 100 RICs and 3 fields. We've only submitted…
-
Authentication problem{"error":"429" ,"error_description":"Request rate too high." }
Hi, I am using the Refinitiv Data Library for .NET, and everything has been working perfectly until now. For a few days now I have a problem that looks like this: I also tried sending a request (by Postman) https://api.refinitiv.com/auth/oauth2/v1/token, but the response is the same: { "error": "429", "error_description":…
-
Issue when requesting timeseries for tweb intruments
I get a list of rics from chain_ric = '0#TWCORPERPS=', then I use this line of code : rd.get_history(universe=tweb_rics[:100],, fields=['MID_PRICE', 'MID_YLD_1'], start='2024-10-16', end='2024-10-17') I only request the first 100 and I get an error message : "Error code -1 | 'headers". Notice I dont get it when requesting…
-
Why the result are different between the excel function @TR and the EndPoint symbology/v1/lookup
Capture.JPGWhy does the Excel function "=@TR("NL0000000107";"TR.RIC";"Null=Blank")" returns the RIC =.AEX AND The EndPoint API Playground returns nothing when I run this URL? https://api.refinitiv.com/discovery/symbology/v1/lookup with body content: { "from": [ { "identifyTypes": [ “ISIN” ], "values": [ “NL0000000107” ] }…
-
How to query the news sources
Hello, Is there an endpoint to get a list of news sources? I would like to have an overview for querying news and filtering by source among those that I choose to select. For illustration here's a Python snippet: from typing import List, Iterable import refinitiv.data as rd import pandas as pd def get_news_sources() ->…
-
How to make a list from the column headers?
Hi I am working on a project and would like to know if it's possible to extract the column headers, excluding the first cell, from rd.get_history result and put it inside a list. May I ask for guidance on how to do it? As a sample, I am using this code import refinitiv.data as rd rd.open_session() import pandas as pd df =…
