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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
Sudharsan.Parthasarathy avatar image
5 ●1 ●1 ●2

Query specific category of vessels using get_data

1) I would like to extract details for a set of vessels based on some criteria, saw dwt, year of build, sub type etc. The fields that I need can be defined as a list to be passed as params to get_data. However for instruments I am constrained since I need to predefine the list and cannot query it. Is there any way it can be done? Would be useful for instruments where RICs may not be known but values for some of the fields might be known.

2) Would it be possible to categorize vessels by certain attributes like an index in equities. This should help query all constituents of the index. For eg if a list of all oil tankers are created or a list of all VLCCs. Then it would easier to just feed in the index instrument.

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythoncommodities
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
Alex Putkov.1 avatar image
39.2k ●75 ●11 ●27

@Sudharsan.Parthasarathy

You can use the Search wizard behind the Search button in Thomson Reuters ribbon in Eikon Excel to manually set up search criteria for vessels and retrieve vessel identifiers for ships that satisfy your criteria into Excel. Unfortunately this capability is not currently available in Python. At the moment the only API that provides programmatic access to this search is the RSearch library of legacy Eikon COM APIs. Check out the tutorial on RSearch library and this previous thread discussing similar topic.

icon clock
10 |1500

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

Sudharsan.Parthasarathy avatar image Sudharsan.Parthasarathy

Thank you Alex for the confirmation. Could you also look into part 2 of the question. What is the feasibility of grouping vessels in a similar category as an index of sorts and using the index identifier to extract details of all child elements.

Alex Putkov.1 avatar image Alex Putkov.1 Sudharsan.Parthasarathy

@Sudharsan.Parthasarathy

This is a pure content question not related to the use of APIs. Personally I don't see why Refinitiv would want to create and maintain such indices. Instead we should continue improving, enhancing and expanding the search capabilities. But this is not really my area. If you feel there's a need and business justification for such indices, you can submit content enhancement request through Refinitiv Helpdesk.

Click below to post an Idea Post Idea