Python API - calling historical vessel data/ list of vessel RICS

stefan.greene
stefan.greene Newcomer
in Eikon Data APIs

Hello,

I am trying to extract both live and historical vessel (fixed asset) data using the python API.

1. I have successfully extracted live data using specific vessel RICs, but I would ideally like to first call a list of vessel RICs which meet a certain criteria (i.e all vessels 200k + DWT), in order to automate the process to keeping an up-to-date vessel list.

2. I have no idea how to access historical vessel voyage/positional information (if even possible).

Any help on either point would be appreciated

thanks

Tagged:

Best Answer

  • Zhenya Kovalyov
    Zhenya Kovalyov LSEG
    Answer ✓

    @stefan.greene,

    1. the python api does not have access to search at the moment, so you will only be able to operate on the list built elsewhere. Have a look at the Search > Insert formula functionality in Excel (RSearch function).
    2. To explore the data models for Commodities Physical Assets, I would recommend using the formula builder in Excel, and then replicate the output with python.

    So, you can get the series by adding SDate and EDate to your request:

    image

    This is how it translates into the api call:

    df, e = ek.get_data('C}KV7309483272', ['TR.AssetLocationLatitude.date','TR.AssetLocationLatitude', 'TR.AssetLocationLongitude'], {'SDate':'0D', 'EDate':'-1AW'})

    image

Categories