-
I am using the Python API and I am trying to query a snapshot of data using a RIC code (it is a full
Is there a way I can pull a list of all the individual contract codes from a Chain RIC for commodity contract?
-
differences between refinitv data and quarterly report
Hello, I'm using the following function to download oil production data and other variables. I’ve noticed that sometimes Q4 information is missing, or it differs significantly from the quarterly reports. Could you please explain how I can fix or reconcile these differences? import refinitiv.data as dl…
-
Commodities Tradeflow via API
Hi Team. We have a client looking to pull Commodities Tradeflow data monthly as part of their automated process to store the data into a database using a python client. Could you let us know what API options are available?
-
Commodities forward pricing discovery tool in Python
Hi everyone, I have been trying to retrieve through python API the time series of the TTF NG forward curve (the fair value) as shown in the 'Commodities forward pricing discovery tool', has anybody managed to retrieve it successfully? Thanks in advance
-
How to get settle or open interest on expired Option on CME and Euronext ?
I tried : ld.get_history("BL219000L9^1") or ld.get_history("BL219000L4") I got LDError: No data to return, please check errors: ERROR: No successful response. (TS.Interday.UserRequestError.70005, The universe is not found) ld.get_data("C390X24",fields=['TRDPRC_1', 'SETTLE', 'BID', 'ASK','OPINT_1']) LDError: 'The record…
-
Client Request – 5-Minute Interval Data for RIC SBc2
Client wants to get the python code to get the data to retrieve 5-Minute Interval Data for RIC SBc2. Excel formula is =@RDP .HistoricalPricing("SBc2","TRDPRC_1","START:01-Jan-2020 END:31-Dec-2024 INTERVAL:PT5M SOURCE:RFV",,"TSREPEAT:NO CH:Fd RH:Timestamp") But client needs python code which provide 5 minutes interval data…
-
Parameters available from API
Hi there, Could you kindly share the parameters available for Commodities that are available via the API? Thanks much and best rgds, Lawrence
-
Pulling live data from LSEG Workspace in python
I want to figure out how to: log into my LSEG account in python code, make a connection to LSEG in python code, pull a Brent futures (LCOc1) live ticker into a dataframe and display it such that it continually updates
-
How do I access alternative close prices via python API
Help! Is it possible to access alternative close prices from the python API? For example BRTDTDMc1 has 2 close prices. ASIA_CLOSE, EU_CLOSE, US_CLOSE, I want to access the ASIA close price as I am trying to find a common timestamp for the below list of prices. Reuters Code' : ['DUBSGSWMc2', 'MRBN1MMASc1', 'OQc1',…
-
Please can you explain why there is a lag on receiving EIA stats data via a script i have written?
Hi team, I am posting on behalf of an external client for the query below, please help and prioritize: Please can you explain why there is a lag on receiving EIA stats data via a script i have written using the appkey? from lseg.data.content import historical_pricing as hp from datetime import date import os 1. Correct RIC…
-
Corn futures continuation on open interest code does not work
Hi team, I tried follow this continuation rics rule, I believe Corn futures continuation on open interest should be Coi? I could not find it … not sure if i misunderstand something. Many thanks for help,
-
Basis pricing for Physical commodities
I want to get FX broken dates calculator to hedge basis price contracts for commodities e.g. Cotton. Sample code as below: df = ld.get_history('JCI-CTN-ANHUI','TRDPRC_1',start='01-Jan-2025',end='26-Jun-2025') #This is spot price for China Anhui cotton. df2 =…
-
Pull Oil related data using Datastream API
I am interested in getting the following data points using python APIs (say get_data or get_history end points) 1) Crude Oil (WTI in USD) 2) Brent Crude Oil futures contract. Output: Daily data for last 1 month Can someone please help on the same
-
Could you please send me the python script to retrieve all point connect curves ids
Could you please send me the python script to retrieve all point connect curves ids with the following metadata filter: Commodity: Power Variable: Consumption Geography: Germany Status: Actual FYI: The python script sends a request to https://sprod1.rdms.refinitiv.com/api/v1. Please make sure I can copy paste the script,…
-
Not being able to get the desired response from the CommoditySearch request.
We are not being able to get the response from the following request as provided in the screenshot. Can you please assist in creating the correct request to get the correct list of the recs for the CommoditySearch request? As directed, we tried requesting the list of 'NGMM' RICs but the response is empty.
