-
How do i get Quarter or Financial year as the Column header for the data?
ld.get_data(universe= [ "TRV", "ORI", "WRB", "BRO", ], fields= ['TR.F.NETPREMEARNED'], parameters= {"Scale":6,'Curn':"USD", 'FRQ':'FQ', 'Period':'FQ0', "SDate":0,"EDate":-5}) , This is the output i'm getting, I want column net premium as header and under sub header quarter or year, is it possible
-
lseg.data.content type conversions
When using lseg.data.content how can I control the type conversions occuring for response fields ? For example : import lseg.data as ld universe = ["/SOGN.PA"] fields = ["BID", "ASK", "CURRENCY", "RDN_EXCHID", "QUOTE_DATE", "QUOTIM", "QUOTIM_MS", "QUOTIM_NS"] stream = ld.content.pricing.Definition(universe = universe,…
-
NaT Issues and Duplicated Dates
I hope you are doing well. I am reaching out regarding some data inconsistencies I haveencountered while retrieving fundamental and market data for specific RICs using theRefinitiv API. I would appreciate your assistance in understanding these issues and findingpossible solutions.Issue 1: NaT Values for…
-
Why does my code not return any values? It works for other fields, for example TR.Price.Close
import pandas as pd import numpy as np import plotly.graph_objects as go import lseg.data as ld from plotly.offline import plot import cufflinks as cf # Cufflinks import configparser as cp import time all_data = [] for i in range(0, len(RICS), batch_size): batch = RICS[i:i + batch_size] data = ld.get_history(…
-
Using fundamental_and_reference leads to warning when <NA> values are in the result
I tried to get some data using lseg-data 2.0.1 with "fundamental_and_reference". The result obviously contains some <NA> values. I got the message: "FutureWarning: Downcasting object dtype arrays on .fillna, .ffill, .bfill is deprecated and will change in a future version. Call result.infer_objects(copy=False) instead. To…
-
Refinitiv Workspace Transcripts Download using Python
Hello, Is it possible to use Python to download all companys' earnings conference call transcripts through Refinitiv Workspace at once? Although I found that some answers said no, I just want to double-check whether it is updated. Thank you very much!
-
QPS Financial Contracts API - Service Unavailable
Hello, I ran into the following error today: {'error': {'id': '3a4945f9-f869-4b70-9108-c4022368608a', 'code': 'QpsCommon.ERROR_BACKEND_ACCESS_FAILURE', 'status': 'Service Unavailable', 'message': '[QpsDps] I/O error on POST request for "https://qps-dps-use1.int.refinitiv.com/pricing/prepare": Read timed out'}} My code was…
-
Time slot discrepancy between Eikon and Workspace
Hello, Our teams have recently migrated from using Eikon to using Workspace. Because of this our IT Tools also need to be updated to work with Workspace. Previously, we were using the ThomsonReuters.DataAccess library for C#. We had to migrate to LSEG.Data and LSEG.Data.Content (using a DesktopSession). Our scripts now run…
-
Using refinitiv.data Library on a Remote Cluster
Hello LSEG Development Community, I am seeking assistance and clarification on using the refinitiv.data library in a headless server environment. My goal is to establish a session and retrieve historical data from the Refinitiv Data Platform using the refinitiv.data Python library. However, despite various troubleshooting…
-
Access Denied to pricing data
Hello, On sending any pricing request via the LDP API in a local Python environment (i.e. in VSCode which is outside of Codebook), I receive the following debug error message: [2025-02-15T17:05:49.740994+00:00] - [DEBUG] - [sessions.platform.ldp.0] - [132056015177280] | Msg-Proc-ThreadOMMSTREAMING_PRICING_0.0…