Getting CA.C fields via Eikon Data API

matthew.ang

My goal is to get vessel-related fields from Eikon Data API given a list of IMOs. Currently, I have the following code (that is working):

import eikon as ek

fields = ['TR.AssetLocationDate','TR.AssetName',
          'TR.AssetLocationLatitude','TR.AssetLocationLongitude',
          'TR.AssetLocationDraught','TR.AssetLocationDraughtPercentage']

ek.set_app_key('XXXX')
df, e = ek.get_data(imos, fields)

However, ideally I'd prefer to retrieve the CA.C counterparts of these fields (e.g. CA.C.Name, CA.C.LocationDraught)—I believe these are retrieved directly from AIS services.

Is there such a way to perform this on the Python Data API? (via ek.get_data() or otherwise)

Alex Putkov.1

@matthew.ang

The "CA.C.*" fields you refer to represent the metadata that was utilized in previous versions of Eikon. For backwards compatibility these fields can still be used in =RData function in Eikon Excel, but this metadata set is being phased out. "CA.C.*" fields cannot be used with Eikon Data APIs or with =TR function in Excel. "TR.*" fields in the code snippet you included replace the equivalent "CA.C.*" fields. Going forward you should utilize "TR.*" fields instead of "CA.C.*" fields.

jason.ramchandani01

Hi @matthew.ang As far as I am aware these are the correct fields and they are retrieved from the AIS services. Eikon does not carry CA.C fields. You can check this using the Data Item Browser app (type DIB into Eikon search bar) which will give you all available fields as well as parameters - if you add an IMO in the instrument field it will also return values - these should be the same as are available in the product where they use CA.C fields:

I hope this can help.

matthew.ang

https://community.developers.refinitiv.com/discussion/comment/69815#Comment_69815

Thank you very much for the answer, is it convenient to verify that the fields prefixed with "TR" and "CA.C" are identical? (e.g. they reference the same data source) Thanks in advance!