-
orgId property in rdp search API
https://api.refinitiv.com/discovery/searchlight/v1/ { "View": "Organisations", "Select": "Orgid, BusinessEntity, CommonName,PrimaryRIC,PrimaryRICTickerSymbol,PrimaryRICExchangeCode,GicsName", "OrderBy": "CommonName asc", "Filter" : "PrimaryRICExchangeCode eq 'ASX' and IsPublic eq true", "UnentitledAccess": true, "Top": 10…
-
How to filter ownership data using the Eikon Formula Builder?
Hello, I am using the following formula to extract ownership data in Excel: =@RDP.Data(A2:A1000;"TR.InvestorFullName;TR.InvestorType;TR.InvInvmtOrientation;TR.PctOfSharesOutHeld;TR.OwnTrnverRating;TR.InvestorTotalAssets";"SDate=#1 CH=Fd RH=IN";E4;$D$1) However, as I am trying to analyze a large number of companies over…
-
Download a list of filtered bonds from advanced search into an excel sheet
Hi, My problem is this: I created a filter in Refinitiv Eikon's advanced search to filter corporate bonds with certain properties. Now I want to load this filtered data into an Excel sheet. The issue is that Refinitiv only supports downloads of up to 10,000 items at a time. However, my list of filtered bonds contains…
-
How to determine Fields for Instruments .Net Refinitiv Data API
Hello, I am trying to find a generic way to determine which fields to use for different instruments so that the data processed is consistent with that displayed in Workspace. Looking at Daily Charts: For example if I query some daily history for MSFT.O and VOD.L with the following: var response =…
-
refinitiv formula excel generate issue
I am trying to retrieve data for a list of ticker and date in excel, the formula for the single cell work well, example of formula =@RDP.Data(N1782,"TR.CGBoardSize","SDate=#1 EDate=#2 Period=FY1",,TESTO(Z1782-364,"YYYY-MM-DD"),$Z1782) When I copy and paste the formula in the other cells the formula is correctlycopied for…
-
Historical option data
Good morning, I have been extracting expired options data through the Refinitiv Data Platform API and a couple of questions have arisen: I am trying to extract data from the year 2000 to the present, but I am only getting data from 2015. Is this due to a limitation of the API? When extracting the data, the Greeks do not…
-
Is it possible to get link/url to news article.
I am just working with the refinitiv news data apis. I'm just wondering if its possible to get the url to the original article? I can't currently seems to find that outputted by any of the endpoints. Thanks
-
User has no permission rics except TRI.N
I am testing API, but i found i cannot access any of ASX stocks, also even APPLE, the only symbol i can get data is default one TRI.N, which is Reuters. Why is that, any permission problem? the permission scope is "scope": "trapi.auth.cloud-credentials trapi.cfs.claimcheck.read trapi.cfs.subscriber.read trapi.data.est.sum…
-
Return Time Series Result as a List instead of one FullyPandas DataFrame
When I query data for an American company (e.g. Google; `GOOG.O`) and a British (e.g. RaspberryPi; `RPI.L`) the data frame returned is a full merge of American and British trading days resulting in NAs in the respective time series if e.g. American markets have a non trading day as of `2024-06-19` (see example below). Is…
-
API Playground not working
I can't seem to access the api playground. Keep getting this "access_denied" error message. Does anyone know why this is? Or if there is another way to get the documentation for the Refinitiv apis? Also I have covered my email in the screenshot, but I am signed in. Thanks
