-
How to download daily congestion data by anchorage zone in excel or API?
How to download daily congestion data by anchorage zone by API? Please see the Daily Congestion section. We can download it via excel but is there a way to code that file into API? Or is there a API that lets you show the congestion data that is arranged by anchorage zone?
-
Download historical futures prices for Nordic power (ENO) and Germany (TRD) via API
I want to download historical futures prices for Nordic power (ENO) and Germany (TRD), and later other markets. I want historical ticker prices to calculate hold-to-delivery returns and keep track of when the products go to delivery. I want to download the data via my python API using the get_timeseries() function. In the…
-
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…
-
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…
-
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?
-
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"…