-
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?
-
Is there a way to batch download filings for a particular SDC Deal Number?
I would like to download the filings for a particular SDC File Number but I have to manually download one by one. Is there a faster way to do this such as batch download functionality?
-
Download a desription of all ESG variables
Hello, How to download the a list with the name and description of all ESG variables that LSEG offers? For instance: DIR Score and its description what it means, etc.
-
using Python to download all securities that have exposures to a country, a sector, or a company to
I wanted to download from Refinitiv Eikon all securities (including equities, bonds, etc.) that have exposure to a given country, using Python. But I have no experience using Python to download anything from Eikon at all. Wondering if anyone can help me on this. I also wanted to download all securities that have exposure…
-
ESG Data in Bulk.
I am trying to access ESG data in bulk. The purpose is to gather ESG scores point-in-time and compare the different cohorts of the ESG scores databases (backfilled vs non-backfilled). To do so, I am following this tutorial.…
-
How to bulk download shareholder reports for a list of companies from Eikon/Workspace using CodeBook
Hello, I am a complete beginner at coding in Refinitiv - I previously used the Eikon screener for smaller projects where we would download shareholder reports and fund ownership summaries by hand. I have recently moved onto a much larger project where it would be impossible to download this manually. I would be hugely…
-
Fetching Data For Multiple Tickers At The Same Time (Limits?)
Hello, given the following code: # Initializations df_daily = pd.DataFrame() # Set Start and End Dates with the following format "yyyy-mm-dd" StartDate = "1969-12-31" #Set start date EndDate = "2023-04-11" #Set end date Tickers =…
-
Content layer - ESG Bulk - FileNotFoundError: no init file found in folder
Hi, I am trying to collect ESG via RD and the Bulk method as shown on GitHub, but Getting the following error that seem to come from the RD library... Am I doing something wrong? # !pip install refinitiv-data import refinitiv.data as rd # pip install httpx==0.21.3…
-
Downloading multiple tearsheets at once
Hello I would like to download multiple Shareholder Activism Tearsheets at once. When I open the Corporate Governance Market Overview in Eikon, I can see a list of Shareholder Activism Campaigns with some high-level information (e.g. activist, target, status). However, I'm interested in more detailed data that I can access…
-
Issue in downloading txt files in batch
I can't download txt files batch from 01/01/2002 to 01/01/2023, even after downloading Batch/Print App. Message will appear as "To Print/Save documents from the search grid, Batch Print/Save App must be installed. Installation is a onetime requirement for the use of this functionality from the search results grid.…
-
Exception from get bundle data in datastream
Hi, Im using the Datastream get_bundle_data to returns several items for a universe of stocks. We have set up a loop to cycle our universe. It works fine,but then randomly we get an error and it says it has did connected. Can you please advise me on the following. I should not we are within the max requests and on retry it…
-
"ESG Disclosure" download: S&P 500
Hello. Thank You for creating this amazing community and I hope to learn and contribute. I am working on a project where I need the following for S&P 500. * ESG disclosures (.pdf) * ESG data I have been able to easily get all my relevant data for ESG requesting Eikon Data API via Jupyter. ##CODE here for future reference #…
-
ImportError: cannot import name 'bulk' from 'refinitiv.data.delivery' on CodeBook
I'm using Codebooks Refinitiv Workspace and following the 'EX_01_05_05__Bulk_ESG' example. This is the error I recieve and haven't been able to find any solutions online. Would really appreicate any help!
-
客户案例分享:客户突然不能下载ESG的文件
客户的应用从我们的CFS系统获取ESG数据,之前一直工作的很好,但是,从5月9日之后不能下载,总是返回如下错误: ErrorCode=HttpFileFailedToRead,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to read data from http server. Check the error from http server:The remote server returned an error: (400) Bad…
-
download multiple bulk ESG files with python refinitiv.dataplatform
I can only retrieve download links from python refinitiv.dataplatform package, just like those in web based api playground, with following code, where fileid is a single file id endpoint_url = 'file-store/v1/files/'+fileid+'/stream' endpoint = rdp.Endpoint(session, endpoint_url) result =…
-
Investor's portfolio data retrieval
I would like to analyze portfolios of institutional investors based in a given location (e.g. country) using the built-in formula in excel or by downloading the data from the web. For a list of investors (could exceed 1000 Perm Ids) -> for each investor find all/major equity holdings by firm ID (RIC, ISIN, and or any other…
-
how to download file from ESG Bulk in java
Do you have a sample code download a file ESG Bulk by java?
-
In order to do an event-study I need ESG controversy related news articles, for a large number of co
In order to do an event-study I need ESG controversy related news articles, for a large number of companies over multiple years. What is the best way of extracting this information?
-
Error downloading bonds because the list is too large for some countries
I am downloading bonds by country, the list of bonds from the US, CN and KR are too long for downloading, so I received different errors (Gateway Time-out, ) every time I try these countries. I was wondering which code kind I use to download these bonds by part if it is not possible to do it in bulk. This is the code I am…
-
Downloading data in a bulk, some Calendar Years (CY) are not recognized in some years for some varia
I am downloading data in a bulk for all public firms in 47 countries, I used the add-in first to download some data but when I realized that this method was inefficient, I moved to Phyton. I used exactly the same code to download the data in the add-in and in Phyton, but for some reason, when I downloaded through Phyton…
-
ESG BULK just request the permissioned files or just return the permissioned files
Hi Team, One of my customer purchased ESG BULK files with "BULK ESG FULL CONT FULL LIST" permission. When customer sent request with "https://api.refinitiv.com/file-store/v1/file-sets?bucket=ESG", it will return all of the file lists but no permission for some/most of them. Is it possible just send request the permissioned…
-
Long Running Requests Return no Progress Update - DSS C# SDK
I have a question around the extractwithnotes async call. When running short requests I have no issue seeing the progress of the job on the callback method however when there is a larger request there is no progress or status update (as far as I can tell). The application awaits the aysnc result but it never actually…
-
Issue while flattening the JSON file to CSV in RDP ESG Bulk
Hello there, I did ESG Bulk extraction. However, when I am trying to flatten the JSON to CSV, few columns still has the json tags. It doesn't seem to flatten the JSON file completely. Appreciate you support to investigate and help on this. For instance, I tried converting the RFT-ESG-Scores-Full-Init-2021-04-25.jsonl.gz…
-
Download ESG Bulk data from CFS
I click on the Storage Location URL and get access denied.
-
Duplicate permid in person bulk file for 20201004
Permid 34424783048 (https://permid.org/1-34424783048) shows up twice in the latest bulk file, the only difference being a space in their name. ❯ gzip -cd OpenPermID-bulk-person-20201004_052056.ttl.gz | grep 34424783048 ... <https://permid.org/1-34424783048> tr-common:hasPermId "34424783048"^^xsd:string ;…
-
Live permids that recently disappeared
The following permids recently disappeared from the bulk files (they are not in OpenPermID-bulk-quote-20200927_044508.ntriples.gz), though they used to be there. They are still alive and kicking according to other Refinitiv products, so I don't think they should have been deleted. 21475112502 | 8269.HK 21512264217 |…
-
.ttl files missing prefixes?
The most recent versions of the three .ttl files I've checked (instruments, organizations, and persons) are all missing the turtle prefix headers. I know I can fix this manually, but would love to not have to worry about this edge case. Examples: "…
-
Can't find permid by RIC in Record Matching API and Entity Search API
Sometimes both Record Matching API and Entity Search API return no matches when searching by RIC (or by ticker + MIC), while the PermID with the corresponding data exists on on the website. For example: https://permid.org/1-4295884627 However, API request returns 0 matches:…
-
Quote RIC update visible on permid website, but not in bulk file or atom feed
On the web-site permid 1-21513114826 has RIC "BORD.OL", which is correct (the RIC recently changed from "BRGD.OL"). However in the latest bulk quotes file OpenPermID-bulk-quote-20200705_132936.ntriples.gz the RIC has the old value: <https://permid.org/1-21513114826> <http://permid.org/ontology/financial/hasRic>…
-
PermID atom feed now has at most 500 entries. not enough to cover time since last bulk file
Before June 21, by the end of the week the "organization" atom feed would have around 10,000 atom entries, providing all new values since the last bulk file. Since then, none of the atom feeds provides more than 500 entries. For example, right now the organization atom feed provides exactly 500 values with "updated"…
-
Bulk Organisation PermId File is Half the Size
Hi Team, The bulk organization from the 10th May appears to contain only half the companies. Can you please confirm? Regards, David
-
Bulk file download just half the size
I just noticed that the current Open PermID bulk download is much smaller than in March for instance. It seems that it does contain only half of the data objects than before. Is there an explanation for this or release notes that describes the changes?
-
Would Eikon API allow to download a universe of 80,000 companies with all historical ratings all at
Query raised by an internal client on behalf of external client A client has questions about our EIKON API, https://developers.refinitiv.com/eikon-apis/eikon-data-api/quick-start. Would it allow to download our complete universe of 80,000 companies with all their historical ratings in one script? If not what other…
-
Wrong currency EUR for RIC FLTRF.L
The latest bulk quotes file says the currency for 1-55836052673 (FLTRF.L) is 1-500111. However this is wrong, it is traded in GBp (pennies). I confirmed this using other Thomson-Reuters products, as well as other data vendors and the exchange itself. I have a theory as to how it got this way: the currency used to be EUR…
-
Sao Paulo RICs which should have no mic but do
In Sao Paulo (exchange code: SAO), RICs starting with "1" are for after-market trading, while RICs ending in S and T are for the forward and odd-lot markets. Of the more than 4000 Sao Paolo RICs of these special kinds, all but 12 have no value for the "mic" field. The 12 which have a value for the mic field are:…
-
Missing RICS in latest bulk quote file
All of the following RICs are alive and trading according to "datascope select" but they and their permids are missing from the latest bulk quote files. The asset classes are not exotic: most are "ordinary shares", some are "fully paid shares" and there is one "unit". They all used to be present in some bulk quotes file in…
-
Tokyo stock RICs missing in bulk quotes file
Hi, I noticed that in recent bulk quotes files the following Tokyo RICs aren't present: 2374.T, 3415.T, 7419.T. I checked with the exchange and all three are trading. I found them in some bulk quote files from July, but not since. Here're the permids they used to have: 2374.T -> 1-55834880351; 3415.T -> 1-21568704122;…
-
Duplicate RIC NEOE3.SA
I noticed that permid's 1-21701423526 and 1-55838823567 have the same RIC, NEOE3.SA, which is surely wrong. Another oddity is that, looking back at earlier bulk quote files, the exchange code for 1-55838823567 has been oscillating between SMA and SAO, so I suspect the problem comes from 1-55838823567.
-
Quote permids missing in recent bulk quotes file
Hi, I noticed that the following permids are no longer present in OpenPermID-bulk-quote-20190707_070945.ntriples.gz. I checked with the exchanges and it looks like the listings still exist. Was removing them a mistake? 1-21474914092 1-21475830023 1-21475886061 1-21513569941 1-21513584719 1-21531587191 1-21541108692…
-
Permids missing in latest bulk quotes file
I noticed that the following permids were present in OpenPermID-bulk-quote-20190616_054318.ntriples.gz but are missing in OpenPermID-bulk-quote-20190623_071002.ntriples.gz. I thought that maybe you'd removed them because they'd expired, so I checked the exchange web-sites but none of them had expired. Any idea why they…