Hi @valentin.garcia ,

Thank you for posting the question in this forum. However, this forum is dedicated to an API usage question hence, The moderators on this forum do not have deep expertise in every type of content available through Refinitiv products. Such expertise is available through the Helpdesk, which can be reached via MyAccount. If the Helpdesk can show you how to retrieve it using =@TR formula in Workspace/Eikon Excel, then the moderators on this forum can help you translate it into get_data method in the data library

Hope this helps and please let me know in case you have any further questions.

Hi @valentin.garcia ,

To retrieve hourly pricing data of each RIC (instrument), get_history function can be used. and Chain function can be used to retrieve the list of RICs in each chain

For example, RIC .GDAXI, which is Deutsche Boerse DAX Index.

Here I retrieve list of RICs in this chain and retrieve hourly pricing data and get a result as below

import refinitiv.data as rd
from refinitiv.data.discovery import Chain

rd.open_session()

# get list of RICs in the chain
rics = Chain(name="0#.GDAXI")

# get historical data
rd.get_history(rics, ['BID', 'ASK'], interval="1h",
               start = '2024-07-01', end = '2024-07-31')

Below are the resources related to the data library

API page: Refinitiv Data Library for Python with Overview, Quickstart guide, Documentation, and Tutorials

Article: The Data Library for Python - Quick Reference Guide (Access layer)

About the commodities data retrieving, as the moderators on this forum are expertise on Refinitiv APIs usage. However, they do not have deep expertise in every type of content available through Refinitiv products. Such expertise is available through the Helpdesk, which can be reached via MyAccount. To be of help, ticket number 13779451 was raised on your behalf and the support team is going to contact you soon to assist with this.

Hope this helps and please let me know in case you have any further questions.

@valentin.garcia

Thank you for reaching out to us.

You can use the Refintiv Data Library for Python with a desktop session or platform session.

To use a desktop session, the desktop application (Eikon or Workspace) must be running concurrently on the same machine and the application key is required to connect to the desktop application.

To use a platform session, you need to have Refinitiv Data Platform credentials (username, password, and application key). Please check the examples on GitHub.

To verify what the problem is, you can enable debug log in the library via the configurations or coding.

refinitiv-data.config.json

{
...
"logs": {
    "level": "debug",
    "transports": {
      "console": {
        "enabled": false
      },
      "file": {
        "enabled": true,
        "name": "refinitiv-data-lib.log"
      }
    }
  }, 
...
}

Coding

config = rd.get_config()
config.set_param("logs.transports.file.enabled", True)
config.set_param("logs.transports.file.name", "refinitiv-data-lib.log")
config.set_param("logs.level", "debug")
rd.open_session(....)

The refinitiv-data-lib.log file will be created.

Hello,

Thank you for your help, but I'm trying to download the 24 hourly SPOT prices for electricity. Access to futures data is as you indicated, but not for hourly SPOT prices in different countries