-
Historical data on officers
How do I pull data on historical officers ina company i.e. I would like to know who was the CEO during 2015-2021 at Apple?
-
Specify time and currency when we get data using python
When we download financial data using python, how can we specify the frequency of time such as day, month or year? How can we specify the currency such as Japanese Yen and US dollars
-
Get last quarter data instead of annual data from ld.get_data?
I have 2 requirements: 1) Get last quarter data for a few metrics one of them is mentioned like Total Revenue 2) Get scaled version of the metrics like 'TR.F.DPSComGrossIssueByPrdEndDate(Scale=2), does adding Scale = x works everytime? I am hoping scale=2 divides by 10^2 or something. for solving 1) I have tried to use the…
-
Date information when using get_data (python)
When I download the financial data using `get_data` with SDate=2015/1/1 and EDate=2023/12/31 , for example, the output data does not include any time information. Therefore, I cannot tell which number corresponds to which date ( or month or year). How can we make the output data include the 'time' information as well?
-
How to add LEI to the query
Hi, I’m reaching out to ask for assistance with an LSEG API query. I’d like to add the LEI to this query: response = search.Definition(view = search.Views.GOV_CORP_INSTRUMENTS, filter = f"(DbType eq 'CORP' and RCSAssetCategory eq 'A:J' and ((ParentOAPermID eq '{org_id}') and IssueDate le 2024-12-31 and MaturityDate ge…
-
Missing ISIN/CUSIP/SEDOL from ld.get_data even though identifiers appear in Workspace (example: VSSL
Hi, I’m using the LSEG Data Library for Python to retrieve instrument identifiers (ISIN, CUSIP, SEDOL, etc.) from RICs as part of a global equity mapping pipeline. For most instruments, this works well. However, for a subset of equities the API does not return all identifiers, even though they are clearly visible in…
-
i need a python script to pull in 'latest data' (not historical) on an option chain
i need a python script to pull in 'latest data' (not historical) on an option chain i need for ric : BOSSn.DE all option chain . all expiries all strikes ; calls and puts i need latest data for these fields CF BID CF ASK LAST MID DELTA STRIKE PRICE EXPIRE DATE UNDERLYING RIC
-
Get_history request is not returning same fields - Unexpected error in data returned from data sourc
Hi The below request has worked very reliably over the past few weeks when I tried: df_prices = get_history( universe=ticker, fields=['TRDPRC_1','ACVOL_UNS','TRNOVR_UNS','VWAP', 'TR.TotalReturn', 'TR.CompanyMarketCap'], interval='1d', start=start_date, end=end_date, adjustments='CCH' ) But today I tried three times and…
-
Access and data availability
Good morning, It seems to me from sources online that the LSEG Data should include the Compustat Database from S&P Global. Link of an article where i found this piece of information. I was wondering how exactly we can access the data in the API, making sure we don't mess it up with other data points from other sources. On…
-
Query regarding pulling percent change data using API
I need to pull up 1M Price change data and percent change data for financial metrics like EPS and Dividend yield for a selected universe. How do we pull them up using the ld.get data end point. Universe: RELI.NS, ADEL.NS, BRTI.NS, How do we get this?
-
Constituents via Chain object only pulling current despite date pparameters
I recently ran into the issue of not being able to pull historical constituents using Chain objects as shown in the GitHub (ie: as of 12/31/2020). This worked for me previously, but as of today is exclusively pulling what appears to be the current consts no matter the date specific in the Chain attribute and parameters.…
-
TR.PriceClose field always returns adjusted stock prices？
When I tried using "TR.ClosePrice(Adjusted=1)" and "TR.ClosePrice(Adjusted=0)", the data returned appeared to be the same. If that's the case, is there an unadjusted close price available?
-
ohlc values for an asset minute wise
Hi , I need to know the ohlc values of one US asset ( e.g. CLF24 ) for 08th december 2023 at IST time 15:30 i.e. need the ohlc values for this specific minute...i have got lots of US assets for which i need these values ..how to do that
-
How to retrieve MICs for single RICs
Hello, I have a dataframe comprising all the RICs for a number of ISINs, and I would like to know how I can retrieve the MIC of each RIC using Python. Using the search API I was only able to retrieve the LSEG codes for exchanges and trading venues, not the official MICs. Thank you!
-
API service in LSEG Workspace for Document retrieval
Hi Team, May I know if we have a service that retrieves documents? Specifically for the retrieval of the following: For ETFs: 1. Annual Report 2. Interim Report 3. KIID 4. FactSheet 5. Prospectus For Bonds: 1. Prospectus 2. Final Terms 3. FactSheet For Stocks: 1. Fillings 2. Earnings 3. Annual Report
