API requirement for automation of data

Tasos Ioannou

Good morning,

We have developed a Microsoft Excel file with numerous Refinitiv Eikon RICS for Electricity and Natural Gas prices for various European countries. This file is in turn the source file for a Power BI dashboard. Due to the volatility of the Energy sector, especially after the war in Ukraine started, we are in need for a daily refresh of this file.

We are exploring for options that could automate this for us. Is there a way that we could somehow automate the download of the data on a daily basis, without having to manually do an update every day of the excel file?

Is there an API that could do this for us?? Then I could request from our IT department to support us in setting up the whole thing. If there is, hopefully, a solution to this, maybe you could connect me with one of your specialists on this topic so he can explain to me the whole process and then I can create a working team that could implement the solution.

I am looking forward to your answer and I would like to thank you in advance for your effort and consideration. I wish you a great day ahead and a great weekend.

Best Regards

Dr. A. Ioannou

zoya faberov

Good morning @Tasos Ioannou ,

As you are using Eikon Excel functionality, one way to approach the automation would be using Eikon Data API Python. Find information on Eikon Data API Python, including Quickstart guide- the best resource to get your team started working with API. For an example of translating an Eikon Excel sheet, you may wish to review the article Eikon Excel Company Tearsheet in Python.

There are other possibilities for automation. One thing to keep in mind is that Eikon Data API, similar to Eikon Excel is a desktop, is a single user API, and requires Eikon/Refinitiv Workspace to run on the same machine. Refinitiv data libraries are perhaps an alternative approach. They can be used with Desktop session that interacts via Eikon/Refinitiv Workspace desktop and makes available the same content as Eikon Data API, there is also platform session that enables connectivity to Refinitiv Data Platform, including realtime streaming. Specific content sets will require specific products. To learn more of Refinitiv Data libraries, that are comprised of Python. .NET and TypeScript flavors, see Refinitiv Data Libraries. If the product you integrate with will be Refinitiv Data Platform, rather then Eikon desktop, this will open the integration beyond running on the same desktop as your desktop instance.

This question is asked in Datascope forum section, I do not think DSS API is the right choice for this automation requirement, as it requires Datascope or Tick History product and enables access to reference data and price history information via DSS REST API. Going to move your question to Eikon Data API forum for improved visibility with Eikon Data APIs developers.