-
Workspace Python API: Error: no proxy address identified
We are currently migrating our users from Eikon to Workspace, and they are trying to run their Python scripts using the same scripts and api key that they used with the Eikon API (that as I understand should work fine for Workspace?). However they are getting the following error, which they don't get when the Eikon API is…
-
Total Return for an Index
Hi, I would think this would be an easy question, but I can't seem to get a total return for S&P 500 (or other example indices, for that matter), but the formula works fine for stocks. Can someone please advise? My call is below: ek.get_data(['.SP500'],['TR.TotalReturn'],{'SDate':'2017-01-01', 'EDate':'2018-01-01'})
-
get_symbology() from SEDOL to RIC returns "no best match available"
I am trying to convert SEDOL to RIC through get_symbology, but it returns "no best match available". Meanwhile, Same SEDOL is able to convert SEDOL to ISIN. However, I tested it with other SEDOL, it is able to convert SEDOL to RIC. Those unavailable assets are mainly ETFs, and I wonder is this the reason that cause the…
-
Can you please help in creating VBA code for the below:
What I need is VBA code to: Check whether Workspace COM add in is loaded, and load it if not Check Workspace status (online, offline, refreshing, paused) and trigger log in and refreshes Retrieve FX spot live, today’s high, today’s low as well as fixrates (WMRH etc) and the corresponding timestamps
-
meaning of the field VOL_X_PRC1
What is the meaning of the field VOL_X_PRC1. Does this imply VWAP? I see in the Eikon as well as the Workspace product, the field VWAP is not supported when requesting data. Can VOL_X_PRC1 be used for VWAP. Are there any other recommendations for the same.
-
lseg get_data() randomly missing data
Another problem: sometimes, for some requests the server returns empty values. If I rerun the query for the symbol with missing data, I get a correct response. This is an example of a relatively big query, so I will post only the logs: Request with 100 RICs: json = {'Entity': {'E': 'DataGrid_StandardAsync', 'W':…
-
Platform Session
I currently use Reuters Eikon and the desktop session to import price data via Python. As I switch to LESG Workspace, can I use the Platform session instead? Is this included a standard in my license?
-
how to migrate from EikonDataAPI_46 to LSEG Workspace ?
We have built Historical and Realtime code to extract prices from Refinitiv Eikon using EikonDataAPI_46. https://github.com/LSEG-API-Samples/Article.EikonDataAPI.DotNet.Library/tree/main/EikonDataAPI/EikonDataAPI_46 Can someone advise what is the best way to migrate this to LSEG Workspace?
-
We are getting a problem when we request data with the TR.FundYeartoYesterday Field in LSEG_DATA
Its is returning a datevalue. Here is the code to replicate error: """ import pandas as pd import numpy as np import lseg.data as ek ek.open_session() Fields= ['TR.FundYeartoYesterday'] Fundamentals= ek.get_data('LP68102841', Fields) ek.close_session() """ This is being replicated across all other instruments. Other fields…
-
I need to retrieve the financial period end dates from the income statement using Python.
My current code workspace_df = ld.get_history( universe=str(org_id), fields=['TR.Revenue', 'TR.F.Source', 'TR.F.PeriodEndDate'], start="2000-01-01", end="2050-01-01" ) However, this only returns annual period data. How can I modify the parameters to include quarterly period as well?"
-
Eikon Python Data API migration to lseg-data. get_history() partialy missing data
It seems like I found another bug in get_history(). This is the query for ticks for some time range. The problem is - the more RICs I provide as 'universe' parameter, the more missing ticks are in the response. 2 RICs in the query. All ticks are present. The first tick for ALSEA has Volume = 2675. 4 RICs in the query.…
-
get_history() ticks, filtering by EVENT_TYPE
Migrating from get_timeseries() to get_history() get_timeseries() - automatically filters out some ticks, but get_history() returns everything + EVENT_TYPE field. Is there a way to modify the query so it filters out the ticks with certain event types? For example below, get_timeseries() does NOT return the ticks with…
-
Eikon Python Data API migration to lseg-data. get_data() data mismatch
-
Issue with datetime64 Conversion in Eikon API – Assistance Required
Hello Eikon Developer Team, I am encountering an issue when using the ek.get_news_headlines() function in the Eikon API. Recently, when fetching news headlines in my project, the following traceback error has started to occur: Traceback (most recent call last): File "main_8.py", line [105], in <module> df_new =…
-
Filing API returns error message "User did not have entitlements to the field".
Hello, when I tried to get filing data with Python Filing API, I only get NAs and above error message. I was able to download full correct data using ADVFIL function on LSEG WORKSPACE desktop app. However, I need to acquire filing data for over 3,000 firms. I cannot download all of it manually. Here is my code:…
