-
Commodity Options data (Option Price)
Hi, Using the API, is there a way to retrieve options data (mainly option prices) for commodities (e.g., 0#NG+, 0#CL+) from a past date? For example, I need the values of some Natural Gas and Crude options as of 12/29/2023. Is it possible to get option prices for those options on that specific day? Currently, I use the…
-
Is there a way to pull up TOP NEWS app -> COMMODITIES -> ENERGY into API in Eikon?
We wanna see trending topics, last news, market snap shop
-
Is there a way to obtain OSP/WLD quote data page in API in Eikon?
-
Power hourly prices for europe
Describe the technology What API are you using? refinitiv: I have a license What language are you using? python What environment are you in?Windows Describe what you've tried trying to download the hourly prices for power europe I don't know what i need to do, if i need to use refinitiv.data and get_data or get_history…
-
Hi, a Client of ours wants to use Numeric RIC = MSNc34 instead of Alphanumeric RIC = MSNJ24
One of our Client wants to use Numeric RIC = MSNc34 instead of Alphanumeric RIC = MSNJ24 for Futures LME TIN. I would like to see how it looks like on the refinitiv page.
-
rd.get_history does not return values for granular intervals
Hi there. The rd.get_history method does not appear to be returning prices for granular intervals. this code: testobj = rd.get_history(universe=CLF3^2, fields=['TR.SETTLEMENTPRICE'], interval="daily", start="2022-11-12", end="2022-11-25" ) print(testobj.shape) testobj (9, 1) CLF3^2Settlement PriceDate…
-
How to use formula builder beta in Excel to retrieve previous day's settlement price?
Hi! I'm trying to import the previous date's settlement price for different commodities futures (I believe the data item is STL), but I don't see that on the data items list. Is there a way I can pull the previous day's settlement price into Excel? I'm able to retrieve the current day's settlement, and I want to be able to…
-
How to get Refinitiv Contributor Curves using rd.get_data or rd.get_history?
Hi, Can we use the RD library to get the data, I need to generate a forward curve for these products (Look screenshot) as of 12/29/2023, which means I require data spanning 5-10 years. It should start from January 2024 to whatever the end date is for the curve. For example, how do I access this data for 12/29/2023? This…
-
How can I get German energy continuous intraday data using Eikon?
I want to get German continuous intraday spot prices using Eikon API. How can I do that?
-
RDP API - Commodities Content
Hi, I tried access RDP API using postman and these are the collections I can get there. Please help me to find the Commodities data in this. I want to use Java to pull data. hence trying this. And sample RIC and FIDs are - ACERDESLNGNWE , TRDPRC_1, HST_CLOSE, INST_DESC. Thanks, Sree
-
Error code -1 | The read operation timed out while using get_data
Hi, I am trying to get some commodities data using get_data, but I am encountering the error above with some RIC chains. Is it possible to fix this by increasing the timeout limit somehow? Error - For my second question - I am using "TR.SETTLEMENTPRICE.currency" to get the currency in the parameters. Is there a parameter…
-
How to download forward chain for a given date?
Hi, I am trying to access an entire forward chain for commodities on a given day. For example, I would like to obtain all forwards/futures data for Henry Hub on 09/29/2023 or all forwards for 12/29/2023 for ERCOT North. I have encountered the Commodity_Futures_RIC_Search.ipynb and have used a brute force method. However,…
-
why don't get commodities ricCode by IF2403?
this is my code to get commodities ricCode filter="TickerSymbol eq '" + code + "' and ContractMonthYear eq '" + date + "' and AssetStateName eq 'Active' and RCSAssetCategoryLeaf xeq 'Commodity Future' and ExpiryDateString ne null", I use below param to get code , it will return error messges. "code":"IF","date":"Mar 24"…
-
Why I can't get the whole RIC history when I make a multirequest, but I only get last 30 periods?
I am using this python code to get power and gas hist prices Basically I created 3 dictionaries with all the RICs for Power DE, Power Fr and TTF price for all the monthly and quarterly and cal products. I create a simple function that for each key of the dict, download the price series. Then I change the column names with…
-
Hi, does anyone know how i could retrieve Implied and historical volatility for Soybean futures chai
Hi, does anyone know how i could retrieve Implied and historical volatility for Soybean futures chain? Tks
-
Hi, when using the simple API function df = rd.get_history('SOY-NOLA-REF'), the only available field
Hi, when using the simple API function df = rd.get_history('SOY-NOLA-REF'), the only available field I receive is TRDPRC_1. Does this mean that I only can get this field among all other available fields? Thanks a lot
-
Receive status message for unknown subscription id 2
Trying to stream prices for LCOc1 and keep getting 'Receive status message for unknown subscription id 2'. Does anyone know why this would fail to establish connection to the platform? Should have ICE and CME live prices subscription enabled and this worked perfectly yesterday and for a week before. * Eikon Python API…
-
How to get Spread data of the product
Hi, So I was fetching the data of the different commodities for making a historical database using the code snipet now i have successfully fetched the contract chain of the products using that c1, c2..... nomenclature now i want to fetch the spread of those products kindly help the problem is for every product there are…
-
Screen for commodity instruments by source and other variables
I am looking for a way to screen for commodity instruments by source and other variables, similar to the attached screenshot. There is a sample screening query in the Data Retrieval and Discovery folder however I'm not sure how to modify the code for these parameters. I can see that these data items are available (i.e.…
-
Template open positions
Is there a template made by refinitiv to keep an eye on my open positions ? Even better if it is made for commodities (especially for spread trading) Thank you in advance
-
Get correct 'BIDPRICE' data of some commodities
commodities_20230413_log.txt We have collected 'ASK price' and 'BID price' data of 6 commodities, which are CU, PB, ZN, SN, AL, and NI. We have called the data by using APIs and stacked them daily. There was no problem in collecting the data until 20, March 2023. But from then, the ASK/BID PRICE of 6 commodities has been…
-
Commodities Screener in DataScope Select
Hello, Can you please share a sample code on how we can pull Commodities in the API, replicating how a Commodities Screener will do in the GUI?
-
Can we pass multiple RIC roots while searching for Futures and Commodity Search.
For searching RIC codes using KeywordQuery, @{ "SearchRequest": { "KeywordQuery": "PROCNWEM","ExpirationDate": { "@odata.type": "#DataScope.Select.Api.Search.DateValueComparison","ComparisonOperator": "LessThanEquals","Value": "2026-12-31T12:00:00.000" },"PreferredIdentifierType": "Ric","AssetStatus": "Active" } } this…
-
Symbology conversion for vessel IMOs
Hi, I have a list of vessels for which I have the IMO numbers (more than 20,000 vessels) and I would like to get the RICs for these vessels. There seems to be no data item for Vessel RIC and hence Eikon Get Data functionality wont be helpful. RDP search for Vessel Physical assets can be one option but I am not sure how to…
-
Datastream futures contract retrieval
How can we find all the contracts that are used to construct the continuous series? Is there a way to automatically generate the tickers for the contracts that are yet to expire? The question is platform and coding language agnostic.
-
Pull futures chain (expired and current) & get all historical prices
Hi, I would like to pull a futures chain, including expired contracts (say 0#C) and current contracts. And get the prices. Is there a simple way to do this that pulls them in a single dataframe once you have the list of contracts?
-
use function to retrieve "settlement price", "open interest" and "open interest change" data in ter
Hi there, as pasted below, the Eikon_API hand book implies the available "OPEN, CLOSE, HIGH, VOLUME" etc arguments for "fields" parameter in <get_timeseries> function. my question is am I able to retrieve the historical "settlement price, open interest, open interest change" data which are not listed for a commodity…
-
EkionDataApi Gold And Silver Time Stamp Issue
I sent this question yesterday to customersupport@refinitiv.com and they directed me to ask this question here. I state this so that the dates returned at the bottom make sense (they were pulled yesterday). I'm trying to understand why the latest timestamps being returned differ between GCc1 and SIc1. For GCc1 I get a…
-
RDP and EK retriving divergent settlement results for same parameters
Hello, I'm trying to gather data from "SN2" RIC using the API with Python, however, I get different results for the same RIC, same period and same fields. For example, when I use: import refinitiv.dataplatform as rdp df1 = rdp.get_historical_price_summaries( universe = 'SN2', interval = rdp.Intervals.DAILY, start =…
-
Annual Total Traded Volume of Commodity
I need the total traded volume (annually) for Natural Gas commodity at NYMEX. For that purpose, if I write this code in Python API, I need to clarify what volumes does this code provides?Even if it provides the monthly total volume, it is still for just these future contracts and how to retrieve for all contracts in a…
-
Historical Spot Prices data for corn and Soybean
I have to extract the historical spot prices for Corn and Soybean commodities. I write the code in Python API and the results are N/A values for Corn while "No data available for requested range" for Soybeans. Is there anything that I am making any mistake or any leads how could I extract this data? Screenshots are…
-
Pulling weather data through the Eikon API using python
Hi, Is there a way to pull weather forecast data through the Eikon API using python? I have attached a screen shot of the data we need to pull. Thanks!
-
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',…
-
get list of RICs in chain 0#GRAINS/CASH
Hi, I would like to get a list of all the RICs in the 0#GRAINS/CASH chain. I tried: df, err = ek.get_data('0#GRAINS/CASH', 'TR.CommonName') or df, err = ek.get_data('0#.GRAINS/CASH', 'TR.CommonName') but I got the error: 'Unable to resolve all requested identifiers.' I noticed this is a chain containing chains so I also…
-
Historical futures prices
Good afternoon, I need to download the historical futures prices on brent oil for the period jan-march of 2020 with expiration in april 2020 . How i can do it ?
-
Hi, Is there a way to pull commodities tradeflow data using codebook?
Hi, Is there a way to pull commodities tradeflow data using codebook?
-
Please provide example code for getting TTF (dutch natural gas) front month prices.
Hi, I'm not able to find any information on TTF as the search functionality keeps crashing. Does anyone have example code for accessing this type of data?
-
Pull All Expired Contracts
Is there a way to pull all expired contracts for a commodity? The same process is fairly straightforward for active contracts, but I haven't been able to find a simple method for expired contracts. If none exist, is there a means of pulling expiry dates for all active contracts?
-
Find EFP (exchange for physicals) and EFS volumes of a list of future contracts
Hello, When i go to my reuters screen on a certain future contract (example : SBK1) I can draw a graph and decide to display the "fields" EFS & EFP to show the volume of those specific types of transactions. I would like to be able to load this information via Python: ex: df,e = ek.get_data(["SBK1"],["EFP_DATE','EFP…
-
Python code to retrieve historical point in time daily futures curve (replicate Eikon for Excel belo
Python code to create this dataframe starting with row 10 (skip row 11)