-
Difficult to access the quartely financial data
I am currently in need of quartely financial data from from JSE from 2011 to 2024 however I am facing challenges to download the data, kindly help given the time constrain that I do face right now thank you
-
Cotton Continuation contracts pulling CRT_MNTH and EXPIR_DATE
Hi, I have code below My issue is that some data such as CRT_MNTH and EXPIR_DATE is failing to come in prior to about 2022 for all Continous contracts before 2022, what do I need to change in the code? Could please provide the fix?
-
Datastream Excel: Trading Date in DSGRID
Hi, Can you please let me know how to change the date to trading date in Excel? I have searched everywhere now and would really appreciate the direct help. The formula below gives me 262 days.…
-
Datastream Excel: Trading Date in DSGRID
Hi, Can you please let me know how to change the date to trading date in Excel? I have searched everywhere now and would really appreciate the direct help. The formula below gives me 262 days.…
-
Usage data was lost due to: Cannot open the DACS lock file - /usr/agent/dacs.usagelock
Hi, here are the logs from our one of our snkd processes: Mar 14 17:10:54:Usage data was lost due to: Cannot open the DACS lock file - /usr/agent/dacs.usagelock Which have another snkd which is running fine. The interesting thing is that we have set the path for this dacs.usage file on our TREP configuration file rmds.cnf…
-
Provide Shipping Flows Python Script
Looking for someone to help put together a script to pull shipping data for clean products (gasoline, gasoline component, naphtha, Gasoline / Gasoline Component) as imports/exports out of all US PADDS.
-
Calculation of FX Forward start date and Maturity date
Hello friend, I'm using Workspace Codebook to calculate FX forward start date and maturity date. I remembered that we have adfin function is something like FxCalcPeriod() to get the Maturity Date of FX forward if I provide the currency pairs, Start Date, and Tenor as input. Do we have a similar script for Codebook? Thanks…
-
Date is not shown in TimeStamp in EMA log message.
Hi, I am trying to configure a Logger programmatically in the Enterprise Message API. But when I am trying to include date in EMA log message it is still only showing Time not date. Example of Log: loggerMsg TimeStamp: 06:50:59.970 ClientName: ChannelCallbackClient Severity: Warning Text: Received ChannelDownReconnecting…
-
How to run a SCREENER formula in Excel to CODEBOOK?
What is wrong with this screening code? df, err = ek.get_data('SCREEN(U(IN(Equity(active,public))/UNV:Public/), IN(TR.InstrumentTypeCode,"ADR","BDR"), IN(TR.ExchangeMarketIdCode,"BVMF","XBSP")',['…
-
Is it possible to get a positive case from Refinitive if we don't resolve the case from our side?
Hello! We use Refinitive to screen clients, and from our CRM system, back office officers might open screening results by client and resolve case hits (mark them positive or not relevant). Now, we need to implement a new client risk level calculation process. If the client has positive cases (full match) after the…
-
Setting collateral currency for swap pricing in Refinitiv Data Library for Python
Hi, I'm using swap from lseg.data.content.ipa.financial_contracts within the Refinitiv Data Library for Python. I would like to set a collateral currency like I can do in the SWPR app (see the screenshot). Is this possible? I can't find an arg for this in the documentation. Thanks
-
Field for Reference contract month for Continuous Contracts
Hi I have a script to pull data for the Continuous Cotton Futures Contract. What is the field to pull the correct futures contract reference For example Today is the 14/03/2025 there would be a closing price and the reference would be the March Contract…
-
how do i get the screening data in the CODEBK?
=@TR("SCREEN(U(IN(Equity(active,public))/UNV:Public/), IN(TR.InstrumentTypeCode,""ADR"",""BDR""), IN(TR.ExchangeMarketIdCode,""BVMF"",""XBSP""), CURN=USD)";"TR.CommonName;TR.InstrumentType;TR.ExchangeName;TR.PrimaryRICCode;TR.HeadquartersC"&"ountry";"curn=USD RH=In CH=Fd")
-
Date Field contains indexed numbers
Hi, I am using the following script to download tresury yields. TESOROS = ['US2YT=RR','US3YT=RR','US5YT=RR','US7YT=RR','US10YT=RR','US30YT=RR'] start_date = "2000-12-12" end_date = "2024-12-31" ts_tesoros,e1 = ek.get_data(TESOROS, ["TR.MIDYIELD.date","TR.MIDYIELD"], {'SDate':start_date,'EDate':end_date,'Frq':'D'}) UST10Y =…
-
How do we get the latest file from CFS API for Package ID: 4d7e-7f24-e8549883-a58e-b7535ef16ee7
In the attached response, we don’t have any files with dates after January 2025 for normal Yield curve data: Bucket Name: bulk-custom Package ID: 4d7e-7f24-e8549883-a58e-b7535ef16ee7 File naming convention: PiperGMCurvesYYYY-MM-DDT16:00:00.000-05:00 Additionally, for Interpolated yield curve data, there are no files after…
-
Getting latest data for continuous futures contracts
Using the lseg.data library, I would like to download the latest traded price TRDPRC_1 and settle price if available. I have access to historical data using ld.get_history() but mostly empty data sets using ld.get_data(). Can you confirm python script that should work for Cc1 and Sc1 and/or a way to see if our subscription…
-
Retreive TR.CompanyMarketCap in EUR regardless of the instrument's local currency
Using Python, I would like to retrieve the field ' ' in EUR, regardless the local currency of the instrument
-
How do I save down a dataframe from the LSEG Codebook environment to my local drive?
-
Need service name to get the latest funds price data
i am sending the below request but i am getting the error like Unknown service Request : { "ID": 2, "Key": { "Name": "LP68036411" },"VIEW":[ "BID", "NAV"] } Error: RECEIVED: [ { "ID": 2, "Type": "Status", "Key": { "Service": 0, "Name": "LP68036411" }, "State": { "Stream": "Closed", "Data": "Suspect", "Code":…
-
document RFA 8.0.1.E1required
Where can I find document and example code for RFA 8.0.1.E1? I am not able to find in site navigation.