Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 2

SQL interface instead of Eikon excel

Dear All,

We would like to kindly ask you, whether we can access to market data (which the current Excel interface is linked) using SQL interface?

Our aim is to retrieve volumes and bids directly to a data table created in MS SQL to retrieve data against the current Excel.

The database connection generally consists of the following:

- database server name to connect

- username

- Password Thank you for your kind help in advance!

Best Regards, Benjamin

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apiapiexcelsql
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Hello @machosb,

Thank you for your participation in the forum.

Is the reply below satisfactory in resolving your query? If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

AHS

Upvotes
Accepted
17.2k 82 39 63

Hi @machosb,

There is no SQL-like API available to access Eikon data. Instead of Eikon Excel, you can utilize our Eikon Data API which provides access via Python. You can refer to this API within our Developer Portal.

thanks.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Since you're using MS SQL Server, you may prefer Eikon .NET API, which also provides the capability to retrieve market data from Eikon. However, please bear in mind that Eikon is an end user terminal product, which licenses you to utilize any data you retrieve from Eikon for single user's individual use only. If you intend to utilize data directly or indirectly in any type of multi-user or enterprise application, you need to subscribe to one of Thomson Reuters enterprise products, which includes the license to utilize the data the way you intend.

Upvotes
1 0 0 2

Thank your for your kind answer!

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.